Love Data Tools
Simple tools for your data.

Match Tools

Fuzzy Match CSV & Excel Files

Match similar records even when the text is not exactly the same. Find close names, addresses, companies and other values using confidence-based matching.

Fuzzy Match

Match similar records even when names, addresses or other text are not written exactly the same way.

File A

Your source file — the records you want to find matches for.

Drop CSV or Excel here

XLSX and CSV supported

File B

Your reference file — the records File A will be matched against.

Drop CSV or Excel here

XLSX and CSV supported

Your files are processed locally in your browser and are never uploaded to Love Data Tools.

Find near matches

Match records such as Acme Ltd and ACME Limited, or slightly different names and addresses.

See confidence scores

Every result shows how closely the best candidate matches your source record.

Spot uncertain matches

Ambiguous results are flagged when another candidate scores almost as highly as the best match.

What is fuzzy matching?

Exact matching only finds values that are identical. Fuzzy matching measures how similar two values are, which makes it useful when real-world data contains spelling differences, abbreviations, punctuation changes or inconsistent formatting.

You can match using one field or combine several fields, adjust the minimum confidence threshold and review ambiguous results before downloading the matched data.

Help us improve Love Data Tools

We use Google Analytics to understand which pages and tools are useful. Your spreadsheet contents and filenames are not sent to analytics.

Privacy Policy