Flookup Documentation and Guides
Introducing the Spreadsheet solver
The Spreadsheet solver is a context-aware AI assistant integrated directly into the Flookup Data Wrangler. It serves as an expert consultant for complex spreadsheet logic and planning.
Access the tool in your spreadsheet menu via Extensions > Flookup Data Wrangler > Spreadsheet solver.
First, select a range you want to focus on. Then describe your goal in plain language and the Solver will draft a solution specifically tailored to your current dataset structure.
Key Capabilities
| Capability | Description |
|---|---|
| Ecosystem intelligence | Natively trained to identify when to use Flookup tools versus native Google Sheets functions. |
| Session memory | Allows follow-up questions and refined logic iteratively without losing context. |
| Data vision | Analyzes real-time data samples to ensure suggested formulas are syntactically compatible with your data types. |
| Intelligent guidance | Provides advice to steer ambiguous or logically flawed requests toward more robust solutions. |
Introduction to Flookup Functions
Flookup offers two ways to clean your data: Custom Functions and Schedule Functions.
Custom functions are typed directly into your spreadsheet cells (e.g. =FLOOKUP or =NORMALIZE) and have a 30-second timeout, making them ideal for quick, real-time results on smaller datasets.
They are available on the paid plan. See them in action on our Live Demo.
Schedule functions, accessible via Extensions > Flookup Data Wrangler > Schedule functions, have a robust 6-minute execution window and are better suited for handling large datasets and complex operations. When using schedule functions, keep the sidebar open until your operation completes.
All Custom Functions
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.
Schedule Data Cleaning
Run deduplication and standardisation on autopilot. Set hourly or daily cadences to keep your sheets clean without manual effort.