App Icon
Fuzzy match, highlight and remove duplicates from your data.
Listing updated:November 30, 2022
Works with:
85,821
Overview
Flookup uses fuzzy matching algorithms to power data cleaning in Google Sheets. Flookup 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, QLOOKUP and MLOOKUP: Merge data or match text 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 text in horizontally structured data, based on percentage similarity. Matches for each lookup value are ranked in order of descending percentage similarity.
3. SOUNDMATCH: Merge data or match text in vertically structured data, based on sound similarity. Matches for each lookup value are ranked in alphabetical order.
4. FUZZYMATCH: Calculate the percentage similarity between two text entries. It can also calculate the percentage similarity between concatenated text entries.
5. ULIST: Extract unique values from a specified range based on percentage similarity.
6. 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 fuzzy duplicates based on percentage or sound similarity.
2. Highlight fuzzy 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
[Community] https://groups.google.com/g/flookup
[Changelog] https://groups.google.com/g/flookup/c/ZbceLjo4Y2c

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

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!
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
Loading
Search
Clear search
Close search
Google apps
Main menu