View or Export a List

This feature is limited to certain user levels. You can see your user level on the Users & Account Details page and this article explains what each level can access in the account.

In MailChimp, you can view and export active, unsubscribed, and cleaned addresses in your list. Below, you'll learn how to view and export subscribers from your list, 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 section of your account. To view or export your subscriber list, follow the steps below.

  1. Navigate to the Lists page.
  2. Click the name of the list you want to work with.
  3. The View subscribers table shows active subscriber. To export these subscribers, continue to Step 4. To export inactive subscribers, click the Subscribed drop-down menu and choose either Unsubscribed or Cleaned.
  4. Click the Export List button to export your subscriber 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 in the Lists section of your account. To view or export a saved segment, follow the steps below.

  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 a saved segment.
  4. Click Export Segment.
  5. After the list is finished exporting, click Export as CSV to download the file to your computer.

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 the steps below.

  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 your experience with articles like this?

Technical Support