How to Find the Same Company Written Several Ways in a Lead List (Acme Inc, ACME, The Acme Company)

To find the same company written several ways, clean each name (lower case, punctuation out, Inc, LLC and The removed), group rows that share the cleaned name, and join groups whose contacts use the same company email domain. Excel's Remove Duplicates sees "Acme Inc.", "ACME, Inc" and "The Acme Company" as three companies. A person reading the list sees one. The free duplicate company finder groups the variants, shows every spelling it found with row counts, and gives you a file with a suggested name and group number for each row.

Find duplicate company names →

Why variants matter for outreach

• The same account gets mailed as strangers. Three reps, or three steps of one sequence, each contact a different person at "Acme", with no idea the others have written.
• CRM accounts split. Import "Acme Inc." and "ACME, Inc" and you have two account records, with the activity and deals divided between them.
• Segments and counts lie. "Companies in this list: 4,100" turns out to be 3,600. Account-based targeting and reporting are wrong from the start.
• Personalization breaks. A merge field of "ACME, INC" in an opening line reads as a mail merge. Personalization lines from CSV columns covers why the cleaned name matters there.

This is the company-level version of the problem in finding duplicate contacts with different emails, which matches people. Do both.

Step 1: clean the name into a key

The tool turns each company name into a comparison key:

1. Lower-case everything.
2. Replace & with "and".
3. Remove punctuation (commas, full stops, hyphens, brackets).
4. Remove legal and filler words: inc, incorporated, llc, ltd, limited, corp, corporation, co, company, gmbh, plc, llp, lp, sa, bv, ag, pty and a leading "the".
5. If that leaves nothing (a company literally named "The Company"), keep the original words.

So "Acme Inc.", "ACME, Inc" and "The Acme Company" all become "acme". That's the same logic you can apply in a spreadsheet with a helper column and a few text functions.

The limits are worth knowing. This removes endings, it doesn't understand meaning. "IBM" and "International Business Machines" stay apart, and so do "Acme" and "Acme Holdings" (the word "holdings" isn't in the list). Those need a person.

Step 2: add the email domain as a second signal

Names alone miss variants. "Northwind Traders" and "Northwind Logistics" share a word and nothing else the key can use, but if every contact in both groups writes from northwind.example, the evidence says one company.

The tool reads the domain from each row's email address and links rows that share a company domain, with one important exception: personal mailboxes are ignored. A row at gmail.com or outlook.com proves nothing about the company, because millions of unrelated people use it. Only addresses at a company's own domain are used.

The result is a set of groups. Each group can hold several spellings, and the tool reports:

• Names as typed, and companies after grouping, so you can see how much the list shrinks.
• Companies with several spellings, with each spelling and its row count.
• Rows that would be renamed to the group's suggested spelling.
• Groups with one spelling but several domains, which you should look at before treating them as one.

Step 3: pick one spelling

The suggested name for each group is the spelling used most often, and the first one seen if there's a tie. That's a reasonable default because the most common spelling usually came from the best source. But look at the list before you accept it:

• Prefer the spelling on the company's own website.
• Keep the legal ending only if your CRM or invoicing needs it.
• Use consistent capitalisation across the file.

The output is the original list plus two new columns, "Suggested company name" and "Company group". You can import the group number into your CRM as a custom field, or replace the company column once you're happy. Because the original stays alongside, nothing is lost.

Step 4: review what shouldn't be merged

Merging on a name is a guess about what a human would call the same thing. Three cases need a look:

1. Same name, different domains. "Phoenix Consulting" in Arizona and "Phoenix Consulting" in Oxford are different companies. The tool flags groups with one spelling and several domains so you can check.
2. Franchises and subsidiaries. A bank's regional entities may share a name and have separate buyers. Whether they're one account is your call.
3. Short or generic names. "Global" or "Pacific" in a name can mean that an unrelated pair matches after the endings are stripped. Check the highest-count groups first.

Spend your review time on the groups with the most rows. Fixing a 40-row group matters more than fixing a 2-row one.

Step 5: verify before you import or send

Once the company column is clean, the list is better organised, but it hasn't become more deliverable. Account lists are the ones most likely to be old: the same companies appearing under several spellings usually means several sources were merged, and some of those sources are older than others. Before the file goes into a CRM or sequence:

1. Remove duplicate addresses (merging lead lists without duplicates).
2. Verify the emails. Valid rows go in. Invalid rows are suppressed and recorded. Catch-all and risky rows go in a smaller, slower group; what to do with catch-all emails explains why that group exists.
3. Import, with the group number as a field.
4. Sequence the account, not just the row: stagger the contacts at one company so they don't all land the same day.

The finder passes the addresses in your file to the verifier when you finish, so you can go straight to step 2.

Quick answers

• Does it change my company column? No. It adds suggested-name and group columns.
• Does it run in my browser? Yes.
• What if a row has no company? It's counted as blank and left out of grouping.
• What if the file has no email column? Grouping works on names alone, without the domain signal.

Try it on your own list

Upload a sample at /verify. The first 100 checks are free with a Google sign-in, no card.

Pro, $39 a month: Unlimited email verification.* Never metered, never cut off. See pricing.

*Fair use: the first 100,000 checks a month at full speed, then slower, never cut off.