All articles › Contacts & Lists

Import from Mailchimp, Klaviyo or Brevo, and Fix Problem Rows

Matching columns automatically, saved mappings, the subscription status column, the preview and the error report.

Import from Mailchimp, Klaviyo or Brevo

Start as usual with Importing contacts from CSV. These parts are new.

We recognise your export

When the columns look like a Mailchimp, Klaviyo or Brevo export, the mapping step says Looks like a Mailchimp export and fills in the fields for you. Check them before you continue. A mapping you saved for the same layout comes first.

Saved mappings

On the mapping step use Save mapping to name the current choices. The next file with the same columns, in any order, is matched automatically. You can rename, update or delete saved mappings there too. A mapping needs a column mapped to Email.

Subscription status

Map a column to Subscription status (consent). Rows that say subscribed, active or yes (or are empty) are imported. Rows that are unsubscribed, cleaned, pending, non-subscribed, suppressed, no, or have a value we do not know are never imported as active contacts. They are listed in the error report. Mailchimp splits an export by status into separate files, so import only the subscribed one, or add a Status column.

Preview before you import

The validate step shows what would happen without writing anything: new contacts, contacts that already exist (and how many would change), invalid, not subscribed, duplicates in the file and suppressed, with a few examples of each.

Error report

After the import, the rows that were not imported are listed with the reason. Click Download error report (CSV) for every row. Row numbers match your file, where the header is row 1. The report is kept for 30 days.

Was this helpful?

Copy for AI (Markdown)

Related articles

Mailnaptic · Help center