Data Cleaning and Fuzzy Matching for Google Sheets
Flookup is a Google Sheets add-on that uses fuzzy matching for data cleaning, deduplication and standardisation, with AI formula help, connectors and scheduled batch jobs.
Looking around first? See custom functions or read the Get Started guide.
12,000+ daily active users · Since 2018 · Google-verified for security · Google Workspace Marketplace
Start a 14-day trial with 50 action credits from Subscription Management > Dashboard > Fetch status. No credit card required.
Custom functions are not metered by recalculation. Explicit actions, including AI requests, connector actions or runs and scheduled jobs or runs, use action credits on metered passes.
Simple access and action credits
Start with a 14-day trial with 50 action credits in Subscription Management by opening Dashboard and clicking Fetch status. Custom functions run as formulas and are not metered by recalculation.
Explicit actions such as AI assistant requests, connector actions or runs and scheduled jobs or runs use action credits on metered passes. Trial includes 50 action credits for explicit actions and nothing renews automatically.
Who Uses Flookup?
Flookup is built for people who clean and match records in spreadsheets. The common thread is a list of names, organisations or records that do not quite match and a deadline.
Researchers and Academics
Match author, institution and survey-response names across datasets without exporting to another tool.
Librarians and GLAM Teams
Clean catalogue records, authority files and collection metadata while keeping the work visible in the sheet.
Data Analysts and Operations
Deduplicate customer, supplier and product lists, then standardise the variants that exact matching misses.
The same workflow fits sales, finance, HR and admin teams that need to reconcile lists before a report, migration or upload.
Join Over 12,000 Daily Active Users
"Flookup has been a game-changer. The fuzzy matching function saves me hours of manual work cleansing data across multiple files. So much faster and more accurate than anything else I have tried!"
"This tool fits perfectly into our Google Sheets workflows. The fuzzy matching is easy to use and the customer support team is incredibly helpful. Highly recommended!"
"Flookup is fantastic for fuzzy matching and address scraping. It has saved us weeks of work and improved our data quality significantly. A must-have add-on!"
"Fantastic customer service and a huge time-saver for data cleansing. The ability to handle thousands of rows efficiently has transformed how we manage our spreadsheet data."
Featured Articles from the Blog
Read practical guides on data cleaning, fuzzy matching and automation in Google Sheets.
What Is Data Cleaning? A Guide for Google Sheets
Understand the fundamentals of data cleaning in Google Sheets. This guide covers key concepts, common data quality issues and practical strategies using Flookup Data Wrangler, plus a short checklist to get started.
Top 10 Fuzzy Matching Algorithms Explained
Go beyond exact matches. This guide demystifies fuzzy matching algorithms, explaining how they work, what similarity scores mean and how to apply them for smarter data cleaning. Includes recommended thresholds and examples to help you choose settings.
How to Remove Duplicates in Google Sheets
Go beyond basic duplicate removal. This guide shows you how to eliminate all types of duplicates in Google Sheets, including fuzzy and partial matches, using Flookup. Step-by-step examples make it easy to follow along on your own data.
Comparing tools? Start with Power Query vs Flookup Data Wrangler, Ablebits Power Tools vs Flookup Data Wrangler and Alteryx vs Flookup Data Wrangler.
Advanced Data Cleaning Operations
Choose the workflow that matches your dataset. Use Flookup custom functions for fuzzy matching, deduplication and standardisation directly in Google Sheets.
Fuzzy Matching
Reconcile records across datasets despite typos, abbreviations and inconsistent formatting.
Deduplication
Remove near-duplicate rows that exact matching misses, including phonetic and typo variants.
Standardisation
Normalise text, punctuation, diacritics, domains and paths with NORMALIZE.
Last updated: October 2026