Mailchimp to Excel
Emails sent, unique opens and unique clicks from Mailchimp, by campaign, in a worksheet in your own OneDrive.
- Each report writes to a worksheet you choose, in a workbook in your OneDrive.
- Refreshes every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
- Up to 1,000 campaigns a report.
Your first scheduled report starts 30 days of Plus, free. No card needed.
Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.
How to connect Mailchimp to Excel
To export Mailchimp reports to Excel you need a work or school Microsoft account with OneDrive, and a Mailchimp account you can create an API key in.
- 01In Mailchimp, create an API key. On the Sources page, choose Add key on the Mailchimp card, paste it and choose Check and save.
- 02In Fresh Sheets, go to Destinations, choose Connect Microsoft Excel and sign in with your work or school Microsoft account.
- 03Choose New report, pick Mailchimp and the account, then the fields and date range.
- 04Under Destination, pick the workbook and worksheet. Under Schedule, pick how often. Then Save and run.
Columns Mailchimp writes to Microsoft Excel
Row one holds the column names. Money shows its currency symbol when a report has only one currency.
| Column | Format |
|---|---|
| Send date | Date |
| Campaign | Text |
| Subject line | Text |
| Audience | Text |
| Campaign type | Text |
| Campaign ID | Text |
| Emails sent | Whole number |
| Unique opens | Whole number |
| Total opens | Whole number |
| Open rate | Percentage |
| Unique clicks | Whole number |
| Total clicks | Whole number |
| Click rate | Percentage |
| Unsubscribes | Whole number |
| Hard bounces | Whole number |
| Soft bounces | Whole number |
| Spam complaints | Whole number |
| Forwards | Whole number |
One row per campaign. Days follow your Mailchimp account's time zone.
An example
Insert a PivotTable on a separate worksheet that reads from the Campaign results worksheet, with Campaign in Rows and Unique opens in Values.
Scheduling and refresh
How often depends on your plan: every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
Each run that succeeds counts once towards your plan, wherever it sends.
Each run replaces the worksheet with the latest figures.
Other ways to do it
Mailchimp can download your campaign reports as a CSV file.
Fresh Sheets writes one row per campaign straight into your worksheet instead.
What this doesn't cover
Contact lists aren't included. This reads campaign reports only, and never writes to Mailchimp.
Only the worksheets your reports use
While you choose where a report goes, Fresh Sheets reads the names of the files and folders in your OneDrive and shows you only folders and workbooks. When a report refreshes, it reads and replaces that report's own worksheet. It creates a new workbook only when you ask it to, and doesn't change or delete anything else in your OneDrive.
Questions
How do I export my Mailchimp contact list?
Fresh Sheets doesn't export contact lists: it reads campaign reports only, one row per campaign. Mailchimp's own export gives you your contacts as a file.
Other sources to Microsoft Excel
Analytics
Advertising
Last checked 22 October 2026
Get your Mailchimp results into Excel
Excel is on every plan, Free included. Sign in on the web with Google or a work or school Microsoft account, connect Microsoft Excel and build your first report.
Your first scheduled report starts 30 days of Plus, free. No card needed.
Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.
Paid plans from £12 a month, billed annually. After 30 days, choose a plan or stay free: one report keeps refreshing weekly, the rest pause, and nothing is deleted.