llms.txt
Compare with other sites' llms.txt files →# 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.
- [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.
- [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 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, with pause, resume, run now, edit and clear controls in the sidebar.
- [Data Connectors](/documentation/connectors/) - Pull Airtable, SQL or Salesforce records into a staging sheet, clean them with Flookup and write changed rows back. Included with the Extended Pass and the Team Pass.
- [Airtable Connector](/documentation/connectors/airtable/) - Connect an Airtable base with a personal access token, pull records with record ids, and write changed fields back without deleting anything.
- [SQL Database Connector](/documentation/connectors/sql/) - Connect PostgreSQL, MySQL, SQL Server or Oracle through a read-only query and write changes back through a key column.
- [Salesforce Connector](/documentation/connectors/salesforce/) - Connect a Salesforce org with OAuth through a Connected App, choose objects and fields, run SOQL and pull records into the staging sheet. Read only.
## Pricing
- [Pricing Plans](/pricing/) - The free tier starts at install plus a 7-day trial that opens the menu tools, then a $15 Essential Pass, a $150 Extended Pass or a $399 Team Pass for five accounts with nothing renewing. Nothing is charged during the trial.
## Blog and Insights
- [Blog Home](/blog/)
- [AI Assistant Case Study for Google Sheets](/blog/ai-assistant-case-study-google-sheets/) - This case study covers asking the Sheets AI Assistant for the formula behind a renewal report, following up inside the same session and running a monthly clean in Execution Mode.
- [Data Connectors Case Study for Google Sheets](/blog/data-connectors-case-study-google-sheets/) - This case study covers pulling Airtable, SQL and Salesforce rows into staging sheets, reconciling the three sources and writing the reviewed rows back after a preview.
- [Workflow Templates Case Study for Google Sheets](/blog/workflow-templates-case-study-google-sheets/) - This case study covers running the vendor, order shipping, user list and Wikidata templates on one retailer's recurring jobs, with thresholds, review sheets and the formula assistant for everything in between.
- [Sync Airtable to Google Sheets Without Duplicate Rows](/blog/airtable-google-sheets-sync-duplicates/) - This guide covers pulling an Airtable table into a staging sheet, cleaning it there and writing back only the cells that changed after a preview.
- [Import SQL Query Results Into Google Sheets Without a CSV](/blog/sql-query-google-sheets-without-csv/) - This guide covers running one read only JDBC query from the sidebar, reconciling the result and writing changed rows back inside a single transaction.
- [Connect Salesforce to Google Sheets Without an Export](/blog/salesforce-to-google-sheets/) - This guide covers the Connected App, OAuth, the object and field picker, a SOQL query and the staging sheet, then the cleaning pass before the data reaches a report.
- [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 Add-in Alternative for Windows and Mac](/blog/excel-fuzzy-lookup-alternative/) - This article reviews the alternatives to Excel's fuzzy lookup, including an interactive threshold comparison, the head-to-head on platform 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 Matching in Excel for Mac](/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 everyday 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 run Standard Data Cleaning from the sidebar to standardise, match and dedupe with no formulas.
- [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 merging the reviewed groups in Salesforce.
- [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.