SharpSpring enables you to import your contacts from a Comma-Separated Value (.CSV) files by using their Import Tool. 


In order to import the file, you need to understand how to setup the CSV file and map the fields to SharpSpring.



Firstly, you need to create a CSV list of Contacts. If using Google Sheets, here's how to download the sheet as a CSV.



Importing Contacts


To import contacts through the Import Tool, do the following:


  1. In SharpSpring's top toolbar, click Contacts > Import.
  2. Click Choose a File.
  3. Select the .CSV file to import. 
  4. Click Upload .CSV File.
  5. On the Import Contacts page, under List Settings, select either New List or Use Existing List.
  6. Depending on the list type, in the List Name text box, do one of the following:
    1. New lists: Enter a name for the list.
    2. Existing lists: Enter the name of the desired existing list to add contacts to.
  7. In the How Should We Handle Duplicates? drop-down menu, select from the following options:
    1. Do not update: Duplicate fields and information are not updated.
    2. Update only new: Adds information from a new column.
    3. Update new and existing: Updates all fields and information in the record.
  8. In the Import Unassigned Leads in List As... drop-down menu, select one of the following:
    1. Open
    2. Unqualified Leads
    3. Qualified Leads
    4. Contacts
    5. Customers
  9. Optionally, do the following:
    1. Click the Overwrite Existing Lead Status? checkbox.
    2. In the drop-down menu that appears, select the desired status.
  10. Optionally, do the following:
    1. Click the Assign to a campaign? checkbox.
    2. In the drop-down menu that appears, select the desired campaign.
  11. Optionally, do the following:
    1. Click the Assign leads to a particular user? checkbox.
    2. In the drop-down menu that appears, select the desired user.

Mapping Fields


When importing .CSV files, SharpSpring tries to automatically map certain standard fields like First Name, Last Name, and Email. 


It is not always able to do so, but you may see fields already mapped.


You can reassign these fields if you do not want to map them how SharpSpring tries to map them for you.


To map contacts when importing .CSV files, do the following:


  1. Import an applicable .CSV file.
  2. In the field text boxes, select the appropriate fields to map to.
  3. Optionally, click the Make Custom Field box to import the column as a custom field.
  4. Repeat as necessary for all applicable fields.
  5. Click Import.
  6. In the pop-up window that appears, type Confirm.
  7. Click Import.