- What the Fuzzy Lookup Add-in Does
- Downloading and Installing the Add-in
- How to Use Fuzzy Lookup in Excel
- Reading the Similarity Score and Threshold
- Where the Fuzzy Lookup Add-in Falls Short
- Fuzzy Lookup Versus Power Query Fuzzy Merge
- Fuzzy Lookup Add-in on Mac
- Alternatives to the Fuzzy Lookup Add-in
- Frequently Asked Questions
- You Might Also Like
Key Takeaways
- The Fuzzy Lookup Add-in is Microsoft's free Windows-only Excel add-in for matching similar rows across two tables. It scores pairs with a token overlap measure instead of requiring exact strings, and it writes a results table with the score beside each match.
- The current build dates from 2016. It installs as a COM add-in, so it must be ticked once in the Excel add-ins list, and it does not run on Excel for Mac, Excel for the web or Excel on a phone.
- The add-in matches on shared words, so reordered names, synonyms and phonetic spellings score poorly or fail. The threshold slider controls how strict the pass is, and a sample run before the full table saves rework.
- Power Query fuzzy merge is built into modern Excel on Windows and Mac. Flookup adds Levenshtein, phonetic and semantic matching with a scored review sheet in Google Sheets, plus a Windows desktop app for local Excel workbooks.
What the Fuzzy Lookup Add-in Does
The Fuzzy Lookup Add-in for Excel is a free tool from Microsoft Research. It compares every row in one table against every row in another and returns the pairs that are similar enough to be worth a look, together with a score that says how similar each pair is. It exists for the case where VLOOKUP and exact matches fail: two spellings of the same supplier, a customer written three ways across two exports or an address with the abbreviation expanded.
You point it at two lists stored as Excel Tables, choose the columns to compare and set how strict the comparison should be. It writes a new table of matched pairs. Nothing is merged in place, so the original rows stay as they were and you decide which pairs to trust.
Under the hood it measures the overlap of shared words between two values, which is why it handles typos and extra words well and struggles with word order, synonyms and abbreviations. The mechanics matter when you choose settings, so the next sections cover installation, the workflow and the threshold before the limits.
Downloading and Installing the Fuzzy Lookup Add-in
Microsoft distributes the add-in at no cost through its marketplace listing. The install is short, and the only step people miss is the last one: the add-in registers as a COM add-in, so Excel has to be told to load it.
| Step | Action | Why It Matters |
|---|---|---|
| 1 | Download the installer from the Microsoft marketplace listing. | The listing is Microsoft's own download, so the file comes from the vendor rather than a mirror. |
| 2 | Run the installer while Excel is closed. | An open Excel window can leave the add-in half registered. |
| 3 | Open Excel, then File, Options, Add-ins, Manage COM Add-ins and tick Fuzzy Lookup. | Without this tick the add-in stays installed but never appears on the ribbon. |
| 4 | Confirm the Fuzzy Lookup pane opens on the right of the sheet. | The pane is the whole interface, so seeing it once proves the install worked. |
Two practical notes. The current build dates from 2016, so a more recent Windows or Office may show a publisher warning while it installs; the warning appears because the certificate on the installer is old, not because the download has been tampered with. And the add-in needs desktop Excel on Windows. It does not load in Excel for the web, and it does not appear in Excel for Mac.
How to Use Fuzzy Lookup in Excel
The workflow has four moves, and both lists must first be formatted as tables with Ctrl+T:
- Format both ranges as tables: The add-in reads tables by name, so a loose range on the sheet does not appear in the pane.
- Choose the columns to compare: Drag a column from the left table and a column from the right table into the match area. Company name against company name, or city against city.
- Set the similarity threshold: Start in the middle of the range. The slider decides how much overlap a pair needs before it counts as a match.
- Run the match and read the results: The output table lists each matched pair with its score, so the borderline rows are visible instead of hidden inside a merged cell.
| Pair | What the Score Reflects | Result |
|---|---|---|
| Northwind Traders versus Northwind Trader Ltd | Shared words with one suffix added | High score and matches |
| Manchester United versus Man Utd | Abbreviation replaces part of the name | Low score and misses |
| Blue Harbor Inn versus Red Harbor Inn | Two of three words shared | Borderline, review by hand |
Keep the output table beside the originals while you review. The score column is the point of the tool: it turns a yes or no guess into a ranked list where the doubtful pairs sit in one place.
Reading the Similarity Score and Threshold
The score runs from 0 to 1. A pair scores 1.0 when the compared values share their tokens completely, and near 0 when they share nothing. The threshold slider is the cut-off: pairs below it are dropped from the output, pairs above it pass through.
- Threshold near 1.0: Only near-identical values pass. Few false positives, and real variants with abbreviations or reordered words are missed.
- Threshold in the middle: The usual starting point. Typos and minor suffixes pass, and obvious strangers do not.
- Threshold well below the middle: Loose matches arrive in bulk, so the review step grows even though recall improves.
The reliable method is to take a small sample where you already know the right answers, run it at two or three settings and read where the true pairs start failing and the false pairs start appearing. Apply the setting that sits between those two points to the full table.
Where the Fuzzy Lookup Add-in Falls Short
The add-in does its one job well, and the boundaries of that job are worth stating plainly before you plan a cleanup around it:
- Windows only: It does not run on Excel for Mac, Excel for the web or mobile Excel, so a mixed-device team cannot share the workflow.
- Shared words, not shared meaning: Reordered names, abbreviations and synonyms score poorly. Manchester United against Man Utd is a miss even though any person would call it a match.
- No phonetic pass: Names that sound alike but spell differently, such as Jon against John, do not get a second chance from a phonetic rule.
- Results are a separate table: The output does not refresh with the source, so an updated export means running the match again.
- Large tables slow down: Every row is compared against the candidates in the other table, so a broad match over a very large pair of tables takes noticeable time.
- Aged build: The installer has not been reissued since 2016, which is why the certificate warning appears and why support threads about it run so old.
None of that makes the tool bad. It makes it specific: a free Windows utility for token overlap between two tables. When the job needs meaning, phonetics, scheduling or a Mac, the next two sections are the route.
Fuzzy Lookup Versus Power Query Fuzzy Merge
Power Query, which ships inside Excel as Get & Transform, has its own fuzzy merge option and it runs on Windows and Mac. The two overlap but they serve different shapes of work, and Microsoft keeps both.
| Feature | Fuzzy Lookup Add-in | Power Query Fuzzy Merge |
|---|---|---|
| Where it runs | Desktop Excel on Windows only | Excel on Windows and Excel for Mac |
| Output | A scored results table beside your data | A joined query you can refresh |
| Review step | Scores are visible on every pair | Scores need an extra column to surface |
| Repeat on new data | Run the match again by hand | Refresh keeps the join current |
| Similarity measure | Token overlap between two values | Token overlap with a similarity option on the merge |
The summary is simple. If you want scored pairs you can inspect on Windows today, the add-in gets you there in one right-click. If you want the same join to rerun itself every time the export changes, or you work on a Mac, Power Query is the native answer. The Power Query comparison covers the Power Query route in depth.
Fuzzy Lookup Add-in on Mac
Excel for Mac cannot load the add-in. It is built as a Windows COM add-in and the installer is not compatible with Excel for Mac, which is why Mac users who run it see a Cannot Open File error rather than an install. There is no Mac build and no supported workaround that keeps the add-in itself in the picture.
Mac users still have two working routes: Power Query fuzzy merge, which is built into Excel for Mac, or a Google Sheets add-on such as Flookup, which runs in the browser on any operating system. The full fuzzy matching guide for Excel on Mac walks through both options with examples, including the formula approach for anyone who wants to see the arithmetic first.
Alternatives to the Fuzzy Lookup Add-in
When the add-in does not fit, the alternatives split into three groups:
- Inside Excel: Power Query fuzzy merge for a refreshable join, or helper formulas with Levenshtein-style scoring for a small list you control.
- Inside Google Sheets: Flookup scores pairs with Levenshtein, phonetic and semantic matching, returns a review sheet with a confidence badge on every pair and runs on Mac, Windows and Linux alike. The menu functions cover dedupe, standardisation and profiling alongside the match itself.
- On your own machine: The Flookup desktop app opens local Excel workbooks and CSV files on Windows without uploading them, for data that should not leave the machine.
The practical difference shows up in the review step. The add-in hands you scores; Flookup hands you scores plus the standardisation and dedupe tools that decide what to do with them, in the same sheet, with a free demo where every formula runs on sample data before anything is installed. The Excel Fuzzy Lookup alternative post compares the two feature by feature.
Frequently Asked Questions
How do I get the Fuzzy Lookup add-in for Excel?
Open the Microsoft marketplace listing for the Fuzzy Lookup Add-In, download the installer and run it, then tick the add-in once under File, Options, Add-ins and Manage COM Add-ins. The download comes from Microsoft and costs nothing. The current build dates from 2016, so Windows may show a publisher warning while it installs.
Is the Fuzzy Lookup add-in free?
Yes. Microsoft distributes the Fuzzy Lookup add-in at no cost. It runs inside desktop Excel on Windows and adds no separate charge of its own.
Does the Fuzzy Lookup add-in work on Mac?
No. The add-in is a Windows-only COM add-in and the installer is not compatible with Excel for Mac, so Mac users often see a Cannot Open File error. Power Query fuzzy merge is the closest option built into Excel for Mac, and Flookup runs in Google Sheets on any operating system.
Why is the Fuzzy Lookup add-in not showing in Excel?
The add-in registers as a COM add-in, so it has to be ticked once under File, Options, Add-ins and Manage COM Add-ins. If it is missing from that list, close Excel, reinstall the add-in and open Excel again with the same Windows account that ran the installer.
Is Fuzzy Lookup the same as Power Query fuzzy matching?
No. The add-in scores candidate pairs from two tables with a token overlap measure and writes a results table you can inspect. Power Query fuzzy merge joins two queries inside a refreshable step and also runs on Excel for Mac. The add-in gives you the scored pairs directly, while Power Query suits a repeatable refresh.
What similarity threshold should I use for fuzzy lookup?
Start in the middle of the range and run a small sample first. Raising the threshold towards 1.0 keeps only near-identical values and lowering it admits shorter and noisier matches. Adjust until the true pairs pass and the false pairs stop, then apply the setting to the full table.