View or Export a List

This feature requires Admin user level or higher.

You can view or export active, unsubscribed, and cleaned addresses for your lists at any time.

In this article, you'll learn how to access and configure your View Subscribers table, export subscriber lists or segments, and access the subscriber export history for each list.

Before You Start

Here are some things to know before you begin this process.

  • List and segment exports don't include campaign report data, like open and click rates. To download campaign report data, export a campaign report.

  • Transactional subscribers can be viewed in your MailChimp account, but can’t be exported. These subscribers are guest checkouts, customers with abandoned carts, or customers who provide their email address through your connected Shopify, Magento, BigCommerce or API 3.0 store but don’t opt-in to receive marketing from you.

  • When you export your list or segment, we'll package your file as a ZIP file. Unarchive the ZIP to access the CSV file and open it in your preferred spreadsheet application.

  • Subscriber export history and their CSVs are available in your account for 30 days.

Configure View Subscribers Table

The View Subscribers table provides basic information about the people in your list. Reorder columns or turn them on or off to configure your preferred view. When you hide columns, it doesn’t delete a list field or hide the field on your signup form.

To configure the columns on the View Subscribers table, follow these steps.

  1. Navigate to your Lists page.
  2. Click the name of the list you want to work with.
  3. Click the Toggle Columns drop-down menu.
  4. Uncheck the boxes next to the fields you want to hide or check the boxes next to the fields you want to view.
    Cursor checks box in toggle columns drop-down menu.
  5. To reorder columns, click the three dots next to any name field and drag it to your preferred location.
    Cursor clicks three dots next to name field.
  6. Click Save.

View or Export a List

You have the option to export a subscriber list when you view it in the Lists page of your account. To view or export your subscriber list, follow these steps.

  1. Navigate to the Lists page.
  2. Click the name of the list you want to work with.
  3. To export your active subscribers, continue to Step 4. To export inactive subscribers, click the All Subscribers drop-down menu and choose either Unsubscribed or Cleaned.

    Transactional subscribers can be viewed from this menu, but can’t be exported.
  4. Click  Export List.
  5. After the list export loads, click Export as CSV to download the file to your computer.

View or Export a Segment

You have the option to export a segment when you view it on the Lists page of your account. To view or export a saved segment, follow these steps.

  1. Navigate to the Lists page.
  2. Click the name of the list you want to work with.
  3. Click the Segments drop-down menu, and choose an auto-update segment.
  4. Click Export Segment.
  5. 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. Navigate to the Lists page.

  2. Click the drop-down menu next to the list you want to work with, and choose Manage subscribers.

  3. Click Groups.

  4. Click View Groups to expand the group you want to view.  

  5. Click the # subscribers link to view the individual subscribers in each group.

  6. Click Export Segment.

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

About Your Export File

Your exported CSV file displays your list fields, along with subscriber data that MailChimp collects.

  • MEMBER_RATING
    The subscriber's member activity rating.

  • OPTIN_TIME
    The time a subscriber accessed your signup form, if they used it to sign up.

  • OPTIN_IP
    The IP address used when the subscriber accessed the hosted signup form.

  • CONFIRM_TIME
    The date and time that the subscriber joined list.

  • CONFIRM_IP
    The IP address used when the subscriber joined the list.

  • LATITUDE
    Latitude for the IP address of the CONFIRM_IP.

  • LONGITUDE
    Longitude for the IP address of the CONFIRM_IP.

  • GMTOFF
    The number of hours to add or remove to UTC time to get to the time zone for that subscriber.

  • DSTOFF
    The number of hours to add or remove to UTC time to get to the subscriber's timezone, taking into account hours lost or gained due to daylight savings time.

  • LAST_CHANGED
    The date and time when information in the subscriber's profile was last changed or updated.

  • LEID and EUID
    LEID is the unique identifier for a subscriber, specific to a list. EUID is the unique identifier for a subscriber on the account level, across all lists.

View Export History

You can view or download the last 30 days of list or list segment exports from the Subscriber Exports screen. To view exports for a list, follow these steps.

  1. Navigate to the Lists page.
  2. Click the drop-down menu next to the list you want to work with, and choose Exports.

Each entry on the Exports page shows the date subscribers were exported, which user made the export, and how many subscribers were exported on that date. Click Export as CSV to download a copy of any previous export.

If you've used Twitter Tailored Audiences to export subscribers in the past, click the Filter drop-down menu to display only those exports.

Troubleshoot a List Export

If your list 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.

Was this article helpful?
What can we do to improve articles like this?

Technical Support