This feature requires Admin user level or higher.
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.
- List and segment exports don't include campaign report data, like open and click rates. To download campaign report data, export a campaign report.
- 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.
View or Export a List
- Navigate to the Lists page.
- Click the name of the list you want to work with.
- To export your active subscribers, continue to Step 4. To export inactive subscribers, click the
All Subscribers drop-down menu and choose either
- Click Export List.
- 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.
About Your Export File
Your exported CSV file displays your list fields, along with subscriber data that MailChimp collects.
The subscriber's member activity rating.
The time a subscriber accessed your signup form, if they used it to sign up.
The IP address used when the subscriber accessed the hosted signup form.
The date and time that the subscriber joined list.
The IP address used when the subscriber joined the list.
Latitude for the IP address of the CONFIRM_IP.
Longitude for the IP address of the CONFIRM_IP.
The number of hours to add or remove to UTC time to get to the time zone for that subscriber.
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.
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
- Navigate to the Lists page.
- Click the drop-down menu next to the list you want to work with, and choose
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.