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:
| Difference | Example that matches |
|---|---|
| Name order | Smith, Robert = Robert Smith |
| Initials | R. Smith = Robert Smith |
| Nicknames | Bob = Robert, Liz = Elizabeth, Bill = William, Kate = Katherine |
| Titles and suffixes | Dr. Robert Smith Jr. = Robert Smith |
| Case and accents | JOSÉ GARCÍA = Jose Garcia |
Steps
- Put both lists in one spreadsheet, on two tabs or side by side. Header rows help Fuzzwell suggest column pairs.
- Open Extensions > Fuzzwell > Match two lists.
- 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).
- 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.
- 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.
- Tick the columns to bring in from list B, such as member ID or membership level.
- Click Preview (free), read a few pairs and their scores, then Run matching.
- 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) | Score | Status |
|---|---|---|---|
| Bob Smith | Smith, Robert | high | Match |
| Liz Ortega | Elizabeth Ortega | high | Match |
| J. Patel | Jay Patel | high | Match |
| Sam Lee | Samantha Leigh | between the two thresholds | Review |
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
- How to calculate driving distance in Google Sheets (Geocode & Map Addresses)
- How to count cells by font color in Google Sheets (Huecount)
- How to get Slack, Discord or Google Chat alerts before dates in a Google Sheet (Due Date Reminders)
- How to make a Google Sheets spreadsheet accessible (Includewell)