Mailchimp Audience CSV to Dashboard
A Mailchimp audience export uses Mailchimp's own internal field names, "Email Address" instead of "Email", "TAGS" and "OPTIN_TIME" in all caps, "MEMBER_RATING" instead of a plain status. That's fine inside Mailchimp, but it's an awkward starting point for a breakdown. Normalize it first, since subscriber data is personal data best kept off a third-party server, this happens entirely in your browser.
Step 1: Normalize the Export
Run the raw export through the Mailchimp Normalizer. It remaps Mailchimp-specific headers onto a plain Email / FirstName / LastName / Tags / OptInDate / Status schema, keeping custom merge fields intact.
Step 2: Pick a Breakdown
Subscribers by Tag
Counts subscribers per tag on the normalized column, useful for sizing a segment before a campaign.
Subscribers by Status
Breaks down subscribed, unsubscribed, and cleaned counts.
Deduplicate Before Migrating
Check for duplicate email addresses before importing into a new ESP.
Migrating to HubSpot? →
Cross-check the normalized schema against HubSpot's contact format.
Frequently Asked Questions
Does this connect to my Mailchimp account?
No. Export your audience as CSV from Mailchimp (Audience → All contacts → Export Audience), then upload the file here. Nothing connects to your account.
Are custom merge fields preserved?
Yes, the normalizer keeps any extra custom fields Mailchimp exported alongside the standardized Email/Name/Tags columns.
Migrating an audience off Mailchimp?
Normalize the export first, no column-by-column remapping by hand.
Open Mailchimp NormalizerTurn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.