View or Export Your Contacts

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.

1. Click the Audience icon.
   
2. Click All contacts.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click the Toggle Columns drop-down menu.
5. Uncheck the boxes next to the fields you want to hide or check the boxes next to the fields you want to view.
   
6. To reorder columns, click and drag the three dots next to any name field and drag it to your preferred location.
   
7. Click Save.

View or export an audience

To view or export your entire audience, follow these steps.

1. Click the Audience icon.
   
2. Click All contacts.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click Export Audience.
5. After the export loads, click Export as CSV to download the file to your computer.

View or export a segment

To view or export a saved segment, follow these steps.

1. Click the Audience icon.
   
2. Click All contacts.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click View Segment, and choose the segment you want to export.
   
5. Click Export Segment.
   
6. After the export loads, click Export as CSV to download the file to your computer.

View or export tagged contacts

To view or export tagged contacts, follow these steps.

1. Click the Audience icon.
   
2. Click All contacts.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click the Filter by Tags drop-down menu and choose the tag you want to work with.
   
   We'll generate a segment of all the contacts in your audience with that tag applied to them.
5. From the segment view, click the Filtered By Tags drop-down menu to choose more tags. When you're done, click Export Segment.
   

After the export loads, click Export as CSV to download the file to your computer.

View or export a group

You also have the option to view a group, or export it. To view or export a group of subscribers, follow these steps.

1. Click the Audience icon.
   
2. Click Audience dashboard.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. Click the Manage Audience drop-down and choose Manage contacts.
5. Click Groups.
6. Click View Groups to expand the group you want to view.
   
7. Click the # contacts link to view the individual contacts in each group.
8. Click Export Segment.
9. After the export loads, click Export as CSV to download the file to your computer.

Open your export file

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.

Open a CSV file with Excel
Open a CSV file with Google Sheets
Open a CSV file with OpenOffice Calc

About your export file

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.

What's included

• Audience fields (excluding the language field)
• Tags
• Marketing permissions
  If your audience is GDPR-enabled, this column will show each marketing permission a contact has opted into in the signup form.
• EMAIL_MARKETING_STATUS
  The contact's relationship to your email marketing campaigns.
• MEMBER_RATING
  The contact's member activity rating.
• OPTIN_TIME
  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.
• OPTIN_IP
  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.
• CONFIRM_TIME
  The date and time the contact clicked the link in the opt-in confirmation email.
• CONFIRM_IP
  The IP address used when the contact joined your audience.
• LATITUDE
  Latitude for the IP address of the CONFIRM_IP.
• LONGITUDE
  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.
• LAST_CHANGED
  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
  Notes added within the contact profile page.

What's not included

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.

• Signup source
• Campaign engagement metrics, like opens and clicks
• Purchase history
• Language
• Predicted demographics
• Favorite email client
• Social profile data
• A complete record of contact profile updates

View export history

To view or download an export from the past 30 days, follow these steps.

1. Click the Audience icon.
   
2. Click All contacts.
   
3. If you have more than one audience, click the Current audience drop-down and choose the one you want to work with.
4. 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.