FUZZY MATCH, HIGHLIGHT AND REMOVE DUPLICATES
How Flookup Works
Flookup [Fuzzy-Lookup] is a lightweight data cleaning add-on for Google Sheets. It uses fuzzy matching to manipulate data in the following ways, regardless of spelling differences, partial matches or any other text based variations in your data:
Highlight and remove duplicates.
Fuzzy lookup or fuzzy match data a.k.a record linkage.
Extract unique values from fuzzy duplicates.
Analyse percentage similarities between text entries.
Remove unwanted words, diacritics and punctuation marks.
Flookup will not only help you improve efficiency, reduce your error rate and increase productivity in data cleaning, but it will also help you save revenue.
Did You Know?
The 1-10-100 principle states that it costs $1 to verify the quality of your database, $10 to clean each item in it and $100 to store each item that is not cleaned.
For example, using Flookup to clean just 100 rows of data, with 20 of them being dirty and 80 of them clean but in need of verification, will lead to savings of anything between $230 to $250. On the other hand, ignoring this same data will eventually cost anything from $1,000 to $10,000 for you to clean and verify it.
How to Start Your Unlimited Free Trial
Install Flookup from the Google Workspace Marketplace.
Open the secure form located in your spreadsheet menu under Extensions > Flookup > Manage subscription > Free trial.
Enter your Subscriber Email Address and click "Submit". It must be the same as the email address you used when you created that spreadsheet. If your free trial activation is unsuccessful, you will see an error message. Otherwise, proceed to the next step.
Click the "Update status" button on that same window. This will sync your updated subscription status with our database.
Why Choose Flookup?
It is privacy focused. Flookup does not expose, store or share any of the spreadsheet data it processes, meaning that your data remains secure and for your eyes only. You can learn more about data privacy by clicking here.
It is accurate and consistent. Flookup is powered by battle-tested algorithms that are built on the experience of processing millions of rows and columns of dirty data.
It is easy to master. Flookup functions are familiar, intuitive and easy-to-use, meaning that you can become proficient at using it almost immediately.
It is fast and efficient. Flookup runs on one of the fastest fuzzy matching algorithms online and all its functions are optimised to complete tasks in the shortest time possible.
It is platform-independent. By extension of being a Google Sheets add-on, Flookup fully supports all major Operating Systems like Windows, macOS and Linux.
It is always up-to-date. Flookup is constantly being improved in keeping with the latest developments in the industry. In other words, you get lifetime upgrades for free. You can view our latest changelog by clicking here.
Its data operations are safe. Any operation that is completed by Flookup can be easily undone by clicking the "Undo" button or by recovering the spreadsheet through the File > Version history feature in the menu.
It speaks your language. Flookup is not limited to processing English text entries; you can use it to process text entries in most international languages.