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 by doing the following:
- Go to '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 choose 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 the one used when creating the employees in Plecto. Otherwise, Plecto will create new users. If you write different first- and last names than we have registered we will update the existing first- and last name 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 YYYY/MM/DD.
You can leave the External ID row empty, and we will auto-fill it when importing the spreadsheet.
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 any new information.
Upload your file:
When the spreadsheet is filled out, simply upload it in the 'Import from Excel' page.
NB. 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 have a wrong match, you can click in the dropdown and select the correct field from the data source: