Search
Clear search
Close search
Main menu
Google apps
App Icon
Flookup helps you handle data cleaning tasks like fuzzy matching or merging data, highlighting and removing duplicates in Google Sheets™ based on text similarity.
Listing updated:February 27, 2025
Works with:
117K+
Overview
Flookup is a lightweight data cleaning solution for Google Sheets™. It is designed to help you merge, dedupe or highlight text entries in different kinds of datasets, even if they contain punctuation marks, partial matches, typos or different spelling conventions.

🟢 HOW TO ACTIVATE YOUR FREE PLAN
+ Install Flookup.
+ Head to Extensions > Flookup Data Wrangler > Manage Flookup > Dashboard in the spreadsheet menu.
+ Click the "Fetch status" button and wait for the confirmation message.

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

🟢 OVERVIEW OF FEATURES
+ Remove diacritical marks, punctuation marks or stop words from any text. This function is particularly useful if applied before using any of the other functions mentioned in this list.
+ Evaluate the percentage similarity between two text entries. You can also calculate the percentage similarity between concatenated text entries.
+ Fuzzy match or merge data in vertically structured data, based on percentage or sound similarity.
+ Fuzzy match or merge data in horizontally structured data, based on percentage similarity.
+ Extract unique values from a specified range based on percentage similarity.
+ Remove 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 any duplicates based on how similar the text entries are by percentage or sound similarity.
+ Schedule data cleaning functions to run automatically on a loop or until the job is complete.
+ Take advantage of advanced GPT models to clean, organise and structure your datasets.

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

🟢 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.

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

🟢 FREQUENTLY ASKED QUESTIONS
+ Does Google have a similar feature? Yes, but Flookup goes further by addressing common data cleaning issues that often affect users and their data. It standardises datasets by correcting inconsistent capitalisation, removing extraneous whitespace and aligning punctuation, turning messy data into a reliable format.
+ What sets Flookup apart from other fuzzy matching solutions? While numerous options exist online, Flookup's proprietary algorithm has consistently outperformed alternatives in independent tests. It delivers a fast, dependable solution for professionals requiring precise data matching and cleansing.
+ Is my data secure? Flookup is dedicated to data privacy and security. It collects only default usage metrics from Google and our team does not access your processed data. Verified by Google’s Safety team, Flookup has maintained a spotless security record for over six years.
+ Is Flookup platform-independent? Yes, Flookup is designed to work seamlessly on any platform that supports Google Sheets™, making it the perfect solution for Mac, Windows and Linux users alike. Historically, Mac users were at a disadvantage due to the lack of a tool like Microsoft’s Fuzzy Lookup. Flookup not only fills that gap but surpasses it by offering a more versatile and efficient alternative.

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

🟣 Learn how to get started: https://www.getflookup.com/get-started
🟣 Connect with us: https://www.linkedin.com/company/flookup-data-wrangler

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

[TAGS] Fuzzy Match, Fuzzy Lookup, Fuzzy Matching Algorithms, Data Cleaning, Data Cleansing, Data Quality, CHATGPT, XLOOKUP, VLOOKUP, CRM, OpenAI, XMATCH, Mac, Soundex
Additional information
PricingFree of charge with paid features
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
John Hall
April 16, 2024
My use case was pretty simple - a (long) list of names that contained duplicates, but not exact duplicates - things like Mike Smith and Michael Smith. This app worked wonderfully. We had a few bumps in getting it installed and working, but the support was great and patient - and persistent. This little app will save me gobs of time, and build the confidence that I didn't overlook a duplicate. Well done. One piece of advice, if you use multiple Google userIDs, watch what ID you install with - it matters.
Is this review helpful?
Yes
No
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
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
fred feisullin
February 1, 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
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
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 Data Wrangler
March 12, 2020
I'm trying to get set up. Google says "Updated add-on A script attached to this document needs your permission to run." However when I try to accept it says "Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In." How to proceed? Also how to pay, your website pricing page doesn't work...
Is this review helpful?
Yes
No
1-10 of 34