FLOOKUP DOCUMENTATION OVERVIEW
Introduction to Flookup Functions
Discover our menu functions, accessible via
Extensions > Flookup Data Wrangler.
These tools, detailed in this guide, have a robust 6-minute timeout, making them ideal for handling large datasets and complex data cleaning operations. Each page below offers specific guides on how to use its respective function.
Fuzzy Match Data
Compare and link records based on percentage or sound similarity, crucial for creating a unified single source of truth.
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.
Standardize Data
Create consistent, accurate data by normalizing text formats, removing unwanted characters or extracting URL components.
Compare Text
Generate a precise similarity score between two text or numeric inputs using various fuzzy matching algorithms.
Introduction to Custom Functions
Custom functions are a feature of the Data Edge plan that integrate directly into your spreadsheet cells, operating like native Google Sheets functions e.g. =SUM(A1, B1). They are designed for dynamic, real-time data processing, offering a formula-based approach to advanced data cleaning tasks.