Help center › Newsletter

Importing and exporting subscribers

On Subscribers, Import loads subscribers from an Excel or CSV file (optionally into a chosen list), and Export downloads the currently filtered subscribers to an Excel file.

Import

  1. On Subscribers, click Import.
  2. Choose the file (xlsx, xls, csv or txt, up to 10 MB).
  3. Optionally pick a Target list – imported subscribers are added to it.
  4. Click Start import.

The first row is the header. The email column is required; first_name, last_name, status (active, unsubscribed, bounced or complained), consent_at (consent date) and consent_source are optional. Without a status, new subscribers are active.

Existing subscribers are recognised by email address: only their name is updated, not their status – so someone who unsubscribed does not become active again through an import. New addresses are created and their deliverability is checked automatically. Afterwards you see how many subscribers were created and updated, and which rows failed (for example because of a missing or invalid email address).

Export

Export downloads the subscribers matching the current filter (search, status, list) to an Excel file with these columns: email, first name, last name, status, consent date and source, lists.

Exporting only needs view access to the module; importing requires the manage permission.