How to match company names in Google Sheets

By Jake Marsh · Updated

To match company names across two lists in Google Sheets, install Fuzzwell, open Extensions > Fuzzwell > Match two lists, and set the column pair's type to Company name. Fuzzwell drops legal suffixes like Inc, LLC, Ltd, Corp and GmbH, a leading "The", punctuation and accents, and treats "&" as "and", so "The Acme Widgets, Inc." and "ACME WIDGETS LLC" compare as the same company, each pair with a 0 to 100 score.

What the company name type ignores

DifferenceExample that matches
Legal suffixesNorthwind Traders Ltd = Northwind Traders Corp
A leading "The"The Harbor Group = Harbor Group
"&" and "and"Smith & Sons = Smith and Sons
Punctuation and caseA.B.C. Supply = ABC SUPPLY
AccentsCafé Nord = Cafe Nord

Other words still count. "Acme Widgets" and "Acme Tools" share a word but aren't the same company, and their score shows it.

Steps

  1. Put both lists in one spreadsheet, for example a CRM export on one tab and a billing export on another.
  2. Open Extensions > Fuzzwell > Match two lists. Set list A to the rows that need a match and list B to the rows to look up.
  3. Under Match on, pair the company name columns and set the type to Company name.
  4. Add a website or email pair if both lists have one, typed as Website or domain or Email. https://www.acme.com/about, acme.com and sales@acme.com all compare as acme.com, which settles most close calls between companies with similar names.
  5. Use weights for the column you trust most. Set the company name to Double if the website column is often blank, since blank cells don't count against a pair.
  6. Tick the columns to bring in from list B, such as account ID or owner.
  7. Pick a pairing mode. One to one: each list B row used once fits matching one account list to another. Best match for each row fits many invoices against one customer list.
  8. Click Preview (free), then Run matching, and settle the Review rows on the Fuzzwell review tab.

Example

List A (CRM)List B (billing)Status
The Acme Widgets, Inc.ACME WIDGETS LLCMatch
Smith & Sons PlumbingSmith and Sons Plumbing CoMatch
NorthwindNorthwind Traders LtdReview
Bluebird CafeBluebird BakeryReview, with a low score

Rows like "Northwind" and the two Bluebirds are why the review tab exists: a short name that could be the same company. The review tab shows up to five candidates side by side with each column's score, and your Accept or Reject is kept on every later run.

Store numbers and branches

Text that differs only in a number, like "Store 101" and "Store 102", is kept apart. If your list has one row per branch, add the city or ZIP as a second pair, or tick Must match on it.

What it costs

Every feature is in the trial: 14 days or 10 match runs, whichever comes first, no card needed. Previews and review decisions never use a run. Then it's $15 a month or $100 a year per Google account, or $399 a year for a team plan covering everyone at your company or school domain. See the Fuzzwell page to install it.

Fuzzwell: Fuzzy Match & Join Two Lists

Fuzzy match and join two lists in Google Sheets: company names, people, addresses, emails and phones, with scores and a review tab $15 a month or $100 a year per Google account.


Questions

Can VLOOKUP match company names that are spelled differently?

No. VLOOKUP needs the same text, and wildcards only help when you know which part differs. Fuzzwell scores how close each pair is after cleaning up suffixes, punctuation and "The".

Which suffixes does Fuzzwell drop?

Inc, LLC, LLP, Ltd, Corp, Co, PLC, GmbH, AG, SA, BV, Pty and many more, plus words like Holdings, Group and International at the end of a name when something else remains.

How many companies can I match at once?

Up to 100,000 rows per list. 50,000 x 50,000 rows typically finishes in a few minutes, in steps that stay inside Google's time limits.

Can I use the result to merge the two lists?

Yes. The list B columns you tick are written next to list A, so the joined table is ready once the review rows are settled.


More Fuzzwell guides


More Google guides