Does Mailchimp export directly to Excel format?

No. Mailchimp's native report and data exports are CSV spreadsheets, so the Excel step is importing that CSV — there is no native .xlsx export to click.

How do I import a Mailchimp CSV into Excel?

In Excel, go to Data → Get Data → From File → From Text/CSV, select your CSV file, click Import, check the preview, then click Load.

Why not just double-click the CSV file to open it in Excel?

Double-clicking lets Excel guess the delimiter and column types, which can scramble data and strip leading zeros; importing through Data → From Text/CSV lets you confirm the delimiter and preview the columns before loading.

What should I do after the data loads?

Save the workbook as .xlsx with File → Save As so your formatting and formulas live in Excel's own format — the original CSV stays untouched as your export copy.

How to Export Mailchimp Data to Excel

The Mailchimp-to-Excel route in one table

Question	Answer
Native .xlsx export?	No. Mailchimp's native report and data exports are CSV spreadsheets, so the Excel step is importing that CSV — there is no native .xlsx export to click.
Import path (current Excel)	In Excel, go to Data → Get Data → From File → From Text/CSV, select your CSV file, click Import, check the preview, then click Load.
Why not double-click?	Double-clicking lets Excel guess the delimiter and column types, which can scramble data and strip leading zeros; importing through Data → From Text/CSV lets you confirm the delimiter and preview the columns before loading.
After loading	Save the workbook as .xlsx with File → Save As so your formatting and formulas live in Excel's own format — the original CSV stays untouched as your export copy.

What makes the Excel route different

This page is not about a Mailchimp button — there is not one for Excel. It is about the second half of the journey: Mailchimp hands you a CSV, and Excel's job is to interpret it. That interpretation is where exports get quietly damaged. Open a CSV by double-clicking and Excel guesses the delimiter, the encoding, and every column's type; a ZIP code, a subscriber ID with leading zeros, or a date in an unexpected order can come out wrong with no warning. The import path exists precisely to remove the guessing: you see the preview, confirm the delimiter, and only then load. Older Excel versions offered a Text Import Wizard with Delimited and column-format choices; current Excel 365 routes the same job through Power Query's From Text/CSV step, which is the path described here.

The process, step by step

Export from Mailchimp first. For a campaign report, follow the campaign report guide (Campaigns → View report → Actions → Export CSV); for a flow, follow the automation reports guide. Save the CSV somewhere you can find it.
Import, don't double-click. In Excel, go to Data → Get Data → From File → From Text/CSV, select your CSV file, click Import, check the preview, then click Load.
Check the preview before you load. Double-clicking lets Excel guess the delimiter and column types, which can scramble data and strip leading zeros; importing through Data → From Text/CSV lets you confirm the delimiter and preview the columns before loading. If a column looks merged into one, the delimiter is wrong — go back and change it.
Save as a real workbook. Save the workbook as .xlsx with File → Save As so your formatting and formulas live in Excel's own format — the original CSV stays untouched as your export copy.
For a repeat import, reuse the query. Because this route creates a Power Query connection, refreshing the same report next month means replacing the source CSV and refreshing — not re-doing the import by hand. For a shared, always-fresh copy instead, the Google Sheets guide covers the live-sync option.

Other Mailchimp destinations

Other Mailchimp destinations: How to Export Mailchimp to Google Sheets and How to Export Mailchimp Data to JSON.

Source

The Mailchimp side (CSV exports) comes from Mailchimp's own help documentation: Mailchimp — Download a Campaign Report. The Excel side comes from Microsoft's own documentation and community guidance describing the current Data → Get Data → From File → From Text/CSV path and the older Text Import Wizard: Microsoft Support — Import or export contacts using a .csv file. Facts verified 2026-10-24.

This page explains how the process works and what the official documentation says. It is general information, not advice about your specific account or data — exported reports contain your campaign performance, so keep the workbook somewhere only people who should see it can reach it.