FUZZY MATCH, HIGHLIGHT AND REMOVE DUPLICATES

How Flookup Data Wrangler Works

Flookup is a lightweight data cleaning suite for Google Sheets. It can be used to clean dirty datasets in the following ways, regardless of any text-based differences:

• • 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.

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

Why Choose Flookup Data Wrangler?

• • Reliability. The core algorithm of Flookup has been meticulously refined over many years by cleaning thousands of datasets, resulting in highly reliable results from every data cleaning operation.

  • Built-in privacy. Flookup does not expose, store or share any of the spreadsheet data it processes, ensuring that it remains secure and sandboxed inside your Google account. Not even your own colleagues will be able to see what data Flookup is processing for you.

  • Speed and efficiency. Flookup is powered by a couple of optmised fuzzy matching algorithms and all its data cleaning functions are optimised to complete their respective tasks in the shortest times possible.

  • Instant backup and restore. By reason of being a Google Sheets add-on, all operations completed by Flookup can be easily undone by clicking the "Undo" or by recovering the spreadsheet using the Version history feature found in the spreadsheet menu.

  • Cost-effective cleaning. Flookup offers all essential data cleaning functions at a significantly lower cost compared to industry alternatives and our plans do not automatically renew, thereby eliminating surprise bills in future.