Match two lists in Google Sheets when the names don't match exactly.

Fuzzwell is a fuzzy VLOOKUP for whole tables. It pairs each row of one list with the right row of the other, even when one says "The Acme Widgets, Inc." and the other "ACME WIDGETS LLC", then brings over the columns you pick with a score and a match status. Borderline pairs go to a review tab where you accept or reject them, and every re-run remembers your decisions.

Email us to get Fuzzwell See pricing A Google Sheet of CRM accounts with four new columns from Fuzzwell: match status (Match, Review, No match) colored green, yellow and red, a score from 0 to 100, the matched billing row, and the plan, MRR and customer ID pulled from the billing export.

What it does

Company names

Drops Inc, LLC, Ltd, Corp, GmbH and "The", ignores punctuation and accents, and treats "&" as "and". The Acme Widgets, Inc. finds ACME WIDGETS LLC.

People's names

"Smith, Robert" or "Robert Smith", initials like "R. Smith", and nicknames: Bob is Robert, Liz is Elizabeth, Bill is William.

Addresses

St and Street, N and North, Apt, Suite and # are the same. A different house number or ZIP keeps two addresses apart.

Emails, websites, phones

Case, +tags and Gmail dots don't matter; https://www.acme.com/about is acme.com; (214) 555-0100 is +1 214.555.0100.

Several columns at once

Company plus contact plus email, each with a weight, combined into one score. Mark a column "must match" for hard rules like the same state.

Generic text too

Word-by-word Jaro-Winkler for typos and word order, token set ratio for extra words, and trigram overlap for spelling variants.

See every match before you trust it

The Fuzzwell sidebar previewing the first rows: each list A row with its best list B match, a score, and a Match or Review label.

Preview the first 150 rows for free, with each pair's score and the score of each column.
Choose how rows pair up: the best match for each row (like VLOOKUP), one to one (each row of the other list used once, highest scores first), or every candidate above a score on its own tab.
Two thresholds: pairs above "Match at" are matches, pairs between it and "Review from" are flagged for review, the rest say "No match".

A review loop that sticks

The Fuzzwell review tab: rows to review with their candidates side by side, a Decision dropdown with Accept chosen on one row, scores, and the list A and list B values.

The Fuzzwell review tab lists every borderline row with up to five candidates side by side. Pick Accept or Reject in the Decision column and press Apply: the results update without a new run. Decisions are saved by the content of the two rows, so they survive sorting, new rows and next month's re-run.

Built for big lists

Fuzzwell matching a 48,210-row list against a 48,159-row list, with a progress bar at 31,050 rows and about two minutes left.

Fuzzwell indexes the second list so each row is only compared with likely candidates, then runs in steps that stay inside Google's time limits. Two lists of 50,000 rows typically finish in a few minutes. Close the sidebar mid-run and press Resume later; nothing is lost and it doesn't count as a second run.

Pricing

Free for 14 days or 10 match runs, whichever comes first, with every feature. Previews and applying review decisions are always free. No card needed to try it.

$100 / year

One Google account, any number of files and runs. Renews yearly at the same price until you cancel.

$15 / month

One Google account, unlimited runs. Cancel any time from Manage billing in the add-on.

$399 / year

Team plan: everyone on your company's Google Workspace domain.

Renewals and cancelling. Subscriptions renew automatically at the price shown until you cancel. Cancel any time in the add-on (Plans and billing, then Manage billing) or by emailing us; you keep access until the end of the period you paid for. Prices are in US dollars; tax may be added at checkout.

UK and EU customers: you have 14 days from purchase to cancel and get a full refund, no reason needed. Email hello@greatwork.company.

How it compares

	Fuzzwell	VLOOKUP / XLOOKUP
"Acme, Inc." finds "ACME LLC"	Yes, with a score	No (exact or wildcard only)
People, addresses, phones, emails	Cleaned up by type before comparing	Exact text
Several columns in one score	Yes, weighted	Helper columns
One-to-one pairing	Yes	No
Review and keep decisions	Review tab, kept on every re-run	No
50,000 x 50,000 rows	A few minutes	Fast, but only for exact keys

Privacy

Fuzzwell can only open the spreadsheet you use it in (spreadsheets.currentonly). It can't see your other files, your Drive or your email.
Matching runs inside Google. Our server receives your email address and a count of runs to check your plan, nothing from your files.
We don't sell data, use it for ads, or use it to train AI. Fuzzwell's use of information received from Google APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements.
Full policy: addons.greatwork.company/privacy. Terms: addons.greatwork.company/terms.

Questions

How do I open it?

In a Sheet: Extensions > Fuzzwell > Match two lists.

Can the two lists be in different files?

They need to be in the same spreadsheet: Fuzzwell only has access to the file it's opened in. Copy or import the other list into a tab first. Two columns on the same tab work too.

What counts as a run?

Each time you press Run matching. A big run that continues over several steps counts once. Previews and Apply review decisions are free.

Where do the results go?

Into new columns next to list A (Fuzzwell status, Fuzzwell score, List B row, then the columns you picked), or onto a new tab if you prefer. A re-run writes over its own columns.

What tabs does it add?

Fuzzwell review (the rows to check), and two hidden tabs: Fuzzwell work (progress of a run) and Fuzzwell decisions (your accepts and rejects). "All candidates" mode adds Fuzzwell all matches.