You might wish to upload an Excel spreadsheet in Plecto with e.g. monthly targets or manual sales entries. This quick guide will show you how to do it in a few steps.
Before getting started you need to be aware of the following:
- Import from Excel only works with 'Custom Input' (manual data entry) data sources.
- To download our Excel template, you'll need to create a custom input data source. You do this in 'Data sources' > '+ New data source' > Choose 'Custom input' > Add fields e.g. 'Target' (if you wish to create a target data source) > Click 'Save'.
Once your data source is created, you can download our Excel template.
How to get started:
- Go to 'Data Sources' and 'Import from Excel'. Download our Excel template:
- Download the template, and fill out the data. You will end up with a spreadsheet looking like this (example data):
Please be aware of the following:
Each line in the file must represent a unique registration. Please make sure you fill out all the required fields. Each line must provide some information about the employee, so we can figure out which person you are referring to.
You can chose to provide ONE of the following:
- an E-mail, in which case the employee will be invited to join Plecto
- an External User ID and External System Name that will be used to uniquely identify the employee (External User ID can be a phone number or a random string of numbers - it just has to be unique).
NB. If you want to fill out the e-mail please be aware that we match your Plecto users on the e-mail address, so please use the same as on creation. Otherwise we'll create new users.
If you write different first- and last names than we have registered we will update with the names from the spreadsheet.
- Date: A valid date and time for the registration. Make sure to format the date correctly. Date format needs to be dd/mm/yyyy
You can leave the External ID row empty, and we will auto fill it when importing.
The External ID is a smart and easy way to later update your data. Keep the same external ID, and just upload your spreadsheet again, and we will update if any new information.
You just have to remember to use an unique ID e.g. an order number.
Upload your file:
- When the spreadsheet is filled out, simply upload it in the 'Import from Excel' page. Remember to choose the data source you want to import the excel data into.
When clicking 'Preview', we show a preview of how we think the data should be imported:
If some fields has a wrong match, you can click in the dropdown and select the correct field from the data source: