App Icon
Andrew Apell
•  43,380
Overview
Compare, merge, highlight and dedupe your data in Google Sheets.
Flookup is a suite of functions that use fuzzy 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 (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 data sets.
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/d/forum/flookup

Thank you for choosing Flookup.

[TAGS] Fuzzy Search, Fuzzy Match, Fuzzy Lookup, 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, Data Connector for Salesforce, Supermetrics, Fuzzywuzzy, OpenRefine
Reviews
Language:
Sort by:
Profile Picture
Dominic Martinkevic
April 8, 2021
Saving me hours of data cleaning and automating otherwise very manual tasks!
Is this review helpful?
Yes
No
Profile Picture
Sam D
March 25, 2021
Cant get to work, no instructional videos
Is this review helpful?
Yes
No
Profile Picture
Alex Canino
March 16, 2021
Best resource available for those looking for an alternative to Excel's Fuzzy Lookup. Consistently updated with notable improvements every time. Despite experiencing a few bugs I give it five stars because Support was always quick, clear, personal and always solved any issue. Definitely one of the better addons out there.
Is this review helpful?
Yes
No
Profile Picture
Robert Farrell
February 25, 2021
Couldn't get it to work as it kept telling me to subscribe or upgrade - even after subscribing for free trial to see if it could do what I needed. Will have to delete. Better not spam me after giving my email!
Is this review helpful?
Yes
No
Profile Picture
fred feisullin
January 31, 2021
Fuzzy Lookup worked very well for mapping and comparing a single cell against an array using the fuzzy lookup comparison logic. Found the correlation or matching confidence rating (thresholds) to be quite good. However, I am looking for a tool or technique that will enable comparison between any cell positioned anywhere in an array against any cell in another array, and to flag outliers or unique cells on either side. This becomes important when comparing large arrays frequently. Would be very interested if this can be supported at a future date. Unfortunately,, I did not have much luck with using the other Excel tools.
Is this review helpful?
Yes
No
Profile Picture
Chethan Prabhu
December 14, 2020
I just installed the flookup but am not able to activate the free trial.
Is this review helpful?
Yes
No
Profile Picture
David Lynn
November 28, 2020
I am impressed! I was having an issue (it was my error) and I got a response (two, actually) from tech support -- on a holiday Saturday!
Is this review helpful?
Yes
No
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 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
1-10 of 32
Additional information
Andrew Apell
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu