Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel.

• The Fuzzy Lookup Add-In for Excel was developed by Microsoft Research and performs fuzzy matching of textual data in Microsoft Excel. It 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.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
Setup.exe SHA1: d5ac6281cdd70d535ddec97671a2c9d2b5261b01	1.17 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Preinstalled Software (Prerequisites): Microsoft Excel 2007, 2010, 2013, or 2016
• 1 GHz processor, 1 core or higher
• 1 GB of RAM
• 2 GB of available hard disk space
The following libraries are required and will be installed if necessary:
• .NET 4.5
• VSTO 4.0

• To install and use Fuzzy Lookup Add-In for Excel, complete the following steps:
  • Uninstall any previous versions of Fuzzy Lookup Add-In for Excel.
  • Run Setup.exe to install the add-in per-user.
  - or -
  • Save Setup.exe, right-click Setup.exe and Run As Administrator.
  • An option for per-machine installation is available when Setup.exe is run as Administrator and may resolve any Trusted Publisher errors encountered in a per-user install.
  • Running Setup.exe as Administrator may resolve error 0x80070659 encountered during installation.
  • Read the license terms in the 'LicenseTerms.rtf' document.
  • Read the 'README.docx' document for further installation and usage instructions.
  It may be necessary to disable the following option in Excel if Trusted Publisher errors are encountered:
  • Excel Options => Trust Center => Trust Center Settings... => Add-ins => Require Application Add-ins to be signed by Trusted Publisher
  If setup error 0x80070659 is encountered, run Setup.exe as Administrator or add/set the following DWORD registry value. If this registry setting does not exist on certain Windows Server operating systems, the default is 1 which will cause setup to fail if not run as Administrator.
  • HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Installer\
  DisableMsi = 0