You may import subscribers from CSV and TSV files. These files can be uploaded via the web interface, or an FTP account.
Each file that’s imported can use commas or tabs as field separators. In other words, CSV and TSV files are supported.
The default import options select commas (
,) as the field separators.
Each field should be enclosed with either single quotes or double quotes.
If the file being imported does not use field enclosures, then it should still be possible to import it as long as the field enclosure that was selected doesn’t appear. For example, if you have a file which simply contains one email address per line, this can be imported with either the
Single Quotes, or
Double Quotes Field Enclosure option selected.
The default import options select double quote (
") as the field enclosure.
This option would probably be more appropriate to label
Encoding, but the
Character Set label is currently used because it’s considered more user friendly.
Our database uses
UTF-8 character set. As a result, the default import options select
UTF-8 as the character set of files being imported.
If the file that you’re importing contains only valid
UTF-8 characters, or only
ASCII characters, then the default importation options will work.
If the file that you’re importing contains ISO-8859-1 (LATIN-1) characters, then you should select the
ISO-8859-1 (LATIN-1)character set option. This will convert the data to
UTF-8 before importing it.
If the wrong character set is selected for a subscriber import, the import process will error out when it encounters data that’s invalid in the selected character set.
You can upload files that you wish to import via either the web interface, or FTP.
Files up to 200MB in size can be uploaded via the web interface.
There are no size restrictions, other than available hard drive space imposed on files uploaded via FTP.
The first row of the file being imported is used to map the file’s fields to individual values, such as the subscriber’s email address, and custom fields:
By default, we treat the first line of files that are imported as a header row, meaning the data in this row does not get imported into the mailing list. If you wish to import the first row, select
No option in the
CSV Has Headers menu:
Custom Field Formats
See the Custom Fields page for information on what types of data are valid for each custom field type.
Email Address and Other Non-Custom Field Subscriber Data