How to format a CSV file

If you are planning on uploading a subscriber segment with a comma-separated value (CSV) file, use this doc to format a CSV file before uploading it.

Add Column Headers

The first row of the CSV file should contain headers for each column. If you don't currently have headers, you'll have the option to create your own headers during the formatting process. Acceptable combinations include:

  • 1 column with 'phone' in the header
  • 1 column with 'email' in the header
  • 2 columns, one with 'phone' in the header and one with 'email' in the header (the order of the columns does not matter)

When you upload your file, the header is used to match that column with an existing field. It uses the header to find any fields with the same name.

The rows in the file will be matched with existing Attentive subscribers to create a new manual segment. It will not create any new subscribers. If you would like to upload new Attentive subscribers, contact our White Glove team (

Formatting tips

  • Ensure that your CSV file contains only those columns you want to import into segments. For example, if your CSV has 10 columns, but only two of them are going to be used in Attentive, your CSV file should contain those two columns, only.
  • Your CSV file name must be less than 128 characters
  • Headers should be separated by commas
  • Each subscriber should be on a new line with a comma separating their email and phone. Do not end the row with a comma
  • If you only have one column, you will not use commas
  • If you aren’t providing an email or phone for a subscriber, leave the value empty  but DO use a comma to denote the the next column
  • Review your data to make sure that the formatting is correct before uploading the file. This will ensure you have a high match rate.

Contact if you need help uploading your CSV file.




Articles in this section

Was this article helpful?
0 out of 3 found this helpful