App Icon
Fuzzy match, highlight and remove duplicates in Google Sheets.
Listing updated:June 7, 2023
Works with:
86K+
Overview
Flookup is a data cleaning solution for Google Sheets. It is designed to handle different kinds of datasets, including those that contain text entries with partial matches, typos or different spelling conventions.

A Brief Overview of Flookup Functions:
1. FLOOKUP: Fuzzy lookup or merge data in vertically structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity.
2. SOUNDMATCH: Fuzzy lookup or merge data in vertically structured data, based on sound similarity. Matches for each lookup value are ranked in alphabetical order.
3. FUZZYMATCH: Calculate the percentage similarity between two text entries. You can also calculate the percentage similarity between concatenated text entries.
4. ULIST: Extract unique values from a specified range based on percentage similarity.
5. NORMALIZE: Remove diacritical marks, punctuation marks or stop words from any text. This is especially useful if applied before using any of the functions mentioned above.

*************************

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

*************************

Common Flookup Use-cases:
1. Email Campaigns: Clean your email list by removing duplicates and out-of-use or invalid email addresses.
2. Database Standardization: Ensure that your records are up-to-date and consistent by comparing and linking data across separate sources.
3. Database Scrubbing: Fix database errors like spelling mistakes, missing or duplicate entries and formatting differences.
4. Website Redirect Mapping: Reduce the manual work and errors associated with mapping redirects for 404 and site migration cases, thereby improving your overall SEO strategy.
5. Competitor Research: Perform competitor analysis of URL and page title differences in order to identify keyword opportunities.
6. Internal Linking Opportunities: Identify and link pages with the same topic cluster or content structure.
7. Fraud Detection: Discover and remove data that exists in more than one database when it should not, even with "disguised" spelling differences.
8. Platform Independent Fuzzy Matching: Flookup provides a peerless fuzzy lookup or fuzzy match alternative for users on platforms like Windows, macOS and Linux.

*************************

✅ [Website] https://www.getflookup.com
✅ [Updates] https://www.twitter.com/getflookup
✅ [LinkedIn] https://www.linkedin.com/company/flookup-for-google-sheets

*************************

If you liked Flookup, please leave us a five-star rating on this platform.
If you didn't like Flookup, please let us know how we can serve you better.
Your time is much appreciated.

Thank you for choosing Flookup!

*************************

[TAGS] VLOOKUP Google Sheets, Fuzzy Match, Fuzzy Search, Dedupe, Data Quality, Data Merging, Data Matching, Data Cleaning, Data Cleansing, Fuzzy Lookup Mac, Fuzzy Matching Software, Fuzzy Match Online, Highlight Duplicates in Google Sheets, Remove Duplicates in Google Sheets, CRM Dedupe Software, OpenRefine, Library Carpentry, FuzzyWuzzy
Additional information
PricingFree of charge trial
Developer
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Jeff Jockisch
February 15, 2023
If you know how to use a VLOOKUP, you can use this tool to compare cells with fuzzy logic. I've used this on and off for a couple of years. Great tool and great support. Installing, paying for, and using tools like this is complicated. That's on Google, not the Devs. So I'd take most of the poor ratings of this tool with a grain of salt. Do be aware that it can take a while to process large amounts of data with fuzzy logic.
Is this review helpful?
Yes
No
Profile Picture
Gabriel Berger
May 20, 2023
does not work at all
Is this review helpful?
Yes
No
Profile Picture
Max Singer
December 8, 2022
FLOOKUP is an invaluable tool for our team's efficiency, but that's only half the story. Andrew provides the best customer support I've ever encountered from any software developer/vendor. I would recommend this app to any google sheets user.
Is this review helpful?
Yes
No
Profile Picture
Hyo
March 18, 2022
it does not work in an accurate way.
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
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
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
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
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
1-10 of 32
Search
Clear search
Close search
Google apps
Main menu