Data Cleaning Documentation for Google Sheets
Custom functions
match, normalise, compare, deduplicate and extract unique data with NORMALIZE, FUZZYSIM, FLOOKUP, SHEETMERGE, QLOOKUP, HFLOOKUP, ULIST and DEDUPE.
Data Cleaning Automation
runs those functions as chunked batch jobs on a schedule, so large datasets are processed without manual intervention.
Sheets AI Assistant
suggests formulas for Google Sheets, including native functions and Flookup custom functions, and explains how to apply them.
Data Connectors
pull Airtable, SQL and Salesforce records into a staging sheet from the same sidebar and keep record ids so write-back to Airtable and SQL updates only the rows you changed.
Use the guides below to find setup steps, function references and examples for each feature in Google Sheets.
Worked example. Formulas and results on real rows are shown in Clean Google Sheets Without Formulas Using Flookup.
Core Features
Custom Functions
Match, normalise, compare, deduplicate and extract unique data with formulas in your sheet. Results update as your data changes and are written where you place the formula.
Data Cleaning Automation
Schedule custom-function batch jobs to run every 15 minutes, hourly or daily.
Process large datasets automatically with auto-chaining across execution windows. No manual intervention is required.
Sheets AI Assistant
Describe a cleaning or lookup problem and get a Google Sheets formula, using native functions and Flookup custom functions. Bring your own Gemini or OpenAI key.
Pull Data In
Airtable Connector
Connect a base with a personal access token, keep record ids for safe updates and write changed fields back without touching the columns you did not edit.
SQL Database Connector
PostgreSQL, MySQL, SQL Server and Oracle through a read-only query, with a key column so write-back can update the right rows and never delete any.
Salesforce Connector
Authorise with OAuth through a Connected App, choose objects and fields, run SOQL and pull records into the staging sheet. Read only.
Focused Guides
Custom Functions
Reference for every Flookup function, including arguments, examples and the situations each one fits.
Sheets AI Assistant
Ask for a formula in plain language and get a suggestion that uses native Sheets functions, Flookup functions or both.
Data Connectors
Connect Airtable, SQL and Salesforce, pull records into a staging sheet and write changes back safely.