Did you encounter any problems when importing your CSV file? Or perhaps you'd like some advice on the format to use? Please follow the recommendations below.
Use a CSV file* to upload your contact lists and properties (name, phone, address, etc) to your contact list. For example:
firstname.lastname@example.org, Julie, Brown, 52
email@example.com, Dan, Wong, 19
(download sample CSV file)
* Please note: the size of your CSV file cannot exceed 20MB.
Although there is no standard structure for CSV files, there are similar rules used by many software applications and systems that need to be followed or you may experience an error when importing your CSV file:
• Each row has the same number of data values (fields)
• The header row, if present, must match the number of fields on a row
• If a value in your CSV file contains commas, it must be enclosed by double quotes (“ “). This will separate your commas from the commas that are used to delimit the fields themselves. For example, double quotes were added to the Note field values:
Email, First Name, Last Name, Age, Note
firstname.lastname@example.org, Julie, Brown, 52, "Spoke on Monday, she is interested"
email@example.com, Dan, Wong, 19, "Spoke on Friday, he is not interested"
• Ensure there are no blank lines in the CSV file
• Empty fields need to be separated by commas. For example: If no last name was given, that empty space (highlighted in yellow below) needs to be separated by a comma:
Email, First Name, Last Name, Age
firstname.lastname@example.org, Julie,, 52
• Remove unnecessary spaces at the beginning or end of each field:
✗ email@example.com, Liam, 35, ...
✗ firstname.lastname@example.org, Liam , 35 , ...
✓ email@example.com, Liam, 35, ...
• Make sure your email addresses are valid. If you did not use a confirmed or double opt-in process like our Subscription Widget when you collected the contact’s email addresses and properties, do it now. Otherwise when you import your contact lists, you may end up with a large number of invalid email addresses which will hurt your deliverability and reputation. The sooner you detect an invalid email address, the better!
Please note: It is recommended to UTF-8 encode your CSV file, especially if it contains special characters (å, é, î, ü, …). There are several ways to create a valid UTF-8 CSV file:
• Google Docs - Upload your file to a new google spreadsheet and then immediately download it:
File → Download as → Comma-separated values (.csv, current sheet)
The downloaded file will be saved with UTF-8 formatting.
• Notepad (Windows) - This default text editor allows you to save UTF-8 encoded text files.
• TextWrangler (Mac) - This is a popular and free text editor. Simply open your CSV file in TextWrangler, and save it with UTF-8 encoding.
• Apache OpenOffice (Mac, Windows, Linux) - This free, open-source office suite lets you save UTF-8 encoded text files.
If your CSV file is still not accepted by our system, our Support Team will be happy to help you -- just open a ticket and attach your CSV file!