How to join two excel datasets using approximate string matching when ids don't match
- Step 1Upload File A (left file) — Drop the primary dataset — this is the file whose rows you want to enrich.
- Step 2Upload File B (right file) — Drop the reference dataset — columns from this file will be added to matched rows.
- Step 3Configure join columns and threshold — Enter the join column names from each file and set the similarity threshold (80% recommended).
- Step 4Review and download — Download the merged file. Review rows with low __match_score values manually.
Frequently asked questions
What happens to rows in File A with no match in File B?+
Unmatched rows are included in the output with '(no match)' in the __matched_value column and a match score near 0.
Can I do a many-to-many fuzzy join?+
For each row in File A, only the single best match in File B is returned. Many-to-many fuzzy joins are on the roadmap.
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.