FLOOKUP DOCUMENTATION OVERVIEW
Introduction to Menu 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.
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.
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.
Introduction to Custom Functions
Custom functions are formulas you can use directly in your spreadsheet cells, just like native Google Sheets functions e.g. =SUM(A1, B1). They are perfect for dynamic, real-time data processing and have a 30-second timeout.