Flookup 3.0
Fuzzy lookup, merge and remove duplicates by text similarity
Listed in categories:
DataProductivitySpreadsheets
Description
Flookup is a lightweight data cleaning addon for Google Sheets that helps users clean any type of dataset, no matter how dirty. It offers various functionalities such as fuzzy matching, duplicate removal, and text extraction, ensuring that your data is accurate and reliable.
How to use Flookup 3.0?
To use Flookup, simply install the addon in Google Sheets, select the dataset you want to clean, and choose the desired cleaning function from the Flookup menu. The addon will process the data and provide you with cleaned results.
Core features of Flookup 3.0:
1️⃣
Fuzzy matching data for record linkage or reconciliation
2️⃣
Highlighting and removing duplicate text entries
3️⃣
Measuring the level of similarity between text entries
4️⃣
Removing unwanted words, diacritics, and punctuation marks
5️⃣
Extracting a unique list of values from fuzzy duplicate text entries
Why could be used Flookup 3.0?
| # | Use case | Status | |
|---|---|---|---|
| # 1 | Cleaning messy datasets in Google Sheets | ✅ | |
| # 2 | Preparing data for analysis and reporting | ✅ | |
| # 3 | Ensuring data accuracy for business decision-making | ✅ | |
Who developed Flookup 3.0?
Flookup is developed by Andrew Apell, who has focused on creating a reliable and efficient data cleaning solution for users of Google Sheets since 2018.