Pay Once and Forget
Start free with exact matching or upgrade for full fuzzy matching and automation. No recurring charges, no surprises.
Match exact values and catch typos
- Exact matching for duplicates and typos
- Catches variations like "Jonh" to "John"
- Remove diacritics, punctuation and standardize URLs
- 30-second execution timeout
- No credit card required to use
Full fuzzy matching and automation
- Fuzzy matching for datasets with multiple spelling variations
- Full NORMALIZE, SOUNDMATCH and all functions
- Custom data cleaning ideas powered by AI
- Schedule automated cleaning tasks
- 100,000 credits for menu functions
For teams and power users
- Everything in Data Nova included
- Priority email support
- Domain-verified activation
- Ideal for teams and enterprise use
- 850,000 credits per month for large datasets
- 850,000 credits for menu functions
What You Can Do
Type formulas directly into any Google Sheets cell. No menus, no sidebars, just clean data.
=FLOOKUP(A2, B2:B500, C2:C500)
Fuzzy match "Acme Corp" against your vendor list and return the matching ID, even with typos and spelling variations.
=NORMALIZE(A2:A100, "domain")
Extract clean domain names from messy URL columns. Also removes diacritics, punctuation and stop words.
=DEDUPE(A2:A1000, 0.85)
Return a deduplicated array removing entries that are at least 85 per cent similar, non-destructive, keeps your original data intact.
=ULIST(A2:A500, "sound")
Extract unique values from a list using phonetic (Soundex) matching, catches "Smith" and "Smyth" as the same entry.
Frequently Asked Questions
What is included?
The free plan includes custom functions with similarity matching and basic normalization. Results below 0.9 require an upgrade to view. Data Nova adds full fuzzy matching, NORMALIZE stop-words removal, SOUNDMATCH, scheduled tasks and Spreadsheet solver. Includes 100,000 credits per month or 1,200,000 credits per year for Schedule functions and Spreadsheet solver. Covers one user with email support.
How much data can I process?
There are no daily caps or data limits. Custom functions have a 30-second execution timeout, making them ideal for smaller datasets. For larger datasets, use Schedule functions which have a 6-minute timeout and can process data in batches automatically.
Does Flookup train on my spreadsheet data?
No. Your spreadsheet data is processed in real-time solely to execute your data cleaning requests. We never store, share or use your data to train any models, keeping your proprietary information completely secure and private.
Do I need to manage my billing?
No. There are no recurring charges. You make a one-time payment for either monthly or yearly access. There are no credits to track or manage. Everything is unlimited for the duration of your chosen period.
Is my spreadsheet data secure?
We only store the minimum information required to manage your licence. We never view, share or monitor your spreadsheet data. Anything you share with us for support is promptly deleted after the task is complete.
We do not track usage, except the function execution metrics supplied by Google.
We have also been vetted by the Reviews Team at Google for security and compliance.
What permissions are requested?
Flookup requests permissions to connect to external services like our database for licence verification, see your public personal information and manage your Google Drive spreadsheet.
These permissions can be reviewed in the Google Workspace Marketplace listing and will be presented during the installation process.
Have more questions? Contact us via our dedicated support page.