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.
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.
Remove Duplicates
Use =DEDUPE to eliminate near-duplicates with configurable similarity thresholds. Choose to keep first or last occurrence, with phonetic or percentage-based matching.
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."