# Flookup Data Wrangler
> Flookup is a powerful data cleaning add-on for Google Sheets that enables users to perform fuzzy matching, deduplication and data normalisation directly within their spreadsheets. It is designed to be efficient, secure and accessible.
## Overview
Flookup helps Google Sheets users clean dirty data, standardise entries and perform advanced data matching without needing complex coding skills.
## Documentation
- [Documentation Home](/documentation/) - Guides and reference for the data cleaning tools in Google Sheets.
- [Desktop App Documentation](/desktop/documentation/) - Reference for the Windows desktop app, covering profiling, cleaning, matching and deduplication, verification, scheduled automation, licence activation and releasing a device.
- [Standard Data Cleaning](/documentation/menu-functions/) - This guide shows how to use the data cleaning tools for fuzzy matching, standardisation, deduplication, profiling, enrichment and conditional formatting.
- [Data Cleaning Spreadsheet Formulas](/documentation/custom-functions/) - This reference covers the FLOOKUP, FUZZYSIM, DEDUPE and ULIST formulas for fuzzy matching, similarity scores and fuzzy duplicate removal.
- [Learn from Examples](/documentation/learn-from-examples/) - This guide covers teaching the tool with dirty and clean example pairs so it learns the transformation without formulas or scripts.
- [Workflow Templates](/documentation/templates/) - These one-click templates run multi-step workflows for vendor reconciliation, order-to-shipping reconciliation and user list consolidation.
- [Sheets AI Assistant](/documentation/sheets-ai-assistant/) - This reference covers the single AI sidebar inside the add-on. Recommendation Mode gives formula suggestions and Execution Mode offers an Execute task dropdown with a Multi-step workflow option or a Direct AI clean option, all on an active pass or the 7-day AI trial with your own key. There is no standalone AI app and no AI enrichment feature.
- [Fuzzy Conditional Formatting](/documentation/conditional-formatting/) - This guide covers highlighting near-duplicate groups by percentage similarity with colour coding.
- [Data Cleaning Automation](/documentation/schedule-functions/) - This feature schedules data cleaning tasks to run without manual intervention.
## Pricing
- [Pricing Plans](/pricing/) - The free tier starts at install plus a 7-day AI trial, then a $10 1-Month Pass or a $100 1-Year Pass with nothing renewing. Nothing is charged during the trial.
- [Flookup Data Wrangler for Windows](/desktop/) - The desktop app is a separate product from the Sheets add-on. It has its own Pricing section with the one-time lifetime licence, the post purchase steps, what the app sends over the network, and how to verify the signed installer yourself.
## Blog and Insights
- [Blog Home](/blog/)
- [Use a Free CSV Editor Inside Google Sheets](/blog/free-csv-editor/) - This guide explains how to edit a CSV in Google Sheets with native functions, covering import, cleaning, deduplication, reshaping and export.
- [Compare CSV Files with a Free CSV Diff in Google Sheets](/blog/csv-diff-tool/) - This guide explains how to compare two CSV exports in Google Sheets and list the rows that were added, removed or changed.
- [Convert CSV to JSON for Free Inside Google Sheets](/blog/csv-json-tool/) - This guide explains how to convert CSV to JSON in Google Sheets with a formula or Apps Script, and how to parse JSON back into rows.
- [Join CSV Files with a Free CSV Join in Google Sheets](/blog/csv-join-tool/) - This guide explains how to join two CSV files in Google Sheets with XLOOKUP, COUNTIF and VSTACK, covering inner, left, right and full outer joins.
- [Split and Merge CSV Files with a Free CSV Splitter in Sheets](/blog/csv-split-tool/) - This guide explains how to split a CSV by rows or column value in Google Sheets and merge exports back into one tab with VSTACK.
- [Remove PII for Free Without Leaving Google Sheets](/blog/pii-scrub-tool/) - This guide explains how to find and then mask, redact or hash personal data in Google Sheets before a file is shared.
- [Google Sheets AI Assistant Cleans Data with a Prompt](/blog/sheets-ai-assistant-guide/) - This guide covers Recommendation Mode and Execution Mode with its Multi-step workflow and Direct AI clean paths.
- [How to Automate Data Cleaning in Google Sheets](/blog/automate-data-cleaning-google-sheets/) - This guide covers automating common cleaning tasks in Google Sheets.
- [CRM Data Cleaning for Marketing Teams](/blog/crm-data-cleaning/) - This guide shares strategies for cleaning CRM data, including account normalisation, email-domain matching, and segmentation-ready dedupe.
- [Dirty Data Horror Stories and Costly Spreadsheet Mistakes](/blog/dirty-data-horror-stories-spreadsheet-mistakes/) - This article collects real-world examples of spreadsheet errors caused by dirty data.
- [Entity Resolution for Data Reconciliation](/blog/entity-resolution-data-reconciliation-google-sheets/) - This guide covers matching and merging records across datasets.
- [Excel Fuzzy Lookup Alternative for Windows and Mac](/blog/excel-fuzzy-lookup-alternative/) - This article reviews the alternatives to Excel's fuzzy lookup, including the head-to-head on platform, thresholds and review sheets.
- [Duplicate and Fuzzy Highlighting in Google Sheets](/blog/fuzzy-conditional-formatting-highlight-duplicates/) - This guide covers highlighting near-duplicates with fuzzy matching.
- [Top 10 Fuzzy Matching Algorithms Explained](/blog/fuzzy-matching-algorithms-explained/) - This article gives an overview of the algorithms used in fuzzy matching.
- [Fuzzy Lookup Add-in for Mac and Alternatives](/blog/fuzzy-matching-mac-excel/) - This guide covers performing fuzzy matching on Mac, including data cleaning without Excel limits.
- [Microsoft Fuzzy Lookup Add-in for Excel](/blog/microsoft-fuzzy-lookup-add-in/) - What the free Fuzzy Lookup add-in does, how to install it on Windows, how to read the similarity score and when to use an alternative.
- [Soundex in Google Sheets for Name Matching](/blog/google-sheets-soundex-function/) - This guide explains how Soundex works in Sheets and which alternatives exist.
- [The Hidden Costs of Dirty Data in Google Sheets](/blog/hidden-costs-of-dirty-data/) - This article examines the impact of poor quality data on your organisation.
- [How to Remove Duplicates in Google Sheets](/blog/how-to-remove-duplicates-in-google-sheets/) - This guide covers removing duplicates manually and catching fuzzy matches with Flookup.
- [OpenRefine Alternatives for Data Cleaning in Google Sheets](/blog/openrefine-alternative-data-cleaning/) - This article compares OpenRefine, Flookup, Python and built-in Sheets tools for spreadsheet data cleaning.
- [Pandas vs Flookup for Data Cleaning](/blog/pandas-vs-flookup-data-wrangler/) - This article compares code-based pandas with the no-code Flookup approach.
- [Power Query vs Flookup for Data Cleaning](/blog/power-query-vs-flookup-data-wrangler/) - This article compares spreadsheet data cleaning approaches.
- [Ablebits Power Tools vs Flookup](/blog/ablebits-power-tools-vs-flookup-data-wrangler/) - This article compares the Google Sheets add-ons for deduplication and cleaning.
- [Alteryx vs Flookup for Google Sheets](/blog/alteryx-vs-flookup-data-wrangler/) - This article compares an enterprise analytics platform with spreadsheet-native data preparation.
- [WinPure vs Flookup for Data Cleaning](/blog/winpure-vs-flookup-data-wrangler/) - This head-to-head comparison covers profiling, cleansing, deduplication, golden records and database pulls for desktop data quality work.
- [Prepare Wikibase Data for QuickStatements in Google Sheets](/blog/wikibase-data-cleaning/) - This guide covers preparing spreadsheet data for Wikibase and QuickStatements imports.
- [AI Data Cleaning for Google Sheets](/blog/ai-data-cleaning/) - This article explains what AI cleaning tools do and when to use them, including the five-step RAG prep workflow.
- [Top 5 Fuzzy Matching Software and Tools](/blog/best-fuzzy-matching-software/) - This article ranks the top five fuzzy matching tools available today.
- [Consolidate Duplicate User Lists in Google Sheets](/blog/consolidate-duplicate-user-lists-google-sheets/) - This guide covers merging two user lists into one consolidated list of unique users.
- [How to Do Order Reconciliation with Shipping Records in Sheets](/blog/order-shipping-reconciliation-google-sheets/) - This guide covers matching orders against a shipping log and flagging unfulfilled orders.
- [Vendor Reconciliation Starts with Matching Supplier Names](/blog/vendor-reconciliation-google-sheets/) - This guide covers matching an accounts payable list against a master vendor table.
- [Fuzzy Name Matching for Names Spelled Differently](/blog/fuzzy-name-matching-guide/) - This guide covers matching customer and company names.
- [Fuzzy Address Matching in Google Sheets](/blog/fuzzy-address-matching/) - This guide covers matching and deduplicating addresses.
- [Python Fuzzy Matching Works Best with RapidFuzz and Pandas](/blog/python-data-cleaning-fuzzy-matching/) - This guide covers data cleaning with Python, including the R equivalent with dplyr and stringdist.
- [VLOOKUP vs Flookup for Fuzzy Name Matching](/blog/vlookup-vs-flookup-data-wrangler/) - This article compares VLOOKUP with fuzzy matching in Excel and Google Sheets.
- [XLOOKUP vs Flookup for Fuzzy Name Matching](/blog/xlookup-vs-flookup-data-wrangler/) - This article compares XLOOKUP with fuzzy matching in Excel and Google Sheets.
- [How to Do Fuzzy Matching in Google Sheets](/blog/fuzzy-matching-in-google-sheets/) - This guide covers comparing columns with fuzzy matching in Sheets, including QUERY, REGEX, IMPORTRANGE and reusable Named Functions recipes.
- [Find Duplicates in Google Sheets with COUNTIF and Formatting](/blog/find-duplicates-conditional-formatting-countif-google-sheets/) - This guide explains how to highlight duplicates with COUNTIF and COUNTIFS, and it includes a measured accuracy test.
- [Data Trust for AI and RAG in Google Sheets](/blog/semantic-data-trust-layer-ai-rag/) - This article explains data trust for AI RAG pipelines.
- [Semantic Fuzzy Matching with AI in Google Sheets](/blog/semantic-fuzzy-matching-embeddings/) - This guide covers using embeddings for semantic matching.
- [SEO Site Migration and Redirect Mapping](/blog/seo-site-migration-google-sheets/) - This guide covers SEO migrations using Sheets.
- [Standardise Customer Names in Google Sheets](/blog/standardise-customer-names-learn-from-examples/) - This guide explains how to standardise customer names with practical examples.
- [Standardise Phone Numbers in Google Sheets](/blog/standardise-phone-numbers-learn-from-examples/) - This guide explains how to standardise phone numbers with practical examples.
- [Teach Google Sheets to Clean Product Codes Without Formulas](/blog/teach-product-code-standardisation-learn-from-examples/) - This guide explains how to standardise product codes with practical examples.
- [What Is Data Cleaning? A Guide for Google Sheets](/blog/what-is-data-cleaning/) - This article explains the fundamentals of data cleaning, including the repeatable Sheets checklist.
- [Use a Data Quality Audit Checklist Before You Clean Any Rows in Google Sheets](/blog/data-quality-audit-checklist-google-sheets/) - This article offers a practical checklist for evaluating data quality across six dimensions.
- [Semantic Fuzzy Matching with AI in Google Sheets](/blog/semantic-fuzzy-matching-embeddings/) - This guide covers using embeddings for semantic matching, including hybrid lexical plus semantic implementation.
- [How to Clean Email Lists in Google Sheets](/blog/clean-email-lists-google-sheets/) - This article covers trim, format checks, domain typo flagging and deduplication for a send-ready list.
- [Clean Google Sheets Without Formulas Using Flookup](/blog/clean-google-sheets-without-formulas-desktop/) - This article shows how to pull a range into the desktop app, standardise and dedupe locally and write reviewed values back.
- [RapidFuzz vs Flookup for Python Fuzzy Matching](/blog/rapidfuzz-vs-flookup-data-wrangler/) - This article compares Python RapidFuzz code with no-code fuzzy matching in Google Sheets, including Mac setup and an example.
- [How to Merge Salesforce Duplicate Leads Without Losing Data](/blog/salesforce-dedupe-duplicate-leads-contacts/) - This article covers SOQL pulls, fuzzy matching and writing reviewed changes back with undo.
- [How to Remove Duplicate Records in Airtable with an Undo](/blog/airtable-dedupe-duplicate-records/) - This article covers finding duplicates with a formula, grouping them for review and undoing any merge that looks wrong.
## Support
- [About Us](/about-us/) - This page introduces the Flookup team.
- [Get Started](/get-started/) - This page guides you through getting started with Flookup.
- [Contact Us](/contact-us/) - This page explains how to contact the Flookup support team.
- [Privacy Policy](/privacy-policy/) - This page explains how Flookup protects your data privacy.
- [Refund Policy](/refund-policy/) - This page explains the refund conditions for Flookup products.
- [Terms and Conditions](/terms/) - This page contains the terms and conditions for Flookup products.