Data Cleaning Documentation for Google Sheets
Data Cleaning Tools
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 three modes. Recommendation Mode suggests formulas and cleaning steps. Execution Mode runs multi-step workflows automatically. AI Enrichment Mode adds AI context to any column at a flat cost of 50 credits. Every feature can be tested on the demo spreadsheet before you buy.
Run from the Sidebar
Data Cleaning Tools
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
Three modes in one assistant: Recommendation Mode suggests formulas and cleaning steps, Execution Mode runs multi-step workflows automatically and AI Enrichment Mode adds AI context to any column.
Type into a Cell
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.
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.
Last updated: August 2026