What Contact Dedup understands, with examples
Excel's Remove Duplicates only catches cells that match exactly. People rarely type the same thing twice, so most real duplicates look slightly different.
Here is what Contact Dedup recognises, and just as important, what it refuses to merge without asking you.
| In your list | What it means |
|---|---|
| Bob BrownRobert Brown | Same person, nickname |
| Zoë MartínezZoe Martinez | Same person, with and without accents |
| (415) 555-0101+1 415 555 0101 | Same number in a different format |
| J. SmithJohn Smith | Same person, but only if the phone or email matches too |
| ACME LLCAcme Inc. | Same company, if they share a website, email domain or phone. Works for company lists too. |
| Bill TurnerWilliam Turner | Could be the same person, but there are two work emails at one company. You decide. |
| Anna LeePeter Wong | Different people who share info@ and the office phone. We never merge these. |
Things to watch out for
- A shared personal email or phone is the strongest evidence. Pairs without one are never merged automatically.
- Shared mailboxes like info@ and office phones used by several people are ignored, because colleagues share them.
- Every group in the app lists the reasons for the match, so you can see why two records were put together.
Questions
Why not merge everyone with the same name?
Because common names repeat. Two David Millers at different companies are almost always two people, so same-name pairs without other evidence wait for your decision.
Does it work for company lists?
Yes. Company names are compared without legal forms like Inc. or SRL, together with website, email domain, phone and city.
More guides
- How to remove duplicate contacts in Excel, including the ones Excel missesRemove Duplicates only catches identical rows. How to find the rest.
- How to find and merge duplicate contacts in a CSV fileWhat to compare, and how not to merge two different people.
- How to clean up duplicate contacts from your phone (vCard / .vcf)Export, merge without losing photos or notes, import back.
- How to dedupe a Google Contacts exportWhen Google's Merge & fix isn't enough.
- Cleaning duplicate contacts out of a CRM exportCustomer data, sales history and why you shouldn't upload it.
- How to remove duplicates from a mailing list before you import itFewer double sends, cleaner stats, lower bills.
- How to find duplicate companies in a CRM or spreadsheetLegal forms, websites and branches in different cities.