How to find duplicate companies in a CRM or spreadsheet
Company records duplicate even faster than contacts. One salesperson types "Acme Inc.", another imports "ACME, LLC" from a trade show list, and a third creates "Acme" with just a website. Reports then split the same customer's revenue across three accounts.
The tricky part is the opposite mistake: "Global Solutions" and "Global Logistics" have nothing to do with each other, and two offices of the same chain in different cities may be meant to stay separate.
Step by step
- Export the companies
In your CRM, open the list of organizations or accounts and export it to CSV or Excel with name, website, phone and city. A list of contacts with a company column works too.
- Open the file in Contact Dedup
If the file has a company column but no person names, it switches to finding duplicate companies by itself. For a contacts file, choose "companies" above the results.
- Check what it found
Names are compared without legal forms (Inc., LLC, GmbH, SRL) and accents. A shared website or email domain, or the same phone, is strong evidence. Pairs that only share a name, or sit in different cities, wait for your decision.
- Merge or download
Use the groups as a to-do list for your CRM's own merge function, which keeps deals and activities together, or download a cleaned file where each group is one row.
Things to watch out for
- Website and email domain count as one signal, since they usually say the same thing. A company with info@acme.com and a website acme.com doesn't get double credit.
- A phone number shared by unrelated companies, like the reception of a business center, is detected and ignored.
- Keep branches apart if your team sells to them separately. Pairs in different cities are never merged automatically.
Questions
Does "Acme" match "Acme Labs"?
They share a distinctive word, which counts as weak evidence. Without the same website or phone they go to review instead of being merged.
What about accents and legal forms?
Both are ignored when names are compared, so "Café Lumière SARL" and "Cafe Lumiere" count as the same name.
More guides
- What Contact Dedup understands, with examplesWhich pairs are the same person, and which are kept apart.
- 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.