Mailchimp CSV export: every column, and where it goes
Mailchimp is an email marketing platform. Its export has 13 columns, and 8 ready-made templates map it into 8 CRMs.
By Operelio teamUpdated September 26, 2026
Mailchimp import templates, by CRM
How to export from Mailchimp
From Mailchimp's own help pages, checked September 2026. Menu names can move, so the linked guide is the one to trust if they differ.
Mailchimp
Export a Mailchimp audience
- Click Audience, and choose the audience from the dropdown if you have more than one.
- Click Export audience.
- Click Export CSV and wait for the email saying the export is complete.
- Download the file. It may arrive as a ZIP with one CSV per contact status.
File: CSV (in a ZIP)
Only Owners and Admins can export audiences, and the files stay in your account for 30 days.
Every column in a Mailchimp export, and where it goes
For each column, the field it fills and the CRMs that field is in. Each CRM name opens its template.
Mailchimp's own CRM integrations
SalesforceMailchimp's own app can create Salesforce leads from Mailchimp contacts.
Mailchimp for Salesforce
Zoho CRMA Zoho CRM integration listed in Mailchimp's directory maps subscribers to Zoho contacts or leads.
Vendor guide
A live integration suits records that should keep flowing into Salesforce and Zoho CRM as they change. A template suits a file you already have, a CRM Mailchimp doesn't connect to (HubSpot, Pipedrive, Freshsales, Close, Monday.com and Copper) or records you want cleaned and mapped before they go in.
Mailchimp export questions
What columns are in a Mailchimp export?
13 columns, starting with Email Address, First Name, Last Name, Phone Number, Address, City. The full list, and where each column lands in each CRM, is on this page.
How do I export Mailchimp data to CSV?
Click Audience, and choose the audience from the dropdown if you have more than one. Click Export audience. Click Export CSV and wait for the email saying the export is complete. Download the file. It may arrive as a ZIP with one CSV per contact status. The file comes out as CSV (in a ZIP).
Which CRMs can I import a Mailchimp export into?
There are ready-made templates for HubSpot, Salesforce, Pipedrive, Zoho CRM, Freshsales, Close, Monday.com and Copper: 8 in all, each mapping the export column by column. Any other CRM can take the file too, mapped by hand in the CRM Formatter.
Does Mailchimp integrate with CRMs directly?
Yes, Mailchimp has its own integrations with Salesforce and Zoho CRM, each linked on this page. For a file you already have, or records you want cleaned and mapped first, use a template here.
Templates for other exports
Lead data and prospecting
Email marketing and ecommerce
Contacts, events and forms
Moving from another CRM
Map the export into your CRM
Pick the template for your CRM, upload the file and check every column before it goes in. The CRM Formatter runs on the Free plan, no credit card needed.