App Icon
Fuzzy lookup for google sheets and fuzzy match for google sheets using approximate matching and text similarity
Listing updated:March 22, 2022
Works with:
10,359
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
Matt Levine
June 5, 2021
Despite the below comment from the plug-in author, the issue persists -- the trial period is not accessible.
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
Julie Cherop
February 4, 2022
The app is a savior it enabled me do a 6 month job in 2days.superfast and acurate.
Is this review helpful?
Yes
No
Profile Picture
Meletios Katsifis
June 1, 2021
I might have written a positive review if i could actually use it. the moment i typed the function, it returned: "subscription ended or not subscribed" I tried a lot to find a way to use a trial or consider paying, and with no way to access it from my Google Sheets spreadsheet, I went to the original website of the addon. on Pricing, there was a 3 day trial, a basic sub, and a standard sub. Both the basic and the standard worked and asked for your card, but the button for the trial went nowhere. No action, didnt work. So I just simply uninstalled it, since my experience was substandard, if not to say "frustrating"...
Is this review helpful?
Yes
No
Profile Picture
Danstan Ongubo
August 10, 2021
Works but returns nothing sometimes. Also works on just a few rows less than 1k so not good if you are working on larger sheets.
Is this review helpful?
Yes
No
Profile Picture
ABDUL KHAYYUM
August 1, 2021
one of the best add on in google sheets... it is 10 times better than vlookup... saves my ton of time...
Is this review helpful?
Yes
No
Profile Picture
Dragos Diac
May 25, 2022
It doesn't work. The buttons don't do anything
Is this review helpful?
Yes
No
Profile Picture
Brenda Madakwa
May 30, 2021
This is a fantastic tool that has helped me automate tasks which used to manual. I have become a company hero as I was able to fuzzylookup names of 4000 + individuals within a few minutes.The tasks that I used to do for long hours now takes me some minutes.The tool is specifically good for Information consultants and Auditors.I would recommend the tool to anyone anytime any day.
Is this review helpful?
Yes
No
Profile Picture
George Chatzaras
August 6, 2021
I keep getting this error: TypeError: Cannot read property 'getEmail' of null (line 5). Can't use it.
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 17
Search
Clear search
Close search
Google apps
Main menu