Fuzzy Match for Excel

by BoardflareMicrosoft 365Price not published

Approximate text matching in Excel with lookup and match functions, similarity scores, and selectable comparison algorithms.

Facts verified marketplace.microsoft.comAd-free rankings
PRICINGNot published
DEPLOYMENTCloud
CATEGORYData Management
UPDATED ON MARKETPLACE
Fuzzy Match for Excel — screenshot from the Microsoft Marketplace listing

What it does

Fuzzy Match for Excel provides approximate text matching inside Excel spreadsheets. FUZZY.LOOKUP returns a value from a target range with similarity scores, while FUZZY.MATCH returns the 1-based index of the best match. Matching methods include Levenshtein, Damerau-Levenshtein, Jaro, Jaro-Winkler, and Hamming. The add-in runs in Excel for the Web and Excel Desktop, with matching logic running locally in the browser or Excel.

Key capabilities

from the Microsoft Marketplace listing

Approximate lookup

FUZZY.LOOKUP returns a corresponding value from a target range and includes similarity scores.

Approximate matching

FUZZY.MATCH returns the 1-based index of the best approximate match.

Similarity data types

Cell data types show similarity scores, matched text, and distance metrics.

Multiple algorithms

The add-in offers Levenshtein, Damerau-Levenshtein, Jaro, Jaro-Winkler, and Hamming comparison methods.

Local processing

Matching logic runs locally in the browser or Excel, and the vendor states that data is not shared with its servers.

Use cases

  • Data cleansing with approximate text matching.
  • Deduplication of records with non-exact text values.
  • Record linkage and master data management.

In the catalog

85 plugins in Excel · Data Management

Price distribution: 2 free, 1 freemium, 25 paid, 57 price not published

Pricing & deployment

Platform
Microsoft 365
Product
Excel
Deployment
Cloud
Pricing
Price not published

More from Boardflare

Similar plugins in Excel · Data Management

View all 85 →

What the vendor says

«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 …»

Official marketplace listing

Publisher
Boardflare
Updated on marketplace
Facts verified