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.
Advanced Data Cleaning Operations
Select the workflow that best aligns with your source data to rapidly clean records using our sophisticated fuzzy matching and standardisation tools.
Custom Functions Reference
Consult our comprehensive reference for syntax, parameters and practical examples for all formulas, including =FLOOKUP, =NORMALIZE and =DEDUPE.
Reconcile and Merge Data
Identify matches across variations such as typos and abbreviations to reconcile disparate datasets automatically using the =FLOOKUP and =SHEETMERGE functions.
Detect and Highlight Duplicates
Apply fuzzy conditional formatting to detect near-duplicate groups by percentage or phonetic similarity before you proceed with any data cleanup operations.
Measure Textual Similarity
Utilise the =FUZZYSIM function to determine the percentage similarity between text entries, which is ideal for detecting inconsistencies across various data sources.
Standardise and Normalise Data
Ensure absolute consistency across your datasets by using the =NORMALIZE function to remove diacritics, stop words and punctuation.
Automated Data Cleaning
Process extensive datasets automatically by scheduling tasks to run at intervals ranging from fifteen minutes to one month, ensuring continuous data maintenance.
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."