Fuzzy lookup, highlight and remove duplicates in Google Sheets™.
Listing updated:February 27, 2024
Works with:
88K+
Overview
Flookup is a lightweight data cleaning suite 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
+ NORMALIZE: Remove diacritical marks, punctuation marks or stop words from any text. This is particularly useful if applied before using any of the functions mentioned in this list.
+ FUZZYMATCH: Calculate the percentage similarity between two text entries. You can also calculate the percentage similarity between concatenated text entries.
+ FLOOKUP: Fuzzy match or merge data in vertically structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity.
+ SOUNDMATCH: Fuzzy match or merge data in vertically structured data, based on sound similarity. Matches for each lookup value are ranked in alphabetical order.
+ ULIST: Extract unique values from a specified range based on percentage similarity.
+ REMOVE DUPLICATES: Use this function to delete any duplicates based on how similar the text entries are by percentage or sound similarity. You can also rollup or combine multiple rows by percentage similarity.
+ HIGHLIGHT DUPLICATES: Use this function to highlight any duplicates based on how similar the text entries are by percentage or sound similarity.

🟢 To learn how to activate your free trial or paid subscription, please follow this link: https://www.getflookup.com/start-here/how-to-activate-subscription

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

COMMON FLOOKUP USE-CASES
+ Email Campaigns: Boost your email marketing efforts by cleaning your email lists. Remove duplicates, out-of-use, and invalid email addresses to ensure maximum deliverability and engagement.
+ Competitor Research: Stay ahead of the competition by performing in-depth analyses of URL and page title differences. Identify keyword opportunities and optimise your content for better search engine visibility.
+ Internal Linking Opportunities: Enhance your website's user experience and SEO by identifying and linking pages with the same topic cluster or content structure. Find and link relevant pages with ease.
+ Database Scrubbing: Keep your database error-free with Flookup. Fix common issues like spelling mistakes, missing or duplicate entries, and formatting differences to ensure accurate and reliable data.
+ Database Standardisation: Ensure that your records are up-to-date and consistent by comparing and linking data across separate sources. Standardise your database for improved accuracy and efficiency with ease.
+ Website Redirect Mapping: Simplify the process of mapping redirects for 404 and site migration cases. Reduce manual work and errors and improve your overall SEO strategy.
+ Fraud Detection: Protect your business from fraud by discovering and removing data that exists in more than one database when it should not. Detect "disguised" spelling differences to ensure maximum security.
+ Platform Independent Fuzzy Matching: Enjoy a peerless fuzzy matching alternative, available on platforms like Windows, macOS, and Linux. Flookup provides a powerful and flexible solution for all your fuzzy matching needs.

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

We have two pricing plans that do not auto-renew to prevent surprise billing in future:
+ FLOOKUP STANDARD: $15 / USER / 1 MONTH
+ FLOOKUP PROFESSIONAL: $120 / USER / 1 YEAR

🟢 To learn how to access these data cleaning functions via our API, please follow this link: https://www.getflookup.com/flookup-api

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

🟢 [OFFICIAL WEBSITE] https://www.getflookup.com 
🟢 [TWITTER] https://www.twitter.com/getflookup
🟢 [LINKEDIN] https://www.linkedin.com/company/flookup-data-wrangler

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

🟢 If you liked Flookup, please leave us a five-star rating on this platform.
🔴 If you did not like Flookup, please let us know how we can serve you better.
🫱🏻‍🫲🏽 Your feedback is much appreciated.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Flookup Data Wrangler will ask for the permissions shown below. Learn more
Flookup Data Wrangler will need access to your Google account
This will allow Flookup Data Wrangler 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
Andrew Perkins
October 31, 2023
Excellent service, super fast suppport - even at weekends!
Is this review helpful?
Yes
No
Profile Picture
Avi Trachtman
August 12, 2023
I don't know about all the aspects, but the fuzzy lookup, which is what I needed, worked perfectly and helped me a lot with a project I was working on.
Is this review helpful?
Yes
No
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
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
A User of Flookup Data Wrangler
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
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
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
Hyo
March 18, 2022
it does not work in an accurate way.
Is this review helpful?
Yes
No
1-10 of 34
Search
Clear search
Close search
Google apps
Main menu