Data Cleaning Made Easy

Clean Your Datasets With the Power of Fuzzy String Matching

One Add-on, Nine Awesome Solutions

Flookup is a suite of functions that use fuzzy string matching to compare, merge, highlight and dedupe data in Google Sheets. This unique approach to data cleaning allows you to do the following tasks regardless of spelling differences, partial matches or text errors in your data:

    • Remove stop words and diacritical marks.

    • Remove duplicates.

    • Highlight duplicates.

    • Lookup or merge fuzzy data (record linkage).

    • Extract unique values from a list of fuzzy duplicates.

    • Calculate the percentage similarity between strings.

Flookup functions are not affected by the sort order of columns or rows, punctuation marks or the case of the text. Flookup will not only help you improve efficiency, reduce your error rate and increase productivity, but it will also help you save money.

What Is Fuzzy String Matching?

Fuzzy string matching is a technique of comparing and attempting to link strings that are less than exact match. This also means that fuzzy string matching algorithms should be able to indicate the level of similarity between matched string pairs. There are different approaches to fuzzy string matching and they all have different scales they use to determine percentage similarities but most of them process the text in any of the following ways:

    • Counting how many deletions, insertions and swaps need to be performed on one string in order to make it look as close as possible to any other string. This is called Edit Distance.

    • Breaking up the strings into substrings and then mathematically analysing how many of them are shared between the two strings being compared.

    • Indexing strings by the way they sound and then comparing those indices for similarity.

Did You Know?

The 1-10-100 principle states that it will cost you $1 to verify the quality of your data, $10 to clean each item in it and $100 to store each item that is not cleaned.

50,000+ individuals already trust Flookup, including these guys

Flookup Sample testimonial: Match addresses
Flookup Sample testimonial: Match names
Flookup Sample testimonial: Time saver

Five Reasons Why You Will Also Love Flookup

Flookup is a powerful, no-frills approach to data cleaning in Google Sheets. Here are five reasons why you will love Flookup and why you should add it to your toolkit today:

  • It is easy to use. Flookup has familiar, intuitive and easy-to-use functions, making it easy to learn and master.

  • It is secure. Flookup does not expose, store or share any of the spreadsheet data it processes, meaning that your data remains private and for your eyes only. [Learn more]

  • It is fast. Flookup runs on one of the fastest fuzzy string matching algorithms online and all its functions are optimised to complete tasks in the shortest time possible.

  • It is reliable. Flookup is powered by a battle-tested algorithm with millions of rows and columns of data under its belt.

  • It speaks your language. Flookup is not limited to English; it can process text in most international languages.

These are just a few of the reasons that make Flookup a great data cleaning solution for you and your business. Every aspect is designed to bring speed, reliability and consistency to your data cleaning process.