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 view subscribers from your list, how to export subscriber lists or segments, and how to access the subscriber export history for each list.

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.
  4. Click  Export List.
  5. After the list is finished exporting, 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 list is finished exporting, 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