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. Auto-chaining handles large datasets across execution windows.
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.
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
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.
Try an Interactive Demo
Type values and watch NORMALIZE, FUZZYSIM, FLOOKUP, SHEETMERGE, QLOOKUP, HFLOOKUP, DEDUPE and ULIST compute live in your browser. No account or spreadsheet needed.
Last updated: August 2026