In this article, you'll learn how to format each column in your file to get the best results when you import your contacts.
Preferred data format
| Data | Format |
| Name (required) | First and last name |
| Email (required) | example@email.com |
| Organization (optional) | Name of organization |
| Department (optional) | Name of department |
| Job Title (optional) | Your job title |
| Phone Number (optional) | International format. For U.S. phone numbers, choose the (###) ###-#### format. |
| Address (optional) | All parts of the address must be separated into individual columns. |
How to format your file
- The only mandatory headers are name and email
- The expected delimiter between columns is the comma (,)
- The headers should be in the first line of the file
- Duplicate entries (contacts with the same email) will be ignored
- The only accepted file format is CSV
File type support
Prepare the contacts you would like to import (in a tool such as Excel) and save it as a CSV file. Data that is not saved as a CSV file can't be uploaded into our system.
Field type support
Text
Insert info here
You must include an email address column in your file with only one email for each contact. Be mindful of syntax errors, such as unsupported characters and extra space.
Address
To make sure addresses are imported successfully, separate each part of your address into a different column. Column names can include: Address, City, State, Zip code and Country.
Phone
The phone field uses international format by default. For U.S. phone numbers, choose the (###) ###-#### format.
Zip code
Insert info here
Sample CSV template
If you do not already have a CSV file, or you want to start from scratch, you can use our CSV template below to get started.