Integrations
Import your Excel or CSV into Mailchimp Audience
Mailchimp keys its audience on the email address, rejects rows with an invalid or missing email, and stores extra columns as merge fields — so a raw export rarely imports cleanly. Importly validates and deduplicates on email, maps First Name and Last Name to Mailchimp's merge fields and tidies every value, so your audience import goes through without skipped or bounced rows.
Column headers Importly recognises for Mailchimp Audience
Whatever your source file calls them, Importly matches your columns to the fields Mailchimp Audience expects:
| Field in Mailchimp Audience | Recognised from headers like |
|---|---|
| Email Address | email, e-mail, mail, courriel, adresse email, adresse e-mail… |
| First Name | first name, firstname, first_name, prenom, prénom, given name… |
| Last Name | last name, lastname, last_name, nom, surname, family name… |
| Phone | phone, telephone, téléphone, tel, tél, mobile… |
| Address | address, address1, adresse, rue, street… |
How to import your file into Mailchimp Audience
- 1 Upload your Excel or CSV and pick the Mailchimp Audience profile.
- 2 Importly renames the columns, cleans every value — dates, phone numbers, amounts, countries — and drops duplicates and empty rows.
- 3 Download the cleaned file and import it into Mailchimp Audience. It maps on the first try.
Frequently asked questions
What columns does Mailchimp need to import contacts?
Only a valid Email Address is required — it's the key Mailchimp deduplicates on. First Name, Last Name and any extra data map to merge fields; Importly names them the way Mailchimp expects.
Why does Mailchimp skip rows when I import my list?
Usually invalid or empty email addresses, duplicate emails, or columns Mailchimp can't map to a merge field. Importly validates the emails, removes duplicates and cleans the columns first.
Can Importly clean my list before I import it into Mailchimp?
Yes — it checks every email, drops duplicates and blank rows, and normalises names and other fields, so you import a list Mailchimp accepts in one pass.
Stop reformatting exports by hand.
Try Importly free