Microsoft Download Center Archive

Fuzzy Lookup Add-In for Excel

  • Published:
  • Version:
  • Category: Application
  • Language: English

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.


Status: Live

This download is still available on The downloads below will come directly from the Microsoft Download Center.

FileSHA1 HashSize
Setup.exed5ac6281cdd70d535ddec97671a2c9d2b5261b011.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.

System Requirements

Operating Systems: Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2012, Windows Server 2012 R2, Windows Vista

  • 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

Installation Instructions

  • 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