FLOOKUP DOCUMENTATION OVERVIEW
Custom Functions
This section of the documentation details our formula-based custom functions.
They are designed for quick operations directly within your spreadsheet cells and can be typed just like
standard Google Sheets functions. See the linked pages below for a detailed demo spreadsheet and comprehensive guide on usage. For menu-driven alternatives with longer timeouts, see our
menu functions section.
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. For formula-based alternatives, see our
custom functions
documentation.
Compare Text for Similarity
Instructions for performing fuzzy similarity comparisons, both by percentage and by semantic meaning.
Import Data from CRMs
Instructions for connecting to various CRM systems and extracting relevant data for analysis.
Standardize Data
Clean and standardize your data by grouping similar text entries using advanced fuzzy matching algorithms.
Fuzzy Match Data
Match and merge data from different sources using intelligent text similarity algorithms to find corresponding records.
Highlight Duplicates
Identify and highlight duplicate or similar entries in your data with customizable similarity thresholds.
Remove Duplicates
Automatically remove duplicate entries from your dataset while preserving data integrity and structure.
Schedule Functions
Automate your data cleaning workflows by scheduling Flookup functions to run at specified intervals.
Intelligent Data Cleaning
Leverage advanced AI capabilities to enhance your data cleaning and transformation processes.