Fuzzwell matches the rows of two lists in Google Sheets™ when the keys aren't typed the same way, and brings over the columns you need. It's a VLOOKUP that knows "The Acme Widgets, Inc." and "ACME WIDGETS LLC" are the same company, even if the two people who typed them never met.
PRICING, STATED UP FRONT
- Free for 14 days or 10 match runs, whichever comes first, with every feature.
- Then $15 a month or $100 a year for one Google account, or $399 a year for everyone on your company's Workspace domain.
- Previews and applying review decisions are always free.
- You're only charged if you start a checkout, renewals are shown before you pay, and you can cancel any time.
TWO LISTS IN, ONE JOINED TABLE OUT
- Pick list A (the rows that get a match) and list B (the rows to look up): two tabs, two ranges, or two columns on one tab.
- Pick the column pairs to compare. Fuzzwell suggests them from the headers and detects each column's type.
- Preview the first 150 rows for free, then run. Fuzzwell writes a match status (Match, Review, No match), a score from 0 to 100, the matched row number and the list B columns you picked next to list A, or onto a new tab.
MATCHING THAT KNOWS WHAT IT'S LOOKING AT
- Company names: Inc, LLC, Ltd, Corp, GmbH, "The", punctuation and accents are ignored; "&" equals "and".
- People's names: "Last, First" or "First Last", initials ("R. Smith"), nicknames (Bob = Robert, Liz = Elizabeth), titles and suffixes ignored.
- Addresses: St/Street, Ave/Avenue, N/North, Apt/Suite/# compare equal; a different house number or ZIP keeps addresses apart.
- Emails (case, +tags, Gmail™ dots), websites and domains (https://www.acme.com/about = acme.com = sales@acme.com), phone numbers (digits only, country code 1 optional).
- Any other text: the best of word-by-word Jaro-Winkler, token set ratio and trigram overlap, with a guard so "Store 101" never matches "Store 102".
- Several columns combine into one weighted score; mark a column "must match" for hard rules.
YOU DECIDE THE BORDERLINE ONES
- Two thresholds: "Match at" (85 by default) and "Review from" (70).
- The Fuzzwell review tab lists every borderline row with up to five candidates side by side and the score of each column. Pick Accept or Reject, press Apply: results update without a new run.
- Decisions are saved by the content of the rows, so they survive sorting and new data, and every later run keeps them.
PAIR THEM YOUR WAY
- Best match for each row (like VLOOKUP), one to one (each list B row used once, highest scores first), or every candidate above the review score on its own tab.
50,000 ROWS A SIDE
- List B is indexed so each row is compared only with likely candidates. 50,000 x 50,000 rows typically finishes in a few minutes, in steps that stay inside Google's time limits.
- Close the sidebar and press Resume later; a resumed run isn't counted twice.
WHY PEOPLE SWITCH
- The price is on the listing and in the sidebar before any run, and every feature works in the trial. No card needed.
- Whole tables in one run, several columns at once, instead of one cell against a range.
- Every candidate above a score when you want them, instead of best match only.
- Case, accents, punctuation and legal suffixes never matter.
- A licensing hiccup never blocks a run (the add-on falls back to your last known plan), and a person answers email within a business day.
GET STARTED
In your spreadsheet, open Extensions > Fuzzwell > Match two lists, then pick the two tables and the columns to compare.
PRIVACY
- Fuzzwell can only open the spreadsheet you're using it in. It can't see your other files, your Drive™ or your email.
- Matching runs inside Google; our server only sees your email address and a run count to check your plan.
Made by Great Work, a small software company. Questions go to hello@greatwork.company and a person replies within one business day. (We're the ones with the duck.)
Google™, Google Sheets™, Gmail™ and Google Drive™ are trademarks of Google LLC. Fuzzwell is not affiliated with or endorsed by Google.