# 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/)
  - [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.
- [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 at 50 credits per request and Execution Mode offers an Execute task dropdown with Multi-step workflow at 25 credits per plan plus step rates and Direct AI clean at 10 credits per value. There is no standalone AI app and no AI enrichment feature.
- [Fuzzy Conditional Formatting](/documentation/menu-functions/#fuzzy-conditional-formatting) - This feature highlights duplicates with fuzzy matching so you can review them before removal.
- [Data Cleaning Automation](/documentation/schedule-functions/) - This feature schedules data cleaning tasks to run without manual intervention.
## Pricing
- [Pricing Plans](/pricing/) - The pricing options are simple, with one-time purchases instead of subscriptions.
## Free Tools
- [Free Tools](/tools/) - These free, private tools run in your browser. Files are processed locally and never leave the device.
- [Free Tools Tutorial](/tools/tutorial/) - This step-by-step tutorial walks through Free CSV Editor, Fuzzy Matching Tool, CSV Diff and Plagiarism Checker.
- [Free CSV Editor](/tools/csv-editor/) - This free, private CSV editor includes a CSV health report, deduplication, filtering, sorting, transformations, streaming mode for huge files and reusable cleaning templates.
- [Fuzzy Matching Tool](/tools/fuzzy-match/) - This free, private tool scores how similar two lists of names, emails or text are and flags near-duplicates.
- [CSV Diff](/tools/csv-diff/) - This free, private tool compares two CSV files by a key column and reports added, removed and changed rows.
- [Plagiarism Checker](/tools/plagiarism-checker/) - This free, private similarity checker compares two files or up to twenty documents and highlights verbatim and reworded passages.
- [Free CSV Editor Blog Post](/blog/free-csv-editor/) - This post introduces CSV Wrangler, a free CSV editor that runs entirely in your browser.
- [Fuzzy Matching Tool Blog Post](/blog/fuzzy-matching-tool/) - This post introduces the free fuzzy matching tool and explains how to use it to spot near-duplicates.
- [CSV Diff Tool Blog Post](/blog/csv-diff-tool/) - This post introduces the free CSV diff tool for comparing two CSV files.
## Blog and Insights
- [Blog Home](/blog/)
- [Sheets AI Assistant Guide](/blog/sheets-ai-assistant-guide/) - This complete guide covers Recommendation Mode and Execution Mode with its Multi-step workflow and Direct AI clean paths.
- [Automate Data Cleaning in Google Sheets](/blog/automate-data-cleaning-google-sheets/) - This guide covers automating common cleaning tasks in Google Sheets.
- [Automate Deduplication in Google Sheets](/blog/automate-deduplication-google-sheets/) - This guide shows efficient deduplication techniques for your spreadsheets.
- [CRM Data Cleaning](/blog/crm-data-cleaning/) - This guide shares strategies for cleaning CRM data.
- [Dirty Data Horror Stories: Spreadsheet Mistakes](/blog/dirty-data-horror-stories-spreadsheet-mistakes/) - This article collects real-world examples of spreadsheet errors caused by dirty data.
- [Entity Resolution and Data Reconciliation](/blog/entity-resolution-data-reconciliation-google-sheets/) - This guide covers matching and merging records across datasets.
- [Excel Fuzzy Lookup Alternative](/blog/excel-fuzzy-lookup-alternative/) - This article reviews the alternatives to Excel's fuzzy lookup.
- [Fuzzy Conditional Formatting Highlight Duplicates](/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 Matching for Mac Excel](/blog/fuzzy-matching-mac-excel/) - This guide covers performing fuzzy matching on Mac.
- [Google Sheets Soundex Function](/blog/google-sheets-soundex-function/) - This guide explains how Soundex works in Sheets and which alternatives exist.
- [Hidden Costs of Dirty Data](/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.
- [How to Schedule Data Cleaning in Google Sheets](/blog/how-to-schedule-data-cleaning-google-sheets/) - This guide covers setting data cleaning on autopilot.
- [Hybrid Fuzzy Embeddings in Sheets](/blog/hybrid-fuzzy-embeddings-sheets/) - This guide explores using hybrid fuzzy embeddings for matching.
- [OpenRefine Alternative for Data Cleaning](/blog/openrefine-alternative-data-cleaning/) - This article compares Flookup with OpenRefine.
- [OpenRefine vs Flookup Data Wrangler](/blog/openrefine-vs-flookup-data-wrangler/) - This head-to-head comparison covers profiling, dedup, enrichment and standardisation.
- [Pandas vs Flookup Data Wrangler](/blog/pandas-vs-flookup-data-wrangler/) - This article compares code-based pandas with the no-code Flookup approach.
- [Power Query vs Flookup Data Wrangler](/blog/power-query-vs-flookup-data-wrangler/) - This article compares spreadsheet data cleaning approaches.
- [Fuzzy Lookup for Excel vs Flookup Data Wrangler](/blog/fuzzy-lookup-for-excel-vs-flookup-data-wrangler/) - This article compares the alternatives to the Fuzzy Lookup add-in.
- [Ablebits Power Tools vs Flookup Data Wrangler](/blog/ablebits-power-tools-vs-flookup-data-wrangler/) - This article compares the Google Sheets add-ons for deduplication and cleaning.
- [Alteryx vs Flookup Data Wrangler](/blog/alteryx-vs-flookup-data-wrangler/) - This article compares an enterprise analytics platform with spreadsheet-native data preparation.
- [Wikibase Data Cleaning](/blog/wikibase-data-cleaning/) - This guide covers preparing spreadsheet data for Wikibase and QuickStatements imports.
- [AI Data Cleaning](/blog/ai-data-cleaning/) - This article explains what AI cleaning tools do and when to use them.
- [Fuzzy Matching in Google Sheets](/blog/fuzzy-matching-in-google-sheets/) - This guide covers comparing columns with fuzzy matching in Sheets.
- [Best Fuzzy Matching Software](/blog/best-fuzzy-matching-software/) - This article compares the 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.
- [Order-to-Shipping Reconciliation in Google Sheets](/blog/order-shipping-reconciliation-google-sheets/) - This guide covers matching orders against a shipping log and flagging unfulfilled orders.
- [Vendor Reconciliation in Google Sheets](/blog/vendor-reconciliation-google-sheets/) - This guide covers matching an accounts payable list against a master vendor table.
- [Fuzzy Name Matching](/blog/fuzzy-name-matching-guide/) - This guide covers matching customer and company names.
- [Fuzzy Address Matching](/blog/fuzzy-address-matching/) - This guide covers matching and deduplicating addresses.
- [Python Data Cleaning and Fuzzy Matching](/blog/python-data-cleaning-fuzzy-matching/) - This guide covers data cleaning with Python.
- [R Data Cleaning and Fuzzy Matching](/blog/r-data-cleaning-fuzzy-matching/) - This guide covers data cleaning with R.
- [VLOOKUP vs Flookup Data Wrangler](/blog/vlookup-vs-flookup-data-wrangler/) - This article compares VLOOKUP with fuzzy matching in Excel and Google Sheets.
- [XLOOKUP vs Flookup Data Wrangler](/blog/xlookup-vs-flookup-data-wrangler/) - This article compares XLOOKUP with fuzzy matching in Excel and Google Sheets.
- [How to Clean Data in Google Sheets with QUERY, REGEX and IMPORTRANGE](/blog/advanced-formulas-data-cleaning-query-regex-importrange/) - This guide collects copy paste QUERY, REGEXREPLACE and IMPORTRANGE recipes with VLOOKUP and XLOOKUP patterns.
- [How to Find Duplicates with Conditional Formatting and COUNTIF](/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.
- [How to Create Named Functions in Google Sheets for Reusable Cleaning Formulas](/blog/named-functions-google-sheets-reusable-cleaning-formulas/) - This guide shows how to package cleaning formulas as named functions with import steps.
- [Semantic Data Trust Layer for AI RAG](/blog/semantic-data-trust-layer-ai-rag/) - This article explains data trust for AI RAG pipelines.
- [Semantic Fuzzy Matching with Embeddings](/blog/semantic-fuzzy-matching-embeddings/) - This guide covers using embeddings for semantic matching.
- [SEO Site Migration with Google Sheets](/blog/seo-site-migration-google-sheets/) - This guide covers SEO migrations using Sheets.
- [Standardise Customer Names](/blog/standardise-customer-names-learn-from-examples/) - This guide explains how to standardise customer names with practical examples.
- [Standardise Phone Numbers](/blog/standardise-phone-numbers-learn-from-examples/) - This guide explains how to standardise phone numbers with practical examples.
- [Teach Product Code Standardisation](/blog/teach-product-code-standardisation-learn-from-examples/) - This guide explains how to standardise product codes with practical examples.
- [Tips for Cleaning Data in Google Sheets](/blog/tips-cleaning-data-google-sheets/) - This article shares best practices for data cleaning.
- [What is Data Cleaning?](/blog/what-is-data-cleaning/) - This article explains the fundamentals of data cleaning.
- [Data Quality Audit Checklist for Google Sheets](/blog/data-quality-audit-checklist-google-sheets/) - This article offers a practical checklist for evaluating data quality across six dimensions.
- [How to Prepare Clean Data for AI and RAG Pipelines](/blog/prepare-clean-data-ai-rag-pipelines-google-sheets/) - This guide provides a step-by-step workflow for preparing data for AI ingestion.
## 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.