Nearmatch
Find the same name written differently. Match two lists in Google Sheets, or clean near-duplicate names in one list, and check every match before you use it.
Coming soon to the Google Workspace Marketplace.
What it does
Match two lists
Your customer list says "ACME Inc.", your CRM says "Acme". Nearmatch finds the best partner for every row, shows how sure it is, and names the runner-up.
Standardize one list
One column holds "Globex Corp", "Globex Corporation" and "Globex". Nearmatch groups them and suggests the most common spelling as the standard.
How it works
- Select your list in the sheet and press Use the selected cells. Do the same for the second list.
- Choose how strict the match should be. Ignoring capitals, accents and punctuation is always on. Company endings (Inc, LLC, Ltd, GmbH), word order and small words can be switched on or off.
- Press Find matches. A new tab opens with one line per row: the best match, a score, a status and a tick box.
- Untick any match you don't want. The Final match column follows your ticks. Copy it wherever you need it.
Examples
| List A | List B | Result |
|---|---|---|
| ACME Inc. | Acme | Same once cleaned (100%) |
| Smith, John | John Smith | Same once cleaned (100%) |
| Globex Corporation | Globex Corp | Same once cleaned (100%) |
| Jon Smith | John Smith | Close (90%) |
| Initech | Initrode | No match (too different to suggest) |
Your data stays in your spreadsheet
- It reads only the spreadsheet you open it in (Google's narrowest spreadsheet permission, "currentonly").
- It makes no calls to any outside server. There is no account, no tracking and no copy of your data.
- It never changes your lists. Results go to a new tab.
Read the privacy policy.
Limits
Up to 5,000 rows per list in this version. Each row is matched to one best partner; the same partner can serve several rows.
Cost
Free. If paid features are added later, the free version keeps working and any price will be shown here before you are asked for anything.
Help
Something not working, or a match that looks wrong? Write to ale@alepacheco.dev with the subject [Nearmatch]. A few example names (without private details) help most. See also support.