Alejandro Pacheco ยท Add-ons

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

  1. Select your list in the sheet and press Use the selected cells. Do the same for the second list.
  2. 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.
  3. Press Find matches. A new tab opens with one line per row: the best match, a score, a status and a tick box.
  4. Untick any match you don't want. The Final match column follows your ticks. Copy it wherever you need it.

Examples

List AList BResult
ACME Inc.AcmeSame once cleaned (100%)
Smith, JohnJohn SmithSame once cleaned (100%)
Globex CorporationGlobex CorpSame once cleaned (100%)
Jon SmithJohn SmithClose (90%)
InitechInitrodeNo match (too different to suggest)

Your data stays in your spreadsheet

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.