Importing your contacts should come as a no-brainer, why else sign up for a CRM if it isn’t to manage your contacts from one central location. While the import is easy and fast, there are some things to consider when importing data into your CRM account.
Making a new spreadsheet
While you probably already have a file with all your contacts and their data, it probably contains additional columns or blanks fields that could disrupt your import process. To avoid any delays create a new spreadsheet where you will copy and paste your data too. You’ll need to save the spreadsheet as a CSV.
Add data & Test
Before you import your whole list, add only a few contacts or sample data and run an import test. Running an import test will allow you to see if the data was formatted correctly.Download our Sample Data to test
Adding columns for each Field Type
Field Types are the headers the CRM will read such as Name, Last Name, Email Address, Address, Phone Number, etc.
If you haven’t already mapped your CRM fields click here to learn how.
During the List Import process you will need to map your list fields.
In which the CRM will match your CSV/XLS file columns with CRM fields, so that your data gets to the right places in your new records.
You may find that some of your file column names are already matched fields correctly such as First Name, Last Name, Email Address, Address, Phone Number, etc.
Double check all fields, as some fields could be missing. it’s important to match them to the CRM field names or the data will not appear in your new records.
You don’t have to match all the CRM fields, but Last Name is required for contacts or leads.
Now that you have the basics down it’s time to import your data!