What are the rules for importing a contact file?

Follow these guidelines when formatting your contact import file: 

  • the file must be a .CSV or .TXT format
  • each value must be separated by a semicolon ;, comma , or tab       
  • the email column must be titled EMAIL
  • do not include special characters or spaces in your column headers 
  • simplify your import by using your contact attribute names as the column headers in your file

Example

EMAIL,FIRSTNAME,LASTNAME,SMS,CREATION_DATE,GENDER 
subscriber1@example.com,firstname1,lastname1,33611111111,2019-01-15,1
subscriber2@example.com,firstname2,lastname2,33611111112,2019-03-10,2
subscriber3@example.com,firstname3,lastname3,33611111113,2019-08-22,1

Additional formatting help

You may download a sample import file below and follow the example to prepare your own import file:

Learn more

 

Related articles