Importing subscribers with a CSV file

A Comma-separated values, or CSV, is the standard file for importing and exporting contacts. Gmail, Apple Mail, Outlook and all the other email software uses this format.

Notepad on Windows or TextEdit on Mac handle these files. Lists in Excel files can be saved as a CSV.

Imported subscribers are automatically "confirmed": they won't get an email asking them to confirm their subscription. Consider yourself a spammer if these people never asked to be on your list. Read more.

Here's an example of what a simple CSV file looks like:

Email, Name
john@doe.com, John Doe
mary@doe.com, Mary Doe
johnny@doe.com, Johnny Doe

The first line with "Email" and "Name" shows the required column headers. Without those, MailPoet won't be able to import.

Download an  example CSV file with a dozen fake emails to see what it looks like.

The following won't work because of the missing Email and Name on the first line:

john@doe.com, John Doe
mary@doe.com, Mary Doe
johnny@doe.com, Johnny Doe

Do note that semicolons might be used instead of a comma, like this:

Email; First Name; Last Name
john@doe.com; John; Doe
mary@doe.com; Mary; Doe
johnny@doe.com; Johnny; Doe

MailPoet will try to match the columns when importing. Using the above CSV example, this is what the MailPoet importer proposes for column matches:

MailPoet may not import all data from multi column CSV files. Columns will be shown in the importer, but it may ignore them in some cases. For example, a MailChimp CSV will have quite a few columns ignored by MailPoet:

Email Address,First Name,Last Name,Untitled,Grouping 1,MEMBER_RATING,OPTIN_TIME,OPTIN_IP,CONFIRM_TIME
john@doe.com,John,Doe,,,2,,,29/05/10 16:18
mary@doe.com,Mary,Doe,,,2,,,05/10/11 11:03
johnny@doe.com,Johnny,Doe,,,2,,,05/10/11 11:03

Importing Custom Fields

MailPoet now supports Custom Fields for your subscribers, so you can use them to personalize your newsletters. When you are importing your subscriber list, just make sure you select these other columns as custom fields:

Import twice, no duplicates

Importing an already existing email address will not duplicate it.

Be aware that your existing subscribers' data will be overwritten.

Import unsubscribed email addresses

You might want to included your unsubscribed subscribers the first time you import. This is a good way to prevent you sending to previously unsubscribed folks with MailPoet.

The first subscriber is subscribed, the second is unsubscribed:
Email, Status
john@doe.com, 1
mary@doe.com, -1

Error: “Data is not corresponding”…

A few users have had this error just after importing.

The solution is to change folder permissions to 777 for wp-content/uploads/wysija/import.

If this sounds like nonsense to you, read this article on the WordPress codex. You will need FTP access to your site!