Fuzzy Match for Excel

Fuzzy Matching for Excel

Supercharge your Excel workflows with powerful approximate text matching. Our Fuzzy Match add-in brings professional-grade string comparison algorithms directly into your spreadsheets, allowing you to link data that isn't an exact match.

Functions

• FUZZY.LOOKUP: Like XLOOKUP, but for approximate matches. Returns the corresponding value from a target range along with similarity scores.
• FUZZY.MATCH: Like XMATCH, but for approximate matches. Returns the 1-based index of the best match.

Features

• 💎 Data Types: Click the cell to see similarity scores, matched text, and distance metrics.
• 🧠 Multiple Algorithms: Choose from Levenshtein, Damerau-Levenshtein, Jaro, Jaro-Winkler, or Hamming comparison methods.
• 🆓 100% Free: No subscription or Office 365 license required.
• 🔒 Privacy First: All matching logic runs locally in your browser/Excel. Your data is never shared with our servers.
• 🌐 Cross-Platform: Works seamlessly in Excel for the Web and Excel Desktop.

This is a professional tool for data cleansing, deduplication, record linkage, and master data management (MDM). See our Fuzzy Match documentation for detailed usage guides and examples.