How to configure the 'Leads' template for Mass Import

You should have already downloaded the template to mass import Leads. If you

haven’t done so, click on the ‘Step 1. Download Template’ Button as shown below.

Screen%20Shot%202019-02-05%20at%204.15.04%20pm.png


You might be asked where to save the file or it might download automatically to your

downloads folder.

Open this file in excel once downloaded.


The file will contain a simple spreadsheet with the following headers in the columns across the page:

SalutationFirst NameLast NameMobilePhoneHome PhoneOther PhoneEmail
Other EmailFax
TitleDepartmentCompanyDescriptionIndustrySub Industry
Linkedin ProfileWebsiteStreetCityState/ProvinceZip/Postal CodeCountryTags


Copy and paste your data into this table without removing any of the field headers

If you are missing some data, this is OK, it may be added later. 

It is critical that you add a 'Last Name' AND 'Company' for every lead. If this is not done, the file will not import correctly.

For the import to be successful, this file needs to be saved as a comma delimited format.

To save the file as a comma delimited format:

FOR WINDOWS

  1. Click 'Save As'
  2. The File Format should be changed to be ‘CSV UTF-8 (comma delimited) (*.csv)’
  3. Click Save as
  4. Click continue when the message below appears
Users/DavidsMacbookPro15/Downloads/Screen Shot


FOR MACS

  1. Click 'Save As'
  2. The File Format should be changed to be ‘Comma Separated Values (.csv)’
  3. Click Save as
  4. Click continue when the message below appears
Users/DavidsMacbookPro15/Downloads/Screen Shot


Now that your import file is ready to insert into Sentia, confirm by selecting 'Step 3. Done - my file is ready.'

Screen%20Shot%202019-02-05%20at%202.49.25%20pm.png


To proceed to the upload window, select 'Step 4. Upload File'.

Screen%20Shot%202019-02-05%20at%202.49.56%20pm.png


You will now be required to 'Select a file' by clicking on the 'Choose File' button. 

Users/DavidsMacbookPro15/Downloads/image (7).pn


Navigate to the template you saved earlier and open the file on the popup.

Click the 'Next' button to proceed. 


The wizard will automatically map your fields to the system. It should look like the following.


If you encounter an error and do not see this screen please ensure you have not changed or removed any field headers in the template file, and your template file is indeed saved in the .csv format. 

The 'Mapping Status' for every header should say 'Yes,' as per the screenshot above. 

Select 'Next' at the bottom of all the mapping to begin importing your file. 


After the import is complete you will see a summary screen showing information regarding your import (similar to the below). 

Users/DavidsMacbookPro15/Downloads/image (10).p


You have now inserted the Leads that were in your template. 

Follow the link to go back on screen to then see a summary of every record. Here you can make changes if required to the data. 


Use the 'Back to Sentia' button to finish the entire import process. 

Screen%20Shot%202019-02-05%20at%202.51.48%20pm.png