How Flookup Works

Flookup is a lightweight data cleaning add-on for Google Sheets.

Its core runs on two fuzzy matching algorithms that empower it to clean data regardless of spelling or any other text-based differences in your datasets. Here is a brief overview of Flookup's data cleaning features:

    • Highlighting and removing duplicates.

    • Fuzzy lookup or fuzzy matching data i.e. record linkage.

    • Extracting unique values from fuzzy duplicates.

    • Analysing percentage similarities between text entries.

    • Removing unwanted words, diacritics and punctuation marks.

Flookup will not only lead to improved efficiency, increased productivity and reduced error rates in your data cleaning process, but it will also lead to significant revenue savings for your organisation.

How to Start Your Standard Free Trial

    1. Install Flookup from the Google Workspace Marketplace.

    2. Open the secure form located in your spreadsheet menu at Extensions > Flookup > Manage subscription > Free trial.

    3. Subscribe by entering your "Subscriber Email Address" and click "Proceed". This should be the email of the user who installed Flookup.

    4. Return to your spreadsheet and click the "Update status" button found at Extensions > Flookup > About Flookup. This will fetch your updated subscription status.

    • Important details about your free trial / subscription are discussed here.

    • If your subscription is still inactive after following the steps above, please follow these troubleshooting steps.

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.

    • 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 safe to use. Any operation that is completed by Flookup can be undone by clicking "Undo" or by recovering the spreadsheet through the File > Version history > See version history feature in the spreadsheet menu.

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

    • It is platform-independent. By reason of being a Google Sheets add-on, Flookup supports all major Operating Systems like Windows, macOS and Linux.

    • It understands your language. Flookup is not limited to processing text entries in English; you can just as easily use it to process text entries in most international languages.

    • It is always up-to-date. Flookup is constantly under development and its upgrades are free forever. To view our latest updates, please refer to our changelog.

7,000+ People Use Flookup on a Daily Basis. This Is What They Say

Testimonial #1: Flookup made data cleaning easier by matching names with spelled different spellings
Testimonial #2: Flookup made address-matching an easier exercise
Testimonial #3: Flookup made data cleaning more efficient and adaptable to the task
Testimonial #4: Flookup was a data cleaning time saver
Data Cleaning, Data Cleansing, Fuzzy Lookup, Fuzzy Lookup Excel, Fuzzy Lookup Online, Levenshtein, How to highlight duplicates in Google Sheets
Alteryx, Data Ladder, Dedupely, OpenRefine, WinPure, Flookup, Trifacta, How to remove duplicates in Google Sheets