Structure of the import CSV file
Import new contact list
The import CSV file must meet the following requirements:
- The first line must contain the field names of the columns
- Semicolon, comma or tabulator can be used as separator for the individual columns
- The maximum file size is 100 MB
- To be able to quote within a column, a new double quote must be added right after each double quote (see section "Example CSV file")
The following columns and values can be specified and assigned during import:
Contains the email address of the participant
Contains the gender of the participant. Possible values are "m", "f", "n".
Contains the first name of the participant
Contains the last name of the participant
Contains the language of the participant. Possible values are language abbreviation codes according to ISO-639 Norm
Contains an identification feature (ID) of the subscriber assigned by you.
For the field "email" there must be a value in each line. All other fields (first_name, last_name, ...) are optional.
In addition to these columns, you can add new columns as you wish. Except for the fact that they may be assigned only once, the names of these columns are not subject to any convention and can be freely assigned by you (see in the section "Example CSV file" the columns custom_data1 and custom_data2).
email@example.com;m;John;Doe;en;123abc;"example custom data 1";"example custom data 2"
firstname.lastname@example.org;f;Jane;Doe;en;456abc;"example custom data 1";"example custom data 2"
email@example.com;n;;;;;"example for quoting "" or ; in custom data"
Update existing contacts
For updating an existing contact list, the same rules apply as for the new import with the following exceptions:
- For the field "contact_id" there must be a value in each line. All other fields (email, first_name, last_name, ...) are optional.
If the file contains new fields, they will be added to the respective contact.