Fuzzy Lookup Add-In for Excel is a free Microsoft add-in that matches names, addresses, and other text across Excel tables by similarity rather than exact spelling, so analysts can clean, deduplicate, and reconcile messy lists without writing lookup formulas.
The Fuzzy Lookup Add-In for Excel adds a dedicated ribbon tab that compares two tables, or one table against itself, and returns the closest textual matches with a similarity score attached. After installing the Fuzzy Lookup Add-In for Excel, you pick a Left Table and a Right Table, choose the columns to match on, tick the output columns you want, set how many matches to return per row, and drag a threshold slider to control how strict the comparison should be. Pressing Go writes a results table into the workbook, while Undo removes it. Because comparison is based on token overlap rather than exact equality, records that differ by typos, abbreviations, or word order still surface as candidates — a gap VLOOKUP cannot close.
This kind of list hygiene usually happens long before data reaches a reporting layer. A marketing analyst exporting campaign responses, a procurement officer comparing supplier spellings across two systems, or a support team merging ticket exports will all recognize the problem: the same organization written three ways. The add-in does not silently overwrite anything; it proposes ranked candidates for a human to accept or reject, which keeps the review step visible. Teams that spend the rest of the week inside paid-search tooling, for example Microsoft Advertising Editor, will find the same logic familiar: bulk imports only behave when the underlying names line up. Fuzzy Lookup Add-In for Excel tackles that alignment inside the spreadsheet, before the export is uploaded anywhere.
The practical benefit is time. Rebuilding a customer list by hand, or writing nested IF and SEARCH formulas to guess at near-duplicates, is slow, error-prone, and hard for colleagues to audit later. The Fuzzy Lookup Add-In for Excel replaces that with a repeatable panel: the same table pair, the same columns, the same threshold, the same result, every time. You can lower the threshold to catch aggressive misspellings and abbreviations, or raise it to keep only near-identical pairs, and you can return several candidates per row instead of forcing a single guess. The similarity score travels with the output, so you can sort matches, filter out weak ones, and hand reviewers a defensible list rather than a black-box merge. The Fuzzy Lookup Add-In for Excel also works entirely inside a workbook, which means sensitive customer, supplier, or employee data never has to leave the machine to be reconciled. For anyone who regularly receives spreadsheets from different sources and needs them to agree, that combination of transparency, repeatability, and local processing is the real payoff.
Key capabilities and highlights.
Compare one Excel table against another and let the Fuzzy Lookup Add-In for Excel return the closest textual matches for every row, even when wording, spelling, abbreviations, or punctuation differ between the two lists. Both sides must be true Excel tables, and each side can contribute one or more columns to the match rule.
Point both the left and right table at the same list to generate similarity scores for every possible pairing, then sort the output to isolate the pairs that score highly enough to investigate as duplicates. This turns an unwieldy contact, vendor, or product list into a ranked shortlist for review.
Each returned row carries a FuzzyLookup.Similarity value, so you can rank candidates, filter out weak matches, and give reviewers a numeric basis for accepting or rejecting each pairing. Keeping the score in a visible column also means a later auditor can retrace why one record was merged with another.
A single slider sets how close two strings must be before they count as a match, letting you loosen the rule to catch rough spellings and abbreviations or tighten it so only near-identical pairs qualify. Re-running the comparison at a different setting takes seconds, so tuning the threshold rarely disrupts the rest of the workflow.
Set the number of matches to display and the Fuzzy Lookup Add-In for Excel returns that many candidates per record, ranked by similarity, which helps when a name could reasonably map to several entries in the reference list. Reviewers can compare the competing options side by side instead of accepting a single forced answer.
Build a match rule from several columns at once, such as first name with surname or street with postcode, so the comparison reflects a whole record rather than one field that may be ambiguous on its own. Combining fields typically raises confidence and cuts the number of false matches you have to dismiss.
Tick only the columns you actually need from both tables before running the match, which keeps the results compact and avoids scattering half the original worksheet across the new output table. Leaving out sensitive or irrelevant fields also makes the finished output easier to share with colleagues.
Undo removes the generated output table in a single step, so you can adjust the threshold or match columns and run the comparison again without leaving stray results behind in the workbook. That makes the feature comfortable to experiment with on a copy of live data before committing to a final rule.
Browse historical releases and previous builds.
No old versions have been added yet.
Common questions about Fuzzy Lookup Add-In For Excel.
The Fuzzy Lookup Add-In for Excel matches text values that mean the same thing but are not written the same way. Typical jobs include deduplicating a customer list, reconciling supplier names drawn from two systems, matching address records, and merging exports where typos, abbreviations, or different word order have kept exact lookups from working.
VLOOKUP and XLOOKUP need keys to line up exactly, so 'Acme Ltd' will never find 'ACME Limited'. The add-in instead scores every candidate by similarity and returns the closest ones with a number attached, which means slightly different values can still be matched and reviewed rather than silently dropped.
It is a number between 0 and 1 that reflects how closely two strings correspond, with values near 1 indicating strong agreement. It comes from Microsoft Research's string-comparison work and lets you sort or filter results, so you decide how much manual checking each match deserves based on where it sits.
Yes. The add-in works with native Excel tables, so if your lists are plain ranges you should convert them first by selecting the range and choosing Insert, then Table. Giving each table a clear name also makes it easier to pick the correct left and right table in the task pane.
Yes. Set the left table and the right table to the same table and the add-in compares every record against the others. Sort the output by similarity and keep the high-scoring pairs, and you have a shortlist of probable duplicates instead of thousands of unsorted rows to inspect.
No. Results are written to a separate output table in a cell you choose, and the Undo button in the task pane clears that output. Your source tables stay untouched, which makes it safe to experiment with different thresholds before settling on a matching rule.
Yes, it is a free Microsoft add-on rather than a paid product, with no separate subscription or account requirement. You install it once, enable it through Excel's COM Add-Ins list if the ribbon tab does not appear automatically, and it then stays available whenever you need a match.
Start with the cleanest column available, match on two fields when one is ambiguous, and adjust the threshold in small steps rather than jumping to the loosest setting. Reviewing a sample of high and mid-range scores shows quickly whether the rule is too strict or too generous before you trust the whole output.
Fuzzy Lookup Add-In for Excel is a free Microsoft add-in that matches names, addresses, and other text across Excel tables by similarity rather than exact spelling, so analysts can clean, deduplicate, and reconcile messy lists without writing lookup formulas.
Tableau Prep Builder is a visual data preparation tool that lets analysts combine, clean, and shape messy datasets into analysis-ready outputs through drag-and-drop flows, without hand-coding an ETL process.
Microsoft 365 Apps for enterprise is a managed productivity suite that provides Word, Excel, PowerPoint, Outlook, and related applications for creating content, analyzing data, communicating, and collaborating across an organization.
Restic is a command-line backup program that stores encrypted, deduplicated snapshots in local folders or cloud storage. It suits developers and system administrators who want scriptable, verifiable backups with integrity checks and fine-grained restore options.
Comments