# 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](https://app.mailnaptic.com/help/contacts-and-lists/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.
