FUZZY MATCH, HIGHLIGHT AND REMOVE DUPLICATES

How Flookup Works

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

Its core runs on two fuzzy matching algorithms that it uses to clean data regardless of spelling or any other text-based differences in your datasets. 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 revenue savings for you and your organisation.

Here is a brief overview of the data cleaning features of Flookup:

• • Highlight and remove duplicates.

  • Fuzzy match data i.e. record linkage or reconciliation.

  • Extract a unique list of values from fuzzy duplicates.

  • Measure the level of similarity between text entries based on percentages.

  • Remove or delete unwanted words, diacritics and punctuation marks.

How to Start Your 3-Day Free Trial

• 1. Install Flookup from the Workspace Marketplace. If any error occurs, you might need to temporarily sign out of secondary accounts or use incognito mode.

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

  3. Fill in your "Subscriber Email Address" i.e. the email you use to access Google Sheets, your full name, click the "Submit" button and wait for the confirmation message.

  4. Click the "Update status" button on that same window to update your free trial status.

To learn how to upgrade your subscription, simply follow the detailed set of instructions found in our subscription guide.

Why Choose Flookup?

• • Built-in privacy. Flookup does not expose, store or share any of the spreadsheet data it processes, ensuring that your data remains secure and sandboxed to your Google account.

  • Speed and efficiency. Flookup utilises one of the fastest fuzzy matching algorithms online and all its data cleaning functions are optimised to complete their respective tasks in the shortest times possible.

  • Ease-of-use. Flookup functions are familiar, intuitive and easy-to-use, making it easy to master almost immediately.

  • Instant backup and restore. By reason of being a Google Sheets add-on, operations 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.

  • Limitless upgrades. Flookup is regularly under development and upgrades remain free forever. To keep up with our latest updates, please follow us on Twitter.