Data Cleaning Documentation for Google Sheets
Flookup Data Wrangler offers three ways to clean data in Google Sheets: custom functions typed directly in cells, menu-driven tools for visual review and automation and an AI assistant for formula guidance.
Custom Functions (Cell Formulas)
Type formulas like =FLOOKUP, =NORMALIZE or =DEDUPE directly into spreadsheet cells for real-time results. These have a 30-second timeout, making them ideal for quick results on regular sized datasets.
See them in action on our Live Demo.
Custom Functions Index
Complete reference for all formulas: FLOOKUP, NORMALIZE, DEDUPE, FUZZYSIM, ULIST and more.
Match and Merge Data
Reconcile two datasets by fuzzy matching records and pulling in related fields from a lookup table, all in one step.
Standardize Data
Strip punctuation, diacritics and unwanted words from text columns to produce consistently formatted entries.
Compare Text for Similarity
Score the percentage similarity between two columns using character-level or word-level fuzzy algorithms.
Remove Duplicates
Delete near-duplicate rows from your sheet using configurable similarity thresholds. Catches what exact matching misses.
Menu Functions (Sidebar Tools)
Access these tools from Extensions > Flookup Data Wrangler.
Fuzzy Conditional Formatting
Access via Extensions > Flookup Data Wrangler > Fuzzy Conditional Formatting. Highlight near-duplicate groups with colour coding by percentage or sound similarity. Review visually before making destructive changes.
Schedule Functions
Access via Extensions > Flookup Data Wrangler > Schedule Functions. Automate deduplication and standardisation on autopilot. Set hourly or daily cadences to process large datasets in the background. Close the sidebar after configuration and get email alerts when processing completes.
Fuzzy Conditional Formatting
Highlight duplicate groups with clear colour coding by percentage or sound similarity. Review first, then clean with confidence.
Schedule Data Cleaning
Run deduplication and standardisation on autopilot. Set hourly or daily cadences to keep your sheets clean without manual effort.
Spreadsheet Solver
The Spreadsheet Solver is a context-aware AI assistant integrated into Flookup Data Wrangler. Access it via Extensions > Flookup Data Wrangler > Spreadsheet Solver.
Select a range you want to focus on, then describe your goal in plain language. The Solver will draft a solution tailored to your current dataset structure, using both Flookup functions and native Google Sheets formulas.