App Icon
Fuzzy match, highlight and dedupe your datasets in Google Sheets.
Works with:
65,854
Overview
Flookup uses fuzzy string matching to power data cleaning in Google Sheets. Flookup is perfect for handling diverse kinds of datasets, even those that contain text with partial matches, typos or spelling variations.

A Brief Overview of Flookup Functions:
1. FLOOKUP and QLOOKUP: Merge data or match strings in vertically structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity.
2. HFLOOKUP: Merge data or match strings in horizontally structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity.
3. SOUNDMATCH: Match strings based on sound similarity (REFINED SOUNDEX) in vertically structured data. Matches for each lookup value are ranked in alphabetical order (A-Z).
4. FUZZYMATCH: Calculate the percentage similarity between two strings. It can also calculate the percentage similarity between concatenated strings.
5. ULIST: Extract unique values from a specified range based on percentage similarity.
6. NORMALIZE: Remove diacritical marks or stop words from any string. This is especially useful if applied before using any of the functions mentioned above.

Additional Functions:
1. Highlight duplicates based on percentage or sound similarity.
2. Remove duplicates based on percentage or sound similarity.

Working with Flookup eliminates the need to:
1. Sort datasets.
2. Change the letter case of the text.
3. Remove extra spaces.
4. Remove punctuation marks.

[WEBSITE] https://www.getflookup.com
[CONTACT] https://www.getflookup.com/contact
[COMMUNITY] https://groups.google.com/g/flookup

Thank you for choosing Flookup!

[TAGS] Fuzzy Search, Fuzzy Match, Fuzzy Lookup, Fuzzy Lookup Excel, Dedupe, Data Quality, Data Merging, Data Cleaning, Data Cleansing, Data Matching, Fuzzy Lookup Mac, Fuzzy Matching Algorithm, Fuzzy Matching Software, Fuzzy Matching Online, Highlight Duplicates in Google Sheets, Remove Duplicates in Google Sheets, Merge Accounts Salesforce, Salesforce Management, Duplicate Management Salesforce, CRM Dedupe Software, HubSpot, Pipedrive, VLOOKUP, XMATCH, XLOOKUP Google Sheets, Data Connector for Salesforce, Supermetrics, Fuzzywuzzy, OpenRefine, Record Linkage
Additional information
Privacy policy
Terms of service
Flookup will ask for the permissions shown below. Learn more
Flookup will need access to your Google account
This will allow Flookup 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:
Profile Picture
A User of Flookup
January 24, 2019
Great Add-on. It's surprising how it decides to match things sometimes, but it's helped take a project form completely manual to mostly automated. So thank you for your work on this. I've been using it for a few months now and still really like it. The only problem is the ERROR it throws when it's been called too many times. Is there a way to add a pause in there or some kind of setting to control the speed?
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
October 18, 2018
does not work as intended whatsoever. only returns exact values
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
June 24, 2019
Works perfetly, one of a kind, managed to create auto-translation tool with its help.
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
January 4, 2019
What a wonderful feature! Many many thanks.
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
September 18, 2018
Great add-on:)
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
April 2, 2020
Didn't work. Tool complained about not having a subscription. Entered paypal details twice (once using an account, second just via credit card). A waste of ~1 hour. Was really hoping this would be faster than implementing my own solution using levenshtein distance, but guess I'll have to do it myself.
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
May 13, 2020
Says it is not verified when signing in with Google
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
November 27, 2019
it works
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
March 12, 2020
I'm trying to get set up. Google says "Updated add-on A script attached to this document needs your permission to run." However when I try to accept it says "Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In." How to proceed? Also how to pay, your website pricing page doesn't work...
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
April 9, 2020
As you can see from the other reviews, this program works for some people and doesn't work for others, kind of like how everyone else can log in to the Zoom meeting except for Carl. But Carl is also the same guy that regularly accidentally "replies all" to company wide emails and last year managed to crash our internal servers despite working in public relations. Yes, if you are log in to more than one Google account Flookup doesn't like it. Yes, if you share your sheet with someone and you don't have an enterprise plan it will not work (though it does appear if the other users only have "view" access Flookup doesn't mind.) But these are necessary security steps so one user can't share this freakin awesome program with other people. Plus you'll get a support response within hours for any issues you have. But first read the really complete FAQ and doc files on the website. This app works great—quick and easy to use. Nice work.
Is this review helpful?
Yes
No
1-10 of 33
Search
Clear search
Close search
Google apps
Main menu