How to match and merge excel address fields with fuzzy joining for geo enrichment
- Step 1Normalize addresses first — Use the Header Sanitizer to standardize the address column name, and the Non-ASCII Remover to strip special characters.
- Step 2Upload address files — File A = customer addresses. File B = reference address file (e.g. delivery zones with geo coordinates).
- Step 3Set join on address column — Left column: customer_address. Right column: reference_address. Threshold: 75% (address matching requires lower threshold than name matching).
- Step 4Review matches — Download and review matched pairs — address matching may produce more false positives at lower thresholds.
Frequently asked questions
Should I use fuzzy join or a proper address normalization service?+
For large-scale address matching (100K+ rows), a dedicated geocoding API (Google Maps, HERE, Pelias) is more accurate. Fuzzy Merger is best for small-to-medium datasets where API cost is prohibitive.
What threshold is best for address matching?+
70–80% — addresses have more legitimate variation than names. Check the match report carefully for false positives.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.