Fuzzy lookup for google sheets and fuzzy match for google sheets using approximate matching and text similarity
Listing updated:March 22, 2022
Works with:
23K+
Overview
This fuzzy lookup google sheets add-on allows you to perform fuzzy lookup and Fuzzy match up on google sheets as well as fuzzy search.

This fuzzy matching software works like fuzzy lookup add-in for excel.
It also works well as fuzzy name matching softwares such as winpure and data ladder.

The addin works as google sheets vlookup with index match combined however with more features such as ability to perform approximate match based on the text similarity which cannot be performed with vlookup in google sheets.
The addin is also an improvement of the excel fuzzy lookup and fuzzy match excel since it works on mac book computers and uses more advanced algorithms.
It uses the Fuzzy String Matching algorithm to find the best matches for a given search term. It can also be used to find similar names to a given name, or to find the name of a person with a given name.
The fuzzy lookup for sheets addon works well with no-code app building tools such as airtable, Zapier, Integromat,  notion app Glide and Carrd.

It can also be use to perform name matching and sanction screening for AML based on names similarity.
The tool can also be used for fuzzy matches in smart Lead distribution 
and management Software such as Lead angel and lean data for Lead assignment Rules.


Lead generation activities such as analyzing incoming marketing leads verses the accounts in CRM cannot  be achieved through use of VLOOKUP.  Fuzzy lookup for sheets does this very well and achieve high accuracy level.
Unlike other matching solutions, Fuzzy lookup for sheets allows for both email and domain based matching and multiple data points to ensure the highest-fidelity account match. Matching results are always updated in real-time and your data remains completely native in Salesforce.
Fuzzy lookup for sheets can also be used with refinitiv world-check one for fuzzy matching screening and due diligence so as to help on financial crime, corruption and bribery. This ensures know your customer(KYC) and third-party screening is of the highest level possible.It will ensure that organization are monitoring their customer transactions for CFT, anti-money laundering(AML) as well politically exposed persons(PEPs) and heightened risk individuals.


Some of the additional features that the addon can perform are as listed below:
vlookup with text
compare names similarity in google sheets
xlookup in google sheets
xlookup
vlookup text contains
Compare address and names similarity
vlookup approximate match text
vlookup if cell contains a word within 



[WEBSITE] https://fuzzymatcher.unicornplatform.page
[CONTACT] https://forms.gle/uCtyxzkN1iLPJ2Vg9
[FEATURE REQUESTS] https://forms.gle/uCtyxzkN1iLPJ2Vg9

[TAGS]Fuzzy Match, Fuzzy Lookup, Fuzzy Search, Dedupe, Data Quality, Data Merging, Data Cleaning, Data Cleansing, Data Matching, Fuzzy Lookup Mac, 
Fuzzy Matching Algorithm, Fuzzy Matching Software, Fuzzy Match Online, Remove Duplicates in Google Sheets, Duplicate Management Salesforce, 
CRM Dedupe Software, HubSpot, Pipedrive, Data Connector for Salesforce, OpenRefine, fuzzylookup google sheet, excel fuzzy lookup, match names google sheets, fuzzy matching lead generation,
fuzzywuzzy, fuzzy match, vlookup names, fuzzy  look up add in, vlookup google sheets, xlookup google sheets
Additional information
PricingNot available
Developer
Trader status unspecified
Privacy policy
Terms of service
Fuzzy Lookup for Sheets will ask for the permissions shown below. Learn more
Fuzzy Lookup for Sheets will need access to your Google account
This will allow Fuzzy Lookup for Sheets to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Jody Hirst
October 14, 2023
looks like a good tool. unfortunately you don't find out the pricing until you use it, and it only returns 20 results and then wants you to pay $9. DONT USE THIS TOOL. There are other options.
Is this review helpful?
Yes
No
Profile Picture
Anthony Ryan
February 16, 2024
Lack of transparency, this is a paid add on, so not going to proceed because I don't know what else is undeclared.
Is this review helpful?
Yes
No
Profile Picture
G W
August 11, 2023
It was okay. The main limitation is the only option being 'best matches only' when I wanted to return all matches. no errors while using though
Is this review helpful?
Yes
No
Profile Picture
Fleur Murphy
September 28, 2023
Same error
Is this review helpful?
Yes
No
Profile Picture
Akash Sharma
May 25, 2023
Worst ever.
Is this review helpful?
Yes
No
Profile Picture
Deborah Buehler
March 2, 2023
I also keep getting TypeError: Cannot read property 'getEmail' of null (line 7). Would really love for this to work ...
Is this review helpful?
Yes
No
Profile Picture
Alberto Guerra
July 11, 2023
Error the same as others - TypeError: Cannot read property 'getEmail' of null (line 7)
Is this review helpful?
Yes
No
Profile Picture
Chris Wright
October 10, 2022
I think this could be better if it was not case sensitive. Otherwise, it works as inteneded; however, I also disliked that each result requires a 5x2 array.
Is this review helpful?
Yes
No
Profile Picture
Max Zhang
June 29, 2021
Love both the product and the customer service. 1. Easy-to-use Product: This is the most useful add-on on google sheets for me at work. I work at a university where I need to cross-reference data between different departments' sheets and the challenge is that these sheets often do not share a same field that I can base my lookups on. Even names are stored differently among these sheets (e.g. some has MIs and some don't while others spells out the middle name). This Fuzzy lookup allows me to look up everything based on names regardless in what format they are spelled. All I need to do is to change my "VLOOKUP" formula into the "Fuzzylookup" formula documented in the product description. If you have similar situations at work, I highly recommend this add-on to you. 2. Super prompt customer service I had an issue activating my subscription (too long a payment pending time) after the trial period expired which caused my formula to break on my google sheets, so I emailed for help, and I got a response within 30 mins and the problem is solved right there. This gives me a peace of mind knowing that if I have any future issues, I am supported. Bravo and Thanks!
Is this review helpful?
Yes
No
Profile Picture
Calum Scott
May 24, 2022
Same issue as others which the creator has not bothered to address: TypeError: Cannot read property 'getEmail' of null (line 7) Means the plug-in is unusable which is a shame
Is this review helpful?
Yes
No
1-10 of 22
Search
Clear search
Close search
Google apps
Main menu