The Fuzzy Lookup Add-In for Microsoft Excel

The Fuzzy Lookup Add-In for Excel has been developed by Microsoft Research and performs fuzzy matching of textual data in Microsoft Excel.

Fuzzy Lookup Add-In can be used to identify fuzzy duplicate rows within a single table or to fuzzy join similar rows between two different tables. The matching is robust to a wide variety of errors including spelling mistakes, abbreviations, synonyms and added/missing data.

For instance, it might detect that the rows “Mr. Andrew Hill”, “Hill, Andrew R.” and “Andy Hill” all refer to the same underlying entity, returning a similarity score along with each match. While the default configuration works well for a wide variety of textual data, such as product names or customer addresses, the matching may also be customized for specific domains or languages.

Download page: Microsoft.

Requires Microsoft Excel 2010 on Windows 7, Windows Server 2008 or Windows Vista.

Posted by on , in Category Office with Tags
Anand Khanse is the Admin of TheWindowsClub.com, a 10-year Microsoft MVP Awardee in Windows (2006-16) & a Windows Insider MVP. Please read the entire post & the comments first, create a System Restore Point before making any changes to your system & be careful about any 3rd-party offers while installing freeware.