How to match addresses in two lists in Google Sheets
By Jake Marsh · Updated
To match street addresses between two lists in Google Sheets, install Fuzzwell, open Extensions > Fuzzwell > Match two lists, and set the address column pair to Street address. Fuzzwell treats St and Street, Ave and Avenue, N and North, and Apt, Suite and # as the same, so "123 N Main St Apt 4" matches "123 North Main Street #4", while a different house number keeps two addresses apart and a different ZIP pulls the score down.
What the street address type does
Addresses are hard for exact formulas because the same place is written many ways. The street address type expands common USPS abbreviations before comparing, then checks the parts that must agree:
| Part | How it's compared |
|---|---|
| Street words | St = Street, Ave = Avenue, Rd = Road, N = North, and similar |
| Unit | Apt 4 = Suite 4 = #4 |
| House number | Must agree; 120 Main St and 122 Main St stay apart |
| ZIP code | A different 5-digit ZIP lowers the score, so the pair lands on the review tab at best |
| Case and punctuation | Ignored |
Steps
- Put both lists in one spreadsheet, for example a returned-mail list and your customer list.
- Get each address into one column per side. If one list splits street, city and ZIP into separate columns, match the street column as Street address and add ZIP as a second pair typed Exact (IDs, codes).
- Open Extensions > Fuzzwell > Match two lists and set list A and list B.
- Under Match on, pair the address columns and set the type to Street address.
- Add a name pair if both lists have one. A person's name or company name next to the address helps when two households share a building.
- Tick the columns to bring in from list B, such as customer ID.
- Click Preview (free) to see the first 150 rows matched, then Run matching.
- Check the Review rows on the Fuzzwell review tab, set Accept or Reject, and press Apply review decisions.
Example
| List A | List B | Status |
|---|---|---|
| 123 N Main St Apt 4, 75201 | 123 North Main Street #4, 75201 | Match |
| 40 Elm Ave | 40 Elm Avenue | Match |
| 40 Elm Ave | 42 Elm Ave | No match (house number differs) |
| 9 Lake Rd, 75201 | 9 Lake Rd, 75204 | Review (ZIP differs) |
Matching versus geocoding
Fuzzwell compares the text of two address lists. It doesn't look addresses up on a map or check that they exist. When you need coordinates, a map of the rows or driving distances, that's a different job: Geocode & Map Addresses does it in Google Sheets.
What it costs
The trial covers 14 days or 10 match runs, whichever comes first, with every feature and no card. Previews and applying review decisions are free at any time. Then 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
Does Fuzzwell work with addresses outside the US?
The street address type follows US conventions: USPS street words and 5-digit ZIP codes. For other formats, match the address as Text, which still handles word order, spelling variants and missing words, and add the postal code as an Exact pair.
Will it match an address with a different apartment number?
The unit is compared as part of the address, so Apt 4 and Apt 5 score lower than the same unit. Check those rows on the review tab.
Can I match addresses and names together?
Yes. Add both pairs. They combine into one weighted score, and you can mark either one Must match.
Does matching change my address cells?
No. The cleanup happens only for comparing. Your cells stay as they are, and results go in Fuzzwell's own columns.
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)