Mailchimp duplicate contacts and how to remove duplicate emails across audiences before you pay for them twice
Mailchimp duplicate contacts are almost always the same email address sitting in two or more audiences. Mailchimp blocks duplicates inside one audience, but it treats the same address in two audiences as two people, and its billing counts both. DataUntangler combines your audience exports into one file, finds every repeated address in your browser, and shows each merge for you to approve before you import one clean primary audience.
Load a messy sample and watch it work
The same engine described below, running on your own machine. Nothing is uploaded and nothing is applied until you approve it.
1. Load a file
Your file is read on your own machine. Nothing is uploaded, so nothing can leak.
Or start from a messy sample
Status
Loading the sample file.
File: CRM contact export
Rows
--
Columns
--
Changes
--
Duplicate rows
--
Date formats
--
Blank or invalid emails
--
Load a file to see the diff
Drop a CSV or pick one of the messy samples. Every proposed change appears here as a line you approve or reject.
2. Review every change
Nothing approved yet.
Nothing is applied to your file until you approve it, and your original file is never modified.
Proposed changes
Original Proposed
Duplicate clusters
Merge or keep both
Want this on every file, and on bigger ones?
The free try is one file of your own. The Analyst plan cleans as many files as you need, up to 25MB and about 100,000 rows each, for $59 a month or $348 a year.
3. Take the result
The cleaned CSV contains only the changes you approved. The log lists every change, approved or not.
How Mailchimp handles duplicate contacts, and where it stops
Mailchimp documents the rule in its own help center. When you add or import contacts to a single audience, it scans for duplicates, and an address that appears twice in an import file is added once. An address that is already in the audience is not added again. Inside one audience, exact duplicate emails are handled for you.
Across audiences, nothing is checked. Mailchimp says plainly that if the same email is in two audiences, it sees that as two people, and that this could contribute to your monthly bill. Its billing rule is the total number of contacts across all your audiences, except archived and cleaned contacts, so an address in three audiences is three contacts on the invoice. Unsubscribed and non-subscribed contacts count too.
That is why teams that grew their account one audience at a time, a newsletter list, a customer list, an event list, a list from an old website form, end up paying for the same people several times. The recommendation in the Mailchimp help center is to keep a single primary audience organized with tags, groups or segments. The work is getting from several audiences to one without losing the tags and statuses that made them useful.
Does Mailchimp delete duplicates on its own?
Only inside one audience. Mailchimp skips an address that already exists in the audience you are importing into, and adds an address that repeats within the import file once. It does not look across audiences, so the same person in your newsletter audience and your customer audience stays in both and is billed in both.
It also cannot know that two different addresses belong to one person. Jane at her work address and Jane at her personal address are two contacts to Mailchimp, and they are two contacts to us as well, on purpose. Two addresses are the strongest evidence you have that a record is two inboxes, and merging them by name would mean mailing one and silently dropping the other.
Mailchimp tools against a pass on the combined export
| The duplicate in your account | Mailchimp | Pass on the combined export |
|---|---|---|
| Same email twice in one import file | Added once | Found and shown as one cluster |
| Same email already in the audience you import into | Skipped, or updated if you tick the update option | Found before the import runs |
| Same email in two audiences | Kept in both, billed in both | Found as one cluster, with the audience of each row visible |
| Same email with capitals and a trailing space | Not documented | Trimmed and lowercased, then matched |
| Same person under two different email addresses | Two contacts | Kept as two contacts on purpose |
| Tags on both copies of one person | Combine audiences tool drops tag data | Both rows shown side by side so you keep the tags |
Mailchimp states that its combine audiences tool moves subscribed contacts only, and does not transfer group or tag data, engagement metrics, member ratings, opt-in time stamps, signup sources or GDPR permissions. That is the main reason to combine through a reviewed CSV instead.
The pass is ordinary data deduplication on the email column after trimming and lowercasing, plus name and company matching for rows where one side has no address. Each cluster is built around the most complete row, and you decide what survives. If your contacts also live in a CRM, the same pass on the CRM export is covered in HubSpot deduplication and CRM data cleansing.
How to remove duplicate contacts in Mailchimp across audiences
- 1 Back up first. Mailchimp says audience actions are permanent. For each audience, open Audience, pick the audience, click Export audience, then Export CSV. The export can arrive as a ZIP with a separate CSV for subscribed, unsubscribed, non-subscribed and cleaned contacts, and it stays in your account for 30 days.
- 2 Build one file. Paste the subscribed CSVs from every audience into one sheet and add a column called Source Audience so each row remembers where it came from. Keep Email Address, First Name, Last Name, Company, TAGS and any merge fields you use. Keep the unsubscribed files separate: they must stay unsubscribed in the new audience.
- 3 Load the combined CSV into the demo at the top of this page. Nothing uploads: the file is read and matched inside your browser tab. Every cluster shows its rows side by side with the reason, such as Same email address, and a confidence level.
- 4 Approve the merges you agree with and reject the rest, then download the cleaned CSV and the audit log of every decision. Where two copies of one person carried different tags, the cluster showed both rows side by side, so add the missing tags to the kept row in the cleaned file, separated by commas, the way Mailchimp reads a Tags column on import.
- 5 Import the cleaned file into your primary audience with Tags mapped, import the unsubscribed list with the Unsubscribed status, and archive or delete the old audiences once the counts reconcile. The audit log is how you explain the smaller number to whoever approves the Mailchimp bill.
Does Mailchimp charge for duplicate contacts?
Yes, when they sit in different audiences. Mailchimp bills on the total number of contacts across all audiences, excluding archived and cleaned contacts, and an address that appears in two audiences counts as two contacts. Duplicates inside one audience are not created, so they are not billed twice.
That makes deduplication one of the few marketing cleanups with a number attached. Count the rows in your combined export, count the rows after the approved merges, and the difference is contacts you stop paying for once the old audiences are archived or deleted. Archived contacts stay in your account and do not count toward the limit, which is a safer first step than deleting them outright.
Clean the import file before it creates Mailchimp duplicate contacts
Most new duplicates arrive with a list: a webinar export, a trade show scan, a CRM sync to a second audience. If the file goes into a different audience from the one those people already live in, Mailchimp has nothing to compare it against, and the duplicates start again the day after you finished cleaning.
So run the incoming file through the same pass before it is imported, and import it into your primary audience with a tag instead of a new audience. You get one row per address, emails trimmed and lowercased, names in consistent case, states as two letter codes and dates in one format. Keeping the list tidy between imports is the routine side of data hygiene, and it is cheaper than another cleanup next year. If some of your lists live in Constant Contact instead, the same file pass is on Constant Contact duplicate contacts, and for a store list headed into Klaviyo, where SMS opt-ins split one shopper into two profiles, it is on Klaviyo duplicate profiles.
When a connected Mailchimp app is the better buy
A pass on the export fits a consolidation project: several audiences to merge into one, a contact bill to bring down, a list that has to be handed to someone with a record of what changed. A person applies the result, and that is deliberate.
If you need deduplication running inside Mailchimp on a schedule, buy a product that connects to it. Insycle connects to Mailchimp, searches all audiences by default, picks the master record by engagement such as opens or the latest interaction, and lets you preview the result and export it before Mailchimp changes. We compare it honestly, including where it beats us, on the Insycle alternative page. DataUntangler does not connect to your Mailchimp account and does not claim to. It is a data cleaning tool that gives you the file, the matching and a record of each decision, on the Analyst plan at 59 dollars a month with unlimited files. Teams that moved their B2B list to ActiveCampaign meet the same bill with a different rule, covered on ActiveCampaign duplicate contacts.
Three Mailchimp audience exports combined, run through the engine on this page
| Source audience | Email Address | Name | Result |
|---|---|---|---|
| Customers | jane.doe@harborbuild.com | Jane Doe | Kept: the more complete record |
| Newsletter | Jane.Doe@HarborBuild.com | jane doe | Same email address, confidence high |
| Events | sara.kim@lumenlabs.io | Sara Kim | Kept |
| Newsletter | SARA.KIM@LUMENLABS.IO | Sara Kim | Same email address, confidence high |
| Customers | mike.ortiz@peakfinance.com | Mike Ortiz | Left alone |
| Newsletter | mortiz@gmail.com | Mike Ortiz | Left alone: two emails, two inboxes |
Every result above came out of a real run on this file. The same run proposed massachusetts, texas and new york as MA, TX and NY, restored the leading zero on ZIP code 2110, and turned USA and U.S.A. into United States. The TAGS column was left as it was, because merging tags is your call.
What the audience boundary hides
Mailchimp checks duplicates inside the audience you are working in. Everything outside that audience is invisible to the check, and billed anyway.
Data deduplication toolsEach audience is billed on its own
An address in three audiences is three contacts, including the copies that unsubscribed from one list and not the others.
The combine tool drops context
Tags, groups, ratings, opt-in times and GDPR permissions do not come across, and only subscribed contacts move.
New lists refill the gap
Every import into a second audience starts the duplicates again, because there is nothing there to compare against.
What the combined export pass adds
Every repeated address across all audiences in one view, each cluster shown with its source audiences before anything changes, and a CSV of the merges you approved to justify the lower contact count.
Questions about mailchimp duplicate contacts
Does Mailchimp automatically remove duplicates?
How do I remove duplicate contacts in Mailchimp?
Does Mailchimp charge for duplicate contacts?
What happens to tags when you combine audiences in Mailchimp?
Does DataUntangler connect to my Mailchimp account?
Plans for when the file is bigger than the demo
Yearly billing saves 50 percent. There is no free plan, and no card is needed to use the browser demo above.
Yearly billing saves 50 percent, half the monthly price.
Switch to yearly and save 50 percent.
Analyst
Self-serveOne person with files to clean, as many as they like.
$29$59/mo
Billed $348 a year Billed monthly
- Unlimited files
- Files up to 25MB, about 100,000 rows
- Exact and fuzzy duplicate detection
- Dates, numbers, currencies, encoding and casing fixed
- Every change reviewable before you download
- Cleaned CSV and a change log, both downloadable
- Runs in your browser: files never leave your machine
- Email support
Enterprise
Several people on one invoice, a DPA on request, priced per seat.
$49$98/seat/mo
Billed $588 a seat a year, from 2 seats ($1,176) Billed monthly per seat, from 2 seats ($196)
- Everything in Analyst
- Several people on one invoice
- DPA on request
- Invoicing and purchase orders
- A named contact for support
Payment is by card through our payment provider, monthly or yearly, and you can cancel from your account at any time. The free try is one file of your own, up to 5MB, in the browser demo. Already paid? Sign in.
Related pages
- Data Deduplication Tools for CSV and Excel
- Data Hygiene for Contact Lists and CRM Records
- HubSpot Deduplication to Merge Duplicate Contacts
- CRM Data Cleansing Before Import or Migration
- Fuzzy Matching Tool for Names and Companies
- Data Cleaning Software for CSV and Excel Files
- Data Quality Tools and Software Compared
- Entity Resolution Software for Customer Records
- Excel Data Cleaning Tool Without Formulas
- Data Cleaning Services vs Doing It In House
- Address Standardization and Cleansing Software
- Salesforce Deduplication and Data Cleaning Tool
- Zoho CRM Deduplication to Merge Duplicate Contacts
- Pipedrive Duplicate Contacts Deduplication Tool
- NetSuite CSV Import With Clean and Deduped Files
- Data Scrubbing Software and Tools for CSV Files
- Constant Contact Duplicate Contacts and Emails
- Klaviyo Duplicate Profiles and Merge Profiles
- ActiveCampaign Duplicate Contacts and Merge Contacts
- QuickBooks Online Merge Vendors and Customers From One List
- Merge Customers in QuickBooks Desktop and Merge Vendors
- Salesforce Merge Accounts in Bulk from One Reviewed List
- Salesforce Merge Contacts and Merge Leads From One Reviewed List
- HubSpot Merge Contacts and Companies From a Reviewed List
Clean the file, and be able to show what you changed
Try the demo on your own CSV first. It runs in your browser, it costs nothing, and no card is required.
No card required. Your file never leaves your computer.