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.
Before you start
Here are some things to know before you begin this process.
The General Data Protection Regulation (GDPR) is a European Union (EU) privacy law that gives EU citizens the right to ask about how their personal data is stored and used. If a contact requests their personal data from you, you’ll need to export directly from their contact profile instead of using the processes described in this article.
Contact exports don't include campaign report data, like open and click rates. To download campaign report data, export a campaign report.
Your export includes a ZIP file that contains separate CSV files for each type of contact (subscribed, unsubscribed, non-subscribed, and cleaned). Unarchive the ZIP file to access CSV files and open them in your preferred spreadsheet application.
Contact export history and their CSVs are available in your account for 30 days.
Configure contact table
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.
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.
Audience fields (excluding the language field)
If your audience is GDPR-enabled, this column will show each marketing permission a contact has opted into in the signup form.
The contact's relationship to your email marketing campaigns.
The time a contact accessed your signup form, if they used it to sign up. This will not show for contacts who haven’t completed the double opt-in process.
The IP address used when the contact accessed the hosted signup form. This will not show for contacts who haven’t completed the double opt-in process.
The date and time the contact clicked the link in the opt-in confirmation email.
The IP address used when the contact joined your audience.
Latitude for the IP address of the CONFIRM_IP.
Longitude for the IP address of the CONFIRM_IP.
GMTOFF and DSTOFF
Our system is based off UTC time. GMTOFF indicates the adjustment made to the time based on geolocation data, and DSTOFF takes daylight savings time into account. These are used in conjunction to determine TIMEZONE.
TIMEZONE, CC and REGION
Based on the contact’s geolocation data. This will only show data when geolocation information has been captured.
The date and time when information in the contact's profile was last changed or updated.
LEID and EUID
LEID is the unique identifier for a contact, specific to an audience. EUID is the unique identifier for a contact on the account level, across all audiences.
Notes added within the contact profile page.
If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
Click View Contacts.
Click the Manage contacts drop-down and choose Contact exports.
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.
Troubleshoot a contact export
My export includes strange or unexpected characters.
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.
Change the file extension from .csv to .txt, then open the file in Excel. When Excel prompts for the file type and character encoding, set encoding to UTF-8.
Open the CSV file in a text editor, and make sure the text editor's settings are set to UTF-8 encoding. Copy all the content from the text editor and paste it into a blank Excel sheet. Then use the Text-To-Columns function in Excel to split everything into columns.
My address field just says "US."
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.
Have another question? Paid users can log in for email or chat support.