Key Takeaways
- Fuzzy Lookup for Excel is Microsoft's Windows-only add-in. It uses token-based similarity and has not received a meaningful update in years.
- Flookup Data Wrangler is a purpose-built Google Sheets add-on with five matching strategies, semantic matching, smart deduplication and standardisation tools.
- Flookup runs on any operating system through the browser, so Mac users who cannot install the Windows-only Fuzzy Lookup add-in can still perform advanced fuzzy matching.
- For Google Sheets users, Flookup is the actively maintained alternative to the legacy Microsoft add-in, with a free plan that never expires.
At a Glance: The Short Answer
Choose Flookup Data Wrangler if you work in Google Sheets, need fuzzy matching on any operating system, or want a tool that goes beyond simple text similarity. Flookup offers five matching strategies, semantic understanding, deduplication, standardisation and the Sheets AI Assistant, all inside the spreadsheet.
Choose Fuzzy Lookup for Excel if you are locked into Excel for Windows and need the classic token-based fuzzy merge that Microsoft built in 2013. Be aware that it is legacy software, has no Mac version and only compares tokens, so it misses synonyms, acronyms and abbreviations.
The Contenders
Fuzzy Lookup for Excel (Microsoft)
Fuzzy Lookup for Excel is the original Windows-only add-in that Microsoft released in 2013 as part of its Power Tools for Excel. It uses a token-based similarity algorithm to find approximate matches between two tables, which makes it a staple of data cleaning workflows on Windows. It has never been available for Excel for Mac, and Microsoft has not released a meaningful update to the add-in in years.
Flookup Data Wrangler
Flookup Data Wrangler is a Google Sheets add-on designed for data cleaning and fuzzy matching. It is maintained by Andrew Apell , and it is distributed through the Google Workspace Marketplace . It provides five matching strategies, smart deduplication, text standardisation, Learn from Examples pattern synthesis and the Sheets AI Assistant, all inside the spreadsheet.
Platform and Availability
Platform support is where the two genuine tools diverge most sharply. Fuzzy Lookup for Excel only runs on Windows. Flookup runs inside Google Sheets, which means it works on Windows, Mac, Linux and ChromeOS through any modern browser.
| Platform | Fuzzy Lookup for Excel | Flookup Data Wrangler |
|---|---|---|
| Windows | Yes | Yes, via browser |
| Mac | No | Yes, via browser |
| Linux and ChromeOS | No | Yes, via browser |
| Excel on the web | No | N/A (use Google Sheets) |
| Google Sheets | N/A | Yes |
The implication is simple: if you are on a Mac, Fuzzy Lookup for Excel is not an option. For a closer look at the Mac situation, including why the add-in will not install, see our fuzzy matching guide for Excel on Mac .
Fuzzy Matching Algorithms Compared
Fuzzy Lookup for Excel relies on token-based similarity. This approach splits text into tokens and measures how many tokens two strings share. It is excellent for catching typos such as "Jhon" versus "John", but it cannot tell you that "CEO" means the same thing as "Chief Executive Officer" because the two strings share no tokens at all.
Flookup Data Wrangler takes a different approach. It exposes five matching strategies that you can select from a dropdown: default, case-insensitive, phonetic, token-based and Levenshtein. Phonetic matching catches names that sound the same, and Levenshtein distance measures how many single-character edits separate two strings. Smart Deduplicate even combines four strategies silently to catch more match types without configuration.
| Aspect | Fuzzy Lookup for Excel | Flookup Data Wrangler |
|---|---|---|
| Matching method | Token-based similarity | Five strategies: default, case-insensitive, phonetic, token-based, Levenshtein |
| Semantic matching | No | Yes, understands synonyms and abbreviations |
| Similarity scores | Yes | Yes, with colour-coded confidence bands |
| Threshold control | Yes | Yes, with slider |
Winner: Flookup. A single algorithm can only catch a single type of variation. Flookup's five strategies, combined with semantic understanding, cover far more of the messy real-world data that fuzzy matching is meant to solve. For more on the algorithms themselves, see our guide to fuzzy matching algorithms .
Deduplication and Data Cleaning
Fuzzy matching is only one half of data cleaning. The other half is finding and merging duplicate records, and standardising messy values. Here the two tools differ even more.
Fuzzy Lookup for Excel focuses on matching and joining two tables. It has no built-in deduplication workflow of the kind that modern tools offer, and no standardisation tools. Flookup Data Wrangler, by contrast, is a full data cleaning suite. Smart Deduplicate runs four strategies automatically and presents results as expandable group cards with confidence badges. Standardise offers six built-in operations, and Learn from Examples teaches transformations by showing dirty-clean example pairs instead of writing formulas.
| Capability | Fuzzy Lookup for Excel | Flookup Data Wrangler |
|---|---|---|
| Fuzzy matching | Yes (token-based) | Yes (five strategies) |
| Deduplication | No dedicated tool | Smart Deduplicate, four silent strategies |
| Standardisation | No | Six built-in operations plus Learn from Examples |
| Column profiling | No | One-click profiling with issue detection |
| Scheduling | No | Schedule automated runs every 15 minutes, hourly or daily |
Winner: Flookup. Fuzzy Lookup for Excel is a single-purpose matching tool. Flookup treats fuzzy matching as one part of a complete data cleaning workflow. For more on deduplication, see our guide to removing duplicates in Google Sheets .
Maintenance and Support
Software that stops being maintained becomes a risk. Fuzzy Lookup for Excel is legacy software: Microsoft has not shipped a meaningful update in years, and it cannot be installed on Mac.
Flookup Data Wrangler is actively maintained by APELL Create. It is distributed through the Google Workspace Marketplace, has a published privacy policy and terms of service on this website, and its documentation covers every function and workflow. New features ship regularly, and support is available through the contact page .
| Aspect | Fuzzy Lookup for Excel | Flookup Data Wrangler |
|---|---|---|
| Last meaningful update | Years ago (legacy) | Active development |
| Documentation | Minimal | Full documentation site |
| Privacy policy | Microsoft standard | Published on site |
| Support | Microsoft community | Dedicated contact page |
Winner: Flookup. An unmaintained add-in can break with any platform update. Flookup is the actively maintained option.
Pricing Compared
Fuzzy Lookup for Excel is free to download, although it only runs on Excel for Windows. Flookup Data Wrangler offers a free plan that never expires, covering exact matching, profiling, enrichment and the Sheets AI Assistant, and a one-time Data Nova purchase from $9 for unlimited runs and advanced AI features.
| Aspect | Fuzzy Lookup for Excel | Flookup Data Wrangler |
|---|---|---|
| Base price | Free (Windows only) | Free plan, no expiry |
| Paid tier | N/A | Data Nova from $9, one-time, no subscription |
| Credit model | None | Free credits that never expire; unlimited runs on Data Nova |
You can see the full pricing details on the pricing page .
Full Comparison Table
| Aspect | Fuzzy Lookup for Excel | Flookup Data Wrangler |
|---|---|---|
| Publisher | Microsoft | APELL Create |
| Platform | Excel for Windows only | Google Sheets on any OS |
| Mac support | No | Yes (via Sheets) |
| Matching algorithms | Token-based similarity | Default, case-insensitive, phonetic, token-based, Levenshtein |
| Semantic matching | No | Yes |
| Deduplication | No dedicated tool | Smart Deduplicate, four silent strategies |
| Standardisation | No | Six operations plus Learn from Examples |
| Column profiling | No | Yes, with issue detection |
| Scheduling | No | Yes, from every 15 minutes to daily |
| AI assistant | No | Yes, Sheets AI Assistant |
| Last meaningful update | Years ago | Active development |
| Free plan | Yes (Windows only) | Yes, no expiry |
| Paid tier | N/A | Data Nova from $9, one-time |
When to Choose Each Tool
Choose Fuzzy Lookup for Excel when:
- You work exclusively in Excel for Windows and need the classic token-based fuzzy merge.
- You have no need for Mac support, deduplication or standardisation.
- You are comfortable using legacy software that receives little ongoing development.
Choose Flookup Data Wrangler when:
- You work in Google Sheets and want fuzzy matching that runs on any operating system, including Mac.
- You need deduplication, standardisation and profiling alongside fuzzy matching.
- You want to match synonyms and abbreviations, not just typos.
- You prefer an actively maintained tool with full documentation and real support.
- You want to schedule recurring data cleaning tasks without extra software.
- You are evaluating a free plan before committing to a paid tier.
If you are deciding between Flookup and Microsoft's other data transformation tool, see our Power Query vs Flookup Data Wrangler comparison.
Final Thoughts
The "fuzzy lookup" name is doing a lot of work in the market. Microsoft's original add-in earned that name on Windows but has not kept pace, and similar names have since appeared on marketplace listings of varying quality. The name alone is not a reliable signal of a tool's quality or maintenance status.
Flookup Data Wrangler does not rely on the name. It offers five matching strategies, semantic understanding, smart deduplication, standardisation, scheduling and the Sheets AI Assistant, all inside Google Sheets, on any operating system, with a free plan that never expires. That is the difference between a tool that exists because of its name and a tool that exists because it solves the problem.
Frequently Asked Questions
Is Fuzzy Lookup for Excel available on Mac?
No. Microsoft's official Fuzzy Lookup add-in is Windows-only and does not install on Excel for Mac. Flookup Data Wrangler for Google Sheets runs in the browser on any operating system, including Mac.
What is the difference between Fuzzy Lookup for Excel and Flookup Data Wrangler?
Fuzzy Lookup for Excel is Microsoft's Windows-only add-in that uses token-based similarity. Flookup Data Wrangler is a Google Sheets add-on with five matching strategies (default, case-insensitive, phonetic, token-based and Levenshtein), semantic matching, deduplication and standardisation tools.
Can Flookup replace Excel Fuzzy Lookup?
Yes, for most spreadsheet matching tasks. Flookup offers more matching strategies and works on Mac, Windows and Linux through Google Sheets. Import your Excel data into Google Sheets and run fuzzy matches, deduplication and standardisation without installing desktop software.
Does Excel Fuzzy Lookup still work in Excel 365?
The legacy Fuzzy Lookup add-in still works in Excel for Windows, but Microsoft has not updated it in years and it is not available for Excel on Mac or Excel on the web. Power Query's Fuzzy Merge is the current built-in alternative.