Articles in this section

Importing and Mapping Contacts from .CSV Files

Avatar
Nik Schultz
  • Updated
Follow
SharpSpring enables you to import your contacts through a Comma-Separated Value (.CSV) spreadsheet by using the Import Tool.

In order to import the file properly, you will need to map your spreadsheet to SharpSpring.

This article will detail how to map contacts from your .CSV fields into SharpSpring fields.


Article Contents

     Available with:    
  Marketing Automation ✓  
  CRM Ultimate ✓  
  CRM PRO ✓  
  CRM Free ✓  
        
  Toolbar:    
NavMarketing.png    NavSales.png
       
  Users:    
  Administrators ✓  
  Company Managers ✓  
  Marketing Managers ✓  
  Sales Managers ✓  
  Salespersons    
  Jr. Salespersons    
 


Importing Contacts

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

   1. In SharpSpring's top toolbar, click
Contacts > Import.		  
Click to enlarge.
   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:

   •   New lists: Enter a name for the list.
   •   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:

   •   Do not update: Duplicate fields and information are not updated.
   •   Update only new: Adds information from a new column.
   •   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:

   •   Open
   •   Unqualified Leads
   •   Qualified Leads		  •   Contacts
   •   Customers
   9. Optionally, do the following:

•   Click the Overwrite Existing Lead Status? checkbox.
•   In the drop-down menu that appears, select the desired status.
 10. Optionally, do the following:

•   Click the Assign to a campaign? checkbox.
•   In the drop-down menu that appears, select the desired campaign.
 11. Optionally, do the following:

•   Click the Assign leads to a particular user? checkbox.
•   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.
  


Click to enlarge.
Important: When importing and mapping contacts, use SharpSpring fields already present in the system when possible instead of duplicating the fields. Importing and mapping custom fields with the same name as system fields results in those system fields being rendered invisible and unusable in the platform. For more information on available system fields, refer to Available SharpSpring System Fields. To restore system fields, contact SharpSpring Support.
 
Was this article helpful?
11 out of 19 found this helpful
Return to top

Related articles

×

What's wrong with this help article?

Still didn't find what you are looking for?