How Do You Export Mailchimp Contacts to Excel?

The honest statement, up front

Mailchimp does not export a native Excel (.xlsx) format. Any guide that tells you to select Excel as a Mailchimp export format is describing something Mailchimp does not offer. Mailchimp's own help says to unarchive the ZIP file to access the CSV files and open each file individually in your preferred spreadsheet application, and names Microsoft Excel, Google Sheets, and OpenOffice Calc as the programs people use to open the CSV. The opening steps themselves are Microsoft's documentation, linked from Mailchimp help, not Mailchimp's own text.

The workflow, step by step

1. Export the audience as CSV. Follow How to Export a Mailchimp Audience to CSV: Audience, then the Audience drop-down, then Export audience, then Export CSV. Wait for the completion email, or download from More options, then Export history.
2. Unarchive the ZIP. The download contains a separate CSV for each contact status: subscribed, unsubscribed, non-subscribed, and cleaned. There is no single combined file.
3. Open each status CSV individually in Excel. Do not open only the subscribed file and assume the rest are missing. Status lives in the file names, not in a single Status column.
4. Fix strange characters with UTF-8, if they appear. Mailchimp documents this exact case: change the file extension from .csv to .txt, open in Excel, and set the encoding to UTF-8 when prompted. Or open the CSV in a text editor set to UTF-8, copy all content into a blank Excel sheet, and use Text-To-Columns to split it into columns.
5. Download within 30 days. Contact exports and their CSVs are available in your account for 30 days only. Only Owners and Admins can export audiences, so a lower user level sees no export button at all.

The converter tool route

If you want one Excel-readable file instead of several CSVs, use the Mailchimp CSV to Excel Converter. Paste the CSV, convert it in your browser, and download a .xls file that Excel opens directly. Saving that file with Save As in Excel produces a native .xlsx workbook. Nothing is uploaded: the conversion runs entirely in your browser. The tool does not change the honesty rule. Mailchimp still exports CSV. The tool is the conversion step, stated plainly.

Two caps that do not apply here

Mailchimp help states two limits near this workflow, and neither belongs to audience exports. The one-export-per-24-hours cap and the allow-up-to-24-hours wording belong to whole-account exports, not audience exports. Do not plan an audience export around them. And Excel's own row limit, if you ever hit it, is a Microsoft limit, not a Mailchimp-stated limit.

What the Excel file will and will not contain

The CSVs contain audience fields except language, marketing permissions for GDPR-enabled audiences, MEMBER_RATING, opt-in and confirm times and IP addresses, geolocation fields, LAST_CHANGED, LEID, EUID, NOTES, and TAGS. They do not contain opens and clicks, signup source, purchase history, language, predicted demographics, or social profile data. Groups are not a column in the audience CSV. Export a group through the segment route instead, as covered in How to Export a Mailchimp Segment or Tag.

For every Mailchimp export method side by side, see the Mailchimp Export Methods by Destination directory. If the export looks incomplete, see How to Fix a Mailchimp Export With Missing Contacts.

Source

The no-native-Excel statement, the open-in-Excel workflow, the UTF-8 fix, the 30-day availability, the permission gate, and the contents and exclusions on this page come from Mailchimp help: View or export contacts and Export or back up data. Facts verified 2026-10-25.

This page explains how the process works and what the official help says. It is general information, not advice about your specific account or data.