FLOOKUP DOCUMENTATION OVERVIEW
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 advisorural planning.
Access the tool in your spreadsheet menu via Extensions > Flookup Data Wrangler > Spreadsheet solver. Describe your goal in plain language and the Advisor will draft an engineered logic solution specifically tailored to your current sheet's 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 Menu Functions.
Custom functions are accessed by typing them directly into your spreadsheet cells (e.g. =FLOOKUP) and have a 30-second timeout, making them perfect for quick, real-time results. Before you dive in, you can see them in action by visiting our live demo.
Menu functions, accessible via Extensions > Flookup Data Wrangler, have a robust 6-minute timeout, ideal for handling large datasets and complex operations. When using these functions, ensure that the sidebar remains open until the operation is complete. The only exception is the "schedule functions" feature which you can close after the setting up.
Custom Functions
Use powerful spreadsheet formulas like FLOOKUP, NORMALIZE and ULIST directly in your cells for real-time data cleaning.
Intelligent Data Cleaning
Harness the power of AI to clean and enrich your datasets with semantic matching and intelligent cleaning.
Match and Merge
Reconcile and merge datasets using advanced fuzzy lookup and similarity matching to find what you need.
Standardize Data
Clean and normalise text entries by removing noise such as punctuation, diacritics and unwanted words.
Compare Text
Calculate the percentage similarity between text entries using advanced fuzzy matching algorithms.
Remove Duplicates
Automatically remove duplicate entries from your dataset while preserving data integrity and structure.
Highlight Duplicates
Identify and highlight duplicate or similar entries in your data with customizable similarity thresholds.
Schedule Functions
Set your data cleaning on autopilot. Schedule Flookup to run hourly or daily, ensuring your large datasets are always up-to-date without manual effort.