🟢 KEY FEATURES
- Fuzzy Lookup and Match: Find the best match using percentage similarity or sound similarity. Return the matched value, its similarity score or the full row. Adjustable threshold from 0 to 1 with control over which occurrence to keep.
- Deduplicate with Confidence: Remove duplicates based on similarity, not just exact matches. Keep the first or last occurrence, roll up and combine rows and review scores before you apply changes. Handles spelling variations and formatting inconsistencies that the native Remove Duplicates tool misses.
- Merge Sheets Vertically and Horizontally: Reconcile two tables even when keys do not align exactly. Merge vertically by looking up values in a table column or match consistently across rows for horizontal structures. Ideal for combining CRM exports, vendor lists and survey data.
- Standardise and Normalise Text: Trim excess whitespace, fix inconsistent capitalisation, strip diacritics, remove punctuation and filter stop words. Create consistent keys for accurate matching and analysis.
- Find Unique Values: Extract distinct values from any range despite spelling and formatting variations. Quickly build clean reference lists and master keys.
- Similarity Scoring: Compare any two columns and calculate exact percentage similarity for every row pair. Use scores to flag near duplicates, measure data quality and prioritise manual review.
- Automate with Scheduling: Schedule any data cleaning function to run every 15 minutes, hourly or daily. Auto chaining handles large datasets across execution windows without manual intervention.
- Sheets AI Assistant: Describe what you need in plain English and get custom formulas, step by step workflows and expert cleaning tips instantly. Generate complex solutions without learning formula syntax.

🟢 WHO USES IT?
- Email and CRM teams who clean mailing lists, fix names and addresses, remove invalid entries and keep customer databases accurate.
- Operations and data teams who consolidate duplicate user lists, unify vendor and product catalogues and link records across totally separate sources.
- Marketing and SEO teams who map 404 redirects for site migrations, analyse URL and title differences to find keyword gaps and build internal linking between topic clusters.
- Analysts who profile columns to detect issues before analysis and prepare clean data for reporting and AI pipelines.
- Small businesses that need enterprise grade matching on Windows, macOS and Linux without leaving Google Sheets™.

🟢 WHY CHOOSE FLOOKUP?
Native Google Sheets™ functions like UNIQUE and VLOOKUP can only process exact data points, with basic sorting and filtering on offer.
Flookup, on the other hand, handles the nuanced cases that matter in real-world data. It recognises spelling variations, partial matches, extra spaces and misaligned punctuation marks.
Its proprietary algorithm is fast and accurate on large ranges and is trusted for professional work.

🟢 HOW IT WORKS
1. Install from the Marketplace and then launch it by heading to Extensions > Flookup Data Wrangler.
2. Select your data range, choose a function such as Deduplicate or Fuzzy Match and set the similarity threshold and options.
3. Review the similarity scores in the preview and apply. Results write directly to your chosen location in the spreadsheet.

🟢 PRICING PLANS
Head to https://www.getflookup.com/get-started to learn how to get started, view the free interactive demo at https://www.getflookup.com/demo and see all current options at https://www.getflookup.com/pricing.

🟢 SUPPORT AND TRUST
Verified by Google with over eight years of a clean security record. Your data stays in your sheet at all times. Only default Google usage metrics are collected, and our team never accesses your spreadsheet data.

- Support at https://www.getflookup.com/contact-us
- Terms at https://www.getflookup.com/terms
- Privacy at https://www.getflookup.com/privacy-policy