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
| Difference | Example that matches |
|---|---|
| Legal suffixes | Northwind Traders Ltd = Northwind Traders Corp |
| A leading "The" | The Harbor Group = Harbor Group |
| "&" and "and" | Smith & Sons = Smith and Sons |
| Punctuation and case | A.B.C. Supply = ABC SUPPLY |
| Accents | Café 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
- Put both lists in one spreadsheet, for example a CRM export on one tab and a billing export on another.
- 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.
- Under Match on, pair the company name columns and set the type to Company name.
- Add a website or email pair if both lists have one, typed as Website or domain or Email.
https://www.acme.com/about,acme.comandsales@acme.comall compare as acme.com, which settles most close calls between companies with similar names. - 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.
- Tick the columns to bring in from list B, such as account ID or owner.
- 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.
- 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 LLC | Match |
| Smith & Sons Plumbing | Smith and Sons Plumbing Co | Match |
| Northwind | Northwind Traders Ltd | Review |
| Bluebird Cafe | Bluebird Bakery | Review, 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
- How to match addresses in two lists in Google Sheets
- How to match names in two lists in Google Sheets
More Google guides
- How to calculate driving distance in Google Sheets (Geocode & Map Addresses)
- How to count cells by font color in Google Sheets (Huecount)
- How to get Slack, Discord or Google Chat alerts before dates in a Google Sheet (Due Date Reminders)
- How to make a Google Sheets spreadsheet accessible (Includewell)