Guides

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

  1. 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.

  2. 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.

  3. 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.

  4. 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

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