How to match names in two lists in Google Sheets

By Jake Marsh · Updated

To match people's names between two lists in Google Sheets when they're written differently, install Fuzzwell, open Extensions > Fuzzwell > Match two lists, pick both lists and set the name column pair to Person's name. Fuzzwell then treats "Smith, Robert", "Bob Smith", "R. Smith" and "Dr. Robert Smith Jr." as the same person, gives each pair a 0 to 100 score, and writes the matched row next to your first list.

Why exact formulas miss names

A name is typed differently almost every time someone types it. VLOOKUP and XLOOKUP need the same characters, so "Bob Smith" never finds "Robert Smith", and a list written "Last, First" never finds one written "First Last". Fuzzwell's person's name type cleans both sides before comparing:

DifferenceExample that matches
Name orderSmith, Robert = Robert Smith
InitialsR. Smith = Robert Smith
NicknamesBob = Robert, Liz = Elizabeth, Bill = William, Kate = Katherine
Titles and suffixesDr. Robert Smith Jr. = Robert Smith
Case and accentsJOSÉ GARCÍA = Jose Garcia

Steps

  1. Put both lists in one spreadsheet, on two tabs or side by side. Header rows help Fuzzwell suggest column pairs.
  2. Open Extensions > Fuzzwell > Match two lists.
  3. Set list A to the list that needs a match (for example event registrations) and list B to the list you look up in (for example the member list).
  4. Under Match on, pick the name column on each side and set the type to Person's name. If the full name is split into first and last columns on one side, join them into one column first so both sides compare whole names.
  5. Add a second pair if you have one. Email, phone or ZIP alongside the name separates two different people called John Smith. Set its type to Email or Phone.
  6. Tick the columns to bring in from list B, such as member ID or membership level.
  7. Click Preview (free), read a few pairs and their scores, then Run matching.
  8. Check the borderline rows on the Fuzzwell review tab. Set Decision to Accept or Reject and press Apply review decisions in the sidebar.

Example

List A (registrations)List B (members)ScoreStatus
Bob SmithSmith, RoberthighMatch
Liz OrtegaElizabeth OrtegahighMatch
J. PatelJay PatelhighMatch
Sam LeeSamantha Leighbetween the two thresholdsReview

Fuzzwell writes Fuzzwell status, Fuzzwell score and List B row next to each registration, plus the member ID you asked for. The scores you see depend on your data and your column pairs.

Two people with the same name

Names alone can't tell two Maria Garcias apart. Add a pair that should agree, such as email or city, and tick Must match on a column that must be the same for a match, like the state. Choose One to one: each list B row used once when each member should be claimed by one registration at most.

What it costs

Fuzzwell is free for 14 days or 10 match runs, whichever comes first, with every feature and no card. Previews and applying review decisions are always free. After that it's $15 a month or $100 a year per Google account, or $399 a year for everyone at your company or school domain. Install it from the Fuzzwell page.

Fuzzwell: Fuzzy Match & Join Two Lists

Fuzzy match and join two lists in Google Sheets: company names, people, addresses, emails and phones, with scores and a review tab $15 a month or $100 a year per Google account.


Questions

How do I match names in two columns in Google Sheets?

Pick the same tab as list A and list B with a range for each column, set the pair's type to Person's name, and run. Each name in the first column gets a status, a score and its row in the second.

Does Fuzzwell know nicknames?

It knows common English nicknames, such as Bob and Robert, Liz and Elizabeth, Jim and James, and Bill and William. Two first names match when they share a nickname group.

What if first and last names are in separate columns?

Fuzzwell compares one column per side in each pair. Join first and last into one column on that side, then match it as a person's name.

Will it match names with a typo?

Yes. Small spelling differences lower the score instead of ruling the pair out, so "Jonh Smith" still scores close to "John Smith".


More Fuzzwell guides


More Google guides