Free 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.
Custom Functions Index
Complete reference for all formulas: =FLOOKUP, =NORMALIZE, =DEDUPE, =FUZZYSIM, =ULIST and more. Includes syntax, parameters, examples and use cases.
Match and Merge Data
Reconcile disparate datasets with =FLOOKUP and =SHEETMERGE to identify matches across variations. Handle typos, abbreviations and formatting differences automatically.
Highlight Duplicates
Highlight duplicates in Google Sheets with fuzzy conditional formatting. Review near-duplicate groups by percentage or sound similarity before applying destructive cleanup steps.
Compare Text for Similarity
Calculate percentage similarity between text entries using =FUZZYSIM. Compare by word or phrase, ideal for validating data across sources and detecting inconsistencies.
Standardize Data
Clean and normalise text with =NORMALIZE to ensure consistency across datasets. Remove diacritics, stop words, punctuation or extract URL components.
Schedule Data Cleaning
Automate data cleaning for datasets of any size. Schedule tasks from 15 minutes to monthly, with auto-chaining that continuously processes thousands or millions of rows.
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."