Import From Excel

Upload an Excel spreadsheet to Plecto with monthly targets, manual sales entries, or other data. This guide will show you how.

Last updated: Nov. 3, 2021

Note: If you're using Google Sheets, you can automate the data entry process by connecting your Google Sheets to Plecto with Zapier. Read more.

Importing data from Excel spreadsheets only works with manual data sources in Plecto. To import your data from an Excel spreadsheet, you need to do the following steps:

  • Go to Data management > Data sources > + New data source and create a new custom input manual data source. It will host all your data from the Excel spreadsheet.
  • Download a template from the created data source.
  • Enter your Excel data into the template.
    • If you don't want to use a template, please adjust your Excel spreadsheet to include the required fields so that they match the fields in your Plecto data source. This step is important because Plecto needs to be able to recognize and sort the data you import from Excel.
  • Upload the Excel spreadsheet to Plecto.

Detailed instructions for each of the steps are described below in this article.

To create a manual data source, go to Data management > Data sources > + New data source.

New data source.png

An example of how to add a new data source in Plecto.

  • Scroll to the bottom of the page and choose one of the manual data source options.
Manual_data_sources.png

An example of manual data source options.

  • Plecto offers 3 templates for manual data sources: "Closed deal," "Sales target," and "Booked meetings." If you select one of these, all you need to do is click "Confirm" to create the data source.
  • If you select the "Custom input" data source, you can create your custom data source. Give your data source a title, adjust the Permissions if necessary, then click on "Save" in the bottom-right.
List of manual data sources.png

An example of manual data sources in Plecto.

Be aware: If you plan to upload a spreadsheet that contains more fields than you have in your Plecto data source, Plecto will not recognize them and thus will not be able to import them. Therefore, you should add custom fields (columns) to your manual data sources. Add the same number of custom fields as you plan to import from the Excel spreadsheet.

Add custom fields

Custom fields are additional columns in your data sources. You can add custom fields in different formats: number, text, date, list, yes/no, and country.

To add custom fields, open your data source settings in Data management > Data sources and click on the "+ Add field" button. From there, you need to fill in the details such as the field name, data type, and others. To finish, click "Save."

Add_Field_Data_Source.png

An example of the default and custom fields in a data source. The custom field names are displayed in bold.

Once you have created a manual data source, you can export a template of the data source to use in Excel. It will make it easier for you to fill in the data and upload the Excel spreadsheet to Plecto later.

Tip: If you want to upload an Excel spreadsheet to Plecto without using a template, make sure to include all the required fields (User ID, External ID, Date) and name the new custom fields in Plecto as they are in your Excel spreadsheet. This will allow you to avoid potential confusion in case you import fields with different field names.

You can download a data source template from Plecto in spreadsheet form and use it in Excel. Downloading a template is useful if you want to have a fresh Excel spreadsheet that you plan to import into Plecto later. The template will help you know how to fill in the data in the spreadsheet, and it will allow Plecto to understand what fields belong where once you upload the spreadsheet.

To download a data source template, go to Data management > Data sources > Import from Excel. Select a manual data source and click "Download Template." Plecto will generate a spreadsheet template based on the selected data source.

There are several important things to consider when entering data into your Excel spreadsheet created from a template. Plecto needs to be able to recognize and sort the data you import from Excel, so make sure to follow these guidelines:

  • Each line in the Excel file must represent a unique registration.
  • Please make sure to fill out all the required fields (stated here below).
  • User ID: Each line must provide information about an employee so that Plecto can understand which person you are referring to. Please provide ONE of the following identification options:
    • E-mail of the employee. If your employee doesn't have a profile in Plecto, you are also required to provide their first and last names. They will receive an email invitation to create a new profile. If the employee already has a Plecto account, it is sufficient to only indicate their email.
    • External User ID and External System Name that will be used to identify the employee. The External User ID can be a random string of numbers, but it has to be unique for each employee.
  • External ID: Plecto requires this field, but it is optional for you to fill out. You can leave it empty, and Plecto will auto-fill the field when importing the spreadsheet. The External ID can help you update the same data. Keep the same External ID, and once you upload your spreadsheet again, Plecto will update the registrations with the same External ID instead of creating new ones.
  • Date: Each registration needs a valid date and time. Make sure to use the correct date format, for example, 5/22/2021 or 2021-05-22. Or use "Date" format in Excel/Google Sheets. If you don't add time to the registration, Plecto will add a default time of 00:00:00 to the registration.

Be aware: If you are using the employee e-mails in the spreadsheet, please be aware that Plecto matches the users to the provided e-mails. Therefore, if your employees already have an existing account in Plecto, make sure to fill in the e-mails corresponding to their accounts. Otherwise, Plecto will create new user accounts. Each user can find their e-mail address in the account settings by clicking on the user icon in the bottom-left corner in Plecto.

If the Excel registrations contain different first and last names than in Plecto, it will update the existing names with the imported names from the spreadsheet.

When the spreadsheet is ready to be uploaded, follow the steps below to get your data into Plecto:

  • Go to Data management > Data sources > Import from Excel.
  • Select the data source in which you want to import the Excel data.
  • Click on "Choose File" and select the spreadsheet you want to import.
  • Click on "Preview" to open a preview of how Plecto thinks the data should be imported.

Note: The maximum file size you can upload is 2MB or around 10 000 rows. If the file is too large, you can split it to multiple files, then import them into Plecto.

Make sure to match the columns with the data you want to import. If some fields do not have the correct match, click on the drop-down list and select the correct field from the data source.

You can also choose not to import fields from the spreadsheet. However, if you change your mind and want to be able to see the fields after you have imported the spreadsheet, you will have to import the entire Excel spreadsheet once again.

Read more: Go to this article to find out more about the Data Sources in Plecto.

Was this article helpful?