Import Contacts to Mailchimp
Learn how to use our import tool to add or update contacts in Mailchimp.
After you've collected a number of contacts in Mailchimp, you may want to export those contacts into a CSV file. You can export an entire audience, a segment, or a group. Exports can include subscribed, non-subscribed, unsubscribed, and cleaned contacts.
In this article, you'll learn how to view and export your contacts, and access the export history for each audience.
Here are some things to know before you begin this process.
The contact table provides basic information about the contacts in your audience. Reorder columns or turn them on or off to configure your preferred view. When you hide a column, it doesn't delete the corresponding audience field or hide the field on your signup form.
To configure the columns on the contact table, follow these steps.
To view or export your entire audience, follow these steps.
To view or export a saved segment, follow these steps.
To view or export tagged contacts, follow these steps.
After the export loads, click Export as CSV to download the file to your computer.
You also have the option to view a group, or export it. To view or export a group of subscribers, follow these steps.
How you open your export file depends on the spreadsheet program you use. You can open the file with any spreadsheet program, but we find most people use Microsoft Excel, Google Sheets, or OpenOffice Calc.
Here are some links to show you how to open files in these programs.
Your exported CSV file displays your audience fields, along with contact data that Mailchimp collects. If you have GDPR-friendly forms enabled for your audience, the CSV file header will match the GDPR form field label in your segments.
Here are some examples of data that is not included in your audience export. For GDPR compliance purposes, some of this data can be exported from an individual contact’s profile.
To view or download an export from the past 30 days, follow these steps.
Each entry on the Exports page shows the date contacts were exported, who made the export, and how many contacts were exported on that date. Click Export as CSV to download a copy of any previous export.
If your data contains special characters, your export may not display correctly in Excel. To see special characters in Excel, use one of these workarounds.
When physical addresses are imported incorrectly, our import tool inserts “US” as the default value. You’ll need to reformat and re-import your original file in order for Mailchimp to read, store, and export the address data correctly. To learn more about how to properly format physical address data in Mailchimp, check out our format guidelines. After your file is corrected, perform an auto-update import to fix the address fields.