App Icon
Andrew Apell
•  38,004
Overview
Fuzzy matching functions for Google Sheets. Lookup, merge, highlight and dedupe your datasets. Data cleaning made simple!
Flookup is a suite of functions for data cleaning inside Google Sheets by using advanced fuzzy match and fuzzy lookup techniques. Flookup is a good add-on 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: 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 (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. SUMLOOKUP: Merge or sum data based on corresponding partial matches from a single column.
7. MEANLOOKUP: Calculate the average of data based on corresponding partial matches from a single column.
8. 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 Features:
1. Highlight duplicates based on percentage or sound similarity.
2. Remove duplicates based on percentage or sound similarity.

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

WEBSITE: www.getflookup.com

#FuzzySearch #FuzzyMatch #Dedupe #MergeData #DataClean #Mac
Reviews
Language:
Sort by:
Profile Picture
A User of Flookup
July 30, 2020
Saved me 600 hours of manual data cleaning. Great product.
Is this review helpful?
Yes
No
Profile Pciture
A user of Flookup
July 31, 2020
Thank you very much for your review.
Profile Picture
A User of Flookup
July 15, 2020
Great Formula! I used this to match addresses and it did great. Even though I had to go through some of them manually, it did the heavy lifting of scrapping most of the unnecessary addresses. It works wonders if people know how and when to use this. I would definitely recommend this to others and use it myself again in the future. Thank you guys.
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
June 30, 2020
didnt even use it, useless trial only lets u do 25 rows!! sucks. delete!
Is this review helpful?
Yes
No
Profile Pciture
A user of Flookup
July 12, 2020
It is actually 50 rows per day. If you are testing Flookup or using it for light tasks, this should be sufficient. Anything above that would fall outside the realm of "trying" or "testing".
Profile Picture
A User of Flookup
May 29, 2020
Fantastic app , fantastic customer service should you have a problem. This app literally saves our business hours of work per week. Never usually leave reviews but this app , big thumbs up
Is this review helpful?
Yes
No
Profile Picture
A User of Flookup
May 13, 2020
This is an excellent add-on, does exactly what it says and what you need it to do. It even automatically includes a column that shows the percent match that is provided which is immensely helpful for focusing on the most important results in a pinch. I would highly recommend this for anyone who spends any time managing data, it has worked flawlessly for my needs. The developer is also extremely helpful and responsive. He even extended the courtesy of personally assisting me with a task I needed to complete.
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 Pciture
A user of Flookup
July 2, 2020
This issue has been fixed now.
Profile Picture
A User of Flookup
April 29, 2020
Looks like a great tool, sadly after installing it's impossible to use because google has disabled it for security reasons (can't 'sign on').
Is this review helpful?
Yes
No
Profile Pciture
A user of Flookup
July 2, 2020
This issue has been fixed now. It should no longer appear.
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
Profile Picture
A User of Flookup
April 2, 2020
Works as expected and does a great job (using it for similarity matching between text fields) -- can save you a lot of time and hassle. Had a little difficulty with the installation but got very fast and excellent support.
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 Pciture
A user of Flookup
June 14, 2020
Exactly what happens to me
Profile Pciture
A user of Flookup
May 5, 2020
It appears you registered a wrong "Subscriber email" account. Correcting this will fix the issue.
1-10 of 25
Additional information
Andrew Apell
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu