App Icon
Andrew Apell
•  38,766
Overview
Compare, 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. 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: https://www.getflookup.com

We have a support portal found at https://www.getflookup.com/support and we closely monitor it for any support requests that we receive.
We humbly request that you take advantage of this feature to allow us to serve you better.
Our response time is affected by the volume of requests we receive but, for now, expect to get a response from us in less than 5 hours.
Thank you for your consideration.

#FuzzySearch #FuzzyMatch #Dedupe #MergeData #DataCleaning #Mac
Reviews
Language:
Sort by:
Profile Picture
Zoe Cunningham
October 9, 2020
Disappointed that even though their website mentions a free 3 day trial, that you can download it for free but must sign up for a subscription to use any feature. I paid for the monthly sub and had difficulty getting it to work due to my company's SSO and use of multiple emails, but contacted their support team and it was sorted within 10 minutes. Now all working as expected.
Is this review helpful?
Yes
No
Profile Pciture
Andrew Apell
October 12, 2020
Hello and thank you for choosing Flookup. We are sorry that you were unable to activate our free trial; that was an error. Our free trial does not require registration of any kind. Thank you for your feedback and we look forward to serving you better in future.
Profile Picture
Nikola Alexandrov
September 25, 2020
Asks for an upgrade without even proofing that it works.
Is this review helpful?
Yes
No
Profile Picture
Matt Haun
July 30, 2020
Saved me 600 hours of manual data cleaning. Great product.
Is this review helpful?
Yes
No
Profile Picture
irfaan meah
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 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
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
1-10 of 26
Additional information
Andrew Apell
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu