FUZZYMATCH app icon

Google Sheets add-on

FUZZYMATCH for Google Sheets

Find close-enough names, labels, and IDs with formula-first similarity, fuzzy match, and fuzzy lookup functions.

12 custom functions
Jaro-Winkler scoring
Fuzzy VLOOKUP
No external API calls
Read function docsMarketplace listing URL pending publication
Typo score=SIMILARITY("Jilian", "Jillian")0.971429
Closest row=FUZZYMATCH(A2, Customers!A2:A500, 0.86)42
Account ID=FUZZYLOOKUP(A2, Accounts!A:A, Accounts!B:B, 0.82)C-1042

CRM cleanup

Match misspelled contact and account names without exporting to a separate reconciliation tool.

Vendor reconciliation

Find close company names across invoices, payment exports, and source-of-truth vendor tables.

Reviewable matching

Return the matched key and score alongside lookup results so humans can audit borderline rows.

Function map

Similarity, lookup, and FM_ aliases

Open full reference

Similarity Scoring

SIMILARITYLEVENSHTEINJARO_WINKLER

Fuzzy Lookup

FUZZYMATCHFUZZYVLOOKUPFUZZYLOOKUP

Namespaced Aliases

FM_SIMILARITYFM_LEVENSHTEINFM_JARO_WINKLERFM_FUZZYMATCHFM_FUZZYVLOOKUPFM_FUZZYLOOKUP

Score thresholds

Tune match strictness with decimals like 0.86 or percent strings like 86%.

Review mode

Return matched keys and scores beside lookup results when a sheet needs human approval.

Private by design

Matching runs inside the spreadsheet without external API calls or server-side storage.

    xs