What formats can Mailchimp export to?

CSV for audiences, segments, tags, and reports; Excel for contacts; JSON for data exports; and direct connections to Google Sheets, PostgreSQL, BigQuery via CSV load, Power BI, Tableau, and Qlik. This directory links the guide for each format.

Which Mailchimp export format should I choose?

CSV for moving data anywhere, including PostgreSQL and BigQuery. Excel for a human-readable contact list. JSON for programmatic use. A live connection — Google Sheets, Power BI, Tableau, Qlik — for dashboards that must stay current without re-exporting.

Does Mailchimp export directly to BigQuery or Salesforce?

Not directly to BigQuery — the route is a CSV export plus a BigQuery load. Salesforce connects through an integration, not an export. Both routes have dedicated guides linked below.

Mailchimp Export Guides by Format

CSV exports

How to Export a Mailchimp Audience to CSV: the audience export, the starting point for most moves.
How to Export a Mailchimp Segment or Tag: a slice of the audience, not the whole list.
How to Export a Mailchimp Campaign Report: opens, clicks, and sends per campaign.
How to Export Mailchimp Automation Reports: the automated-journey reports.
How to Export a Mailchimp Campaign With Images: the campaign content, not just the numbers.
How to Fix Mailchimp Export Missing Contacts: when the export and the audience disagree.

Spreadsheet formats

How to Export Mailchimp Contacts to Excel: the contact list as a workbook.
How to Export Mailchimp Data to Excel: the broader data export in Excel form.
How to Export Mailchimp Contacts to Google Sheets: contacts into Sheets.
How to Export Mailchimp to Google Sheets: the Sheets connection route.
Automate Mailchimp Exports to Google Sheets: scheduled Sheets refreshes.

Structured data and databases

How to Export Mailchimp Data to JSON: the JSON export for programmatic use.
How to Export Mailchimp Data to Postgres: the PostgreSQL route.
Mailchimp CSV to PostgreSQL Converter: paste a CSV export, get CREATE TABLE and INSERT statements in the browser.
How to Export Mailchimp Data to BigQuery: CSV export plus BigQuery load; no native export exists.

Dashboards and analytics tools

Export Mailchimp to Power BI: the Power BI connection.
How to Connect Mailchimp to Tableau: the Tableau connection.
How to Connect Mailchimp to Qlik: the Qlik connection.

CRM and sending setup

How to Connect Mailchimp to Salesforce: the Beaufort 12 integration for setups after May 1, 2024.
How to Set Up DKIM for Mailchimp: domain authentication for Mailchimp sending.
DKIM Record Generator: generic DKIM records for any sender.

Backup and sharing

How to Back Up Your Mailchimp Account Data: the full-account backup.
How to Share a Mailchimp Campaign Report: sharing a report without exporting it.

For exports organized by where the data is going rather than its format, see the Mailchimp Export Methods by Destination directory.

Source

Sources: the Mailchimp export guides on this site, verified on the dates stated in their own Source sections; the BigQuery, Salesforce, and DKIM guides in this batch, verified 2026-11-01. Facts verified 2026-11-01. Open flags: the Spanish-language campaign-export guide is not listed here because this directory covers English-language format guides; the destination directory covers the same guides by destination.

This page explains how the process works and what the official rules say. It is general information, not legal advice. For a dispute about your specific situation, talk to your state motor vehicle agency or court.