Data Cleaning, Profiling and Enrichment for Google Sheets
Turn messy Google Sheets into reliable data in minutes, not hours. Flookup is a Google Sheets add-on that uses fuzzy matching to clean, deduplicate, profile, enrich and standardise your records without writing code.
149K+ users on Google Workspace Marketplace · 10,000+ daily active users · Since 2018 · Google-verified
Fuzzy Matching Returns the Best Match and Similarity Score
Flookup compares each source value with your lookup table and returns the closest match with its score for review.
| Source value | Best match | Score |
|---|---|---|
| Apex Consultin | Apex Consulting | 89% |
| Data Cleanning | Data Cleaning | 88% |
| Blue Widget Large | Blue Widget Large Blue | 89% |
| SKU-1234 | SKU1234 | 100% |
| 2025 Sales Report | 2025 Sales Reports | 87% |
Join Over 10,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."
See Flookup in Action
Free Tools from Flookup
Try fuzzy matching before installing anything. Paste two lists and get similarity scores instantly in your browser. No signup, no upload, and your data never leaves your device.
CSV Editor
Inspect, clean, deduplicate, filter, sort and transform CSV files with a CSV health report. Handles huge files in streaming mode, right in your browser.
Fuzzy Matching Tool
Paste two lists and get a similarity score for every match. Spot near-duplicates in seconds, without uploading anything.
CSV Diff
Compare two CSV files by a key column and see added, removed and changed rows instantly, with a match rate and downloadable diff.
Need it inside Google Sheets? Install Flookup or start with the $3.99 Week Pass.
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
Select the workflow that best aligns with your source data to rapidly clean records using our sophisticated fuzzy matching and standardisation tools. Flookup runs inside Google Sheets.
If you use Microsoft Excel, start with Excel Fuzzy Lookup Alternative and Fuzzy Matching for Mac Excel.
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.
Workflow Templates
One-click AP reconciliation, order-to-shipping and user list consolidation jobs.
Learn from Examples
Show dirty-clean example pairs and the system learns the transformation without any formulas.
Data Cleaning Automation
Schedule deduplication and standardisation from every 15 minutes to daily.
Sheets AI Assistant
Describe your data problem in plain language and receive formulas or direct execution.
Data Cleaning Spreadsheet Formulas
Type FLOOKUP, FUZZYSIM, DEDUPE and ULIST directly into cells.
Column Profiling
Scan a column for row counts, nulls, duplicates and format inconsistencies.
Enrich Data
Add ISO countries, US states, company suffixes and TLDs next to your input.
Still Have Questions?
Read our FAQs or Contact Us for more information.
Last updated: August 2026