Enhanced Data Cleaning for Google Sheets
Flookup is a Google Sheets add-on that uses fuzzy matching to clean, deduplicate and standardise your data.
Featured Articles from the Blog
Read practical guides on data cleaning, fuzzy matching and automation in Google Sheets.
Start with Your Preferred Data Cleaning Operation
Choose the workflow that matches your source data and clean records quickly with fuzzy matching, deduplication and standardisation tools.
All Custom Functions
Complete reference for all formulas: =FLOOKUP, =NORMALIZE, =DEDUPE, =FUZZYSIM, =ULIST and more.
Match and Merge Data
Reconcile disparate datasets with =FLOOKUP and =SHEETMERGE to identify matches across variations.
Remove Duplicates
Use =DEDUPE to eliminate near-duplicates with configurable similarity thresholds.
Compare Text for Similarity
Calculate percentage similarity between text entries using =FUZZYSIM.
Standardize Data
Clean and normalise text with =NORMALIZE to ensure consistency across datasets.
Schedule Data Cleaning
Automate your cleaning workflows. Set hourly or daily schedules to keep sheets clean without manual effort.
Join Thousands of Satisfied Users
"Flookup has been a game-changer. The fuzzy matching function saves me hours of manual work cleansing data across multiple files. So much faster and more accurate than anything else I have tried!"
"This tool fits perfectly into our Google Sheets workflows. The fuzzy matching is easy to use and the customer support team is incredibly helpful. Highly recommended!"
"The FLOOKUP formula is fantastic for fuzzy matching and address scraping. It has saved us weeks of work and improved our data quality significantly. A must-have add-on!"
"Fantastic customer service and a huge time-saver for data cleansing. The ability to handle thousands of rows efficiently has transformed how we manage our spreadsheet data."