From the View subscribers screen, you can view and export active subscribers and segments as well as the unsubscribed and cleaned addresses from your list. Below, we walk you through how to view and export subscribers from your account and also show you how to view the subscriber export history for each list.
List and segment exports do not include campaign report data, such as open and click results. To export campaign report data, you'll need to download that information from the campaign report.
In this article:
- View or export your list
- View or export a segment of your list
- View subscriber exports
- Troubleshooting the list export
View or export your list
To open the View subscribers screen, navigate to the Lists page in your account and click a list title. The View subscribers screen shows the active list subscribers by default and has options for viewing segments of your list and exporting subscribers. To view the unsubscribed and cleaned email addresses for a list, click the Subscribed drop down menu and select Unsubscribed or Cleaned.
To export subscribers, first click the Export List button to go to the Subscriber Exports page where we prepare your file for download. When the export is ready, click the Export button. Depending on the size of the subscriber export, it may take a few moments before your subscribers are ready for export.
Lists are exported in CSV format. This is a very flexible file type that can be used in Excel, Google Spreadsheets, and other spreadsheet programs.
View or export a segment of your list
To view a segment of your list, first click the
Segments drop down menu on the
View subscribers screen. Select a
saved segment or click the
New Segment button to create a different segment.
If you select a saved segment, the subscribers in that segment display on the View subscribers screen automatically. If you're creating a new segment, set your segmenting criteria then click the Preview Segment button.
Once the segment is visible, start the segment export by clicking the Export Segment button. When your export is ready, click the Export button on the Subscriber Exports screen.
View subscriber exports
Any list or segment export is viewable from the list's Subscriber Exports screen. To view exports for a list follow the steps below.
- Navigate to the Lists page.
- Click the list's drop down menu.
Subscriber Exports screen shows previous exports for a list including the export format, the date subscribers were exported, which user made the export, and how many subscribers were exported on that date.
Use this screen to export or manually delete previous subscriber exports. MailChimp automatically deletes
Subscriber Export items 30 days after the original export date. Deleted exports only remove the record of the export from the
Subscriber Exports screen and do not delete any subscribers from your list. This screen also has an option to filter between CSV or
Twitter Tailored Audiences exports.
You can also sort subscribers by field information in your list. Clicking the label at the top of each field column will arrange the viewed subscribers in ascending or descending order based on the information stored in that field for each subscriber. This is good to use if you'd like to see your subscribers ordered alphabetically for example.
This feature is for viewing purposes only, so there's not a way to save or export subscribers in the order they've been sorted in.
Troubleshooting the list export
If there is information in your list that contains special characters (like non-English-language characters), then you’re probably not seeing your list information display in Excel the way you’d expect. To see special characters in Excel, use one of the following workarounds:
- Rename the file extension to .txt rather than .csv, then open the file in Excel. When Excel prompts for the file type and character encoding, make sure the encoding is set to UTF-8.
- Open the file in a text editor, making sure the text editor’s settings are set to support UTF-8 encoding. Copy the file data 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?|
At this time, we are unable to reply to any responses, but we'll use this information to keep the site up-to-date.