Importing subscribers with CSV files

A comma-separated values (CSV) is the standard format for importing and exporting contacts. Gmail, Apple Mail, Outlook and all other email software all use 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" and will not receive a subscription confirmation email. Consider yourself a spammer if these people never asked to be on your list. Read more.

Here's an example of a sample CSV file:

Email, First Name, Last Name
john@doe.com, John, Doe
mary@smith.com, Mary, Smith
johnny@walker.com, Johnny, Walker

Do note that semicolons or tabs can sometimes be used instead of a comma.

If column headings are available, MailPoet will try to match headings with existing fields. Using the above CSV example, the following matches will be made:

Importing custom fields

MailPoet allows you to import custom fields that can be used to personalize your newsletter. If the custom field does not exist, you can create one during the import process. For example, we'll create and name a new "city" field:

Result:

Importing existing subscribers

Importing an already existing email address will not duplicate it. By default, MailPoet will update your subscribers' data unless you turn that option off:

Importing email addresses with statuses

If you want to define a status for a subscriber before importing it, you can do that by adding a new column in your CSV file called "Status" and then write the values:

  • For subscribed status: "subscribed" or "1"
  • For unsubscribe status: "unsubscribed" or "-1"
  • For unconfirmed status: "unconfirmed" or "0"

For example:

Email, Status
john@doe.com, subscribed
mary@doe.com, unsubscribed
alice@doe.com, unconfirmed
bob@doe.com, 1
carl@doe.com, 0
alex@doe.com, -1