Data Cleaning Documentation for Google Sheets
Standard Data Cleaning
cover fuzzy matching, deduplication, text standardisation, column profiling, enrichment, comparison and conditional formatting. They also bundle into one-click Workflow Templates for reconciliation and consolidation. You can also
train
Flookup to learn from examples.
Data Cleaning Spreadsheet Formulas
are spreadsheet functions you type directly into a cell, such as
=FLOOKUP
or
=DEDUPE,
for quick fuzzy lookups, similarity checks and deduplication.
Data Cleaning Automation
automates recurring workflows at 15-minute, hourly or daily intervals. It handles large datasets across execution windows, even in your absence.
Sheets AI Assistant
adds AI-powered guidance in one sidebar. The Data Cleaning Guide suggests formulas and cleaning steps in Recommendation Mode and runs multi-step workflows automatically in Execution Mode. Direct AI clean adds AI-powered cleaning with a plain language description box. Every feature can be tested on the demo spreadsheet before you buy.
Run from the Sidebar
Standard Data Cleaning
Fuzzy matching, deduplication, text standardisation, column profiling, enrichment, similarity comparison and conditional formatting. Profile your data to detect issues, then clean it with one click.
Data Cleaning Automation
Schedule data cleaning to run every 15 minutes, hourly or daily. Process large datasets automatically with auto-chaining across execution windows. No manual intervention needed.
Sheets AI Assistant
One sidebar in one menu item: the Data Cleaning Guide suggests formulas and cleaning steps in Recommendation Mode and runs multi-step workflows automatically in Execution Mode. Direct AI clean applies AI-powered cleaning to your range from a plain language description.
Type into a Cell
Data Cleaning Spreadsheet Formulas
Type Data Cleaning Spreadsheet Formulas such as FLOOKUP, FUZZYSIM, DEDUPE and ULIST directly into cells for quick lookups and spot checks. Included with paid plans.
Demo Spreadsheet
Try custom functions directly in cells: FLOOKUP, FUZZYSIM, ULIST and DEDUPE work on sample data. This is a demo, so Run shows how to install Flookup and get Data Nova for your own data.
Last updated: August 2026