Office

Fuzzy Lookup Add-In for Excel

Language:
English
The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel.
  • Version:

    1.3.0.0

    File Name:

    Setup.exe

    Date Published:

    6/11/2014

    File Size:

    1.4 MB

      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.
  • Supported Operating Systems:

    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 or 2013
    • 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

Popular Downloads

Loading your results, please wait...

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers