How should my CSV be formatted?

CSV Files have been well explained elsewhere on the internet. They’re very easy to create, and are easily exported from Microsoft Excel or Google Sheets.

The CSV Importer extension will deal with most formats of CSV files, it’s main prerequisites are:

  • .csv file extension
  • Comma-separated (goes without saying with CSV files)

A CSV with headers and multiple contacts would look something like this:

First Name,Last Name,Email,Status,Address 1,City,State,Postcode
Jane,Doe,jane.doe@mysite.com,lead,123 Main St,New York,NY,10001
Jelly,Bean,jelly.bean@mysite.com,lead,,New York,NY,10001

Each contact needs to start on its own line. There is no comma or semi-colon at the end of the line, and there should be no extra, empty lines between contacts.

If there isn’t contact data for a specific field, the empty field still needs to be included (like the ‘Address 1’ field for Jelly Bean above).

You can see an example of a CSV file format by downloading our empty sheet below, which has some example column headers already set up for you.

Download Example CSV File (Column Headers)

Updated on January 26, 2021

Was this article helpful?

Related Articles

Still not found an answer?
If you've searched the knowledge base and still can't find a solution, please submit a ticket.
CONTACT SUPPORT