Flookup Data Wrangler is a Google Sheets add-on for cleaning data efficiently. It uses fuzzy matching to merge data, highlight duplicates, and remove unwanted words. It ensures data privacy, works across platforms, and provides backup and restore functions. It's cost-effective and suitable for tasks like reconciliation and data entry simplification.
Features
Built-in Privacy
Flookup runs as a Google Apps Script, ensuring that it processes entirely on your end, keeping your data secure and inaccessible by third parties.
Speed and Efficiency
Utilizes optimized fuzzy matching algorithms to complete repetitive and cleaning tasks quickly and effectively, minimizing the time required for data cleaning.
Platform Independence
Can be used on any platform capable of running Google Sheets, including Windows, Mac, and Linux, making it universally accessible.
Reliability and Stability
Developed with thorough testing and evaluation to ensure stable cleaning solutions, with features regularly updated and enhanced by AI innovations.
Backup and Restore
Operations can be reversed through Google Sheet's version history feature, ensuring that any changes can always be undone and data can be restored.
Cost-effective Data Cleaning
Offers essential data cleaning functions at a significantly lower price point compared to other industry solutions.
Match and Merge Data
Automatically match and merge data once every 24 hours for plans above the Free Plan. Ensures unique data consistency across datasets.
Remove Duplicates
Effortlessly remove duplicate entries from datasets once every 24 hours to maintain data accuracy.
Extract Unique Values
Extracts unique values once every 48 hours to aid in data differentiation and analysis.
Highlight Duplicate Entries
Highlights duplicate entries once every 24 hours to identify and manage redundant data.
Evaluate Text Similarities
Automatically evaluates text similarities between rows to ensure data uniformity.
Preprocess Data for Cleaning
Preprocesses data once every 24 hours to prepare datasets for analysis and cleaning.
BONUS: Data Cleaning using Artificial Intelligence
Advanced data cleaning utilizing AI to improve accuracy and efficiency, available in certain plans.
BONUS: Data Cleaning using Automation
Utilizes automated processes for thorough and efficient data cleaning workflows.
BONUS: Data Cleaning with Custom Functions
Allows for data cleaning using custom functions for tailored cleaning processes.
Built-in Privacy
Flookup runs via a secured Apps Script and processes everything locally without sharing your data. This ensures that your data remains secure and inaccessible to others, providing peace of mind for users concerned about privacy.
Speed and Efficiency
Utilizes optimized fuzzy matching algorithms to clean data quickly and efficiently, minimizing the time necessary for data cleaning tasks.
Platform Independence
Works on any platform including Windows, Mac, and Linux, making it a versatile tool for various data cleaning needs.
Reliability and Stability
Employs fuzzy matching algorithms refined over time for stability in cleaning datasets. This ensures robust and consistent data reconciliation.
Backup and Restore
Allows users to undo or restore spreadsheet data using the built-in 'Undo' button or version history, ensuring that no changes are irreversible.
Cost-effective Data Cleaning
Offers essential data cleaning functions at a significantly lower price compared to industry alternatives, making it an affordable option for users.
Custom Functions
Exclusive to the paid plan, this allows users to create tailor-made functions for their specific needs.
Function Scheduling
Available only in the paid plan, it enables users to schedule functions to run automatically at specified times.
Extended Timeout Limit
With the paid plan, users get an extended timeout of 360 seconds for running functions, compared to the 10-second limit in the free plan.
NORMALIZE
Removes unwanted words, diacritics, and punctuation marks from text entries to improve the data cleaning process and the accuracy of fuzzy matching.
FUZZYMATCH
Calculates the percentage similarity between text entries and returns the result in decimal form, which helps in comparing and matching strings or data ranges.
FLOOKUP
Searches any column of a range of cells and returns a value from a specified column of that range, paired with its respective percentage similarity.
QLOOKUP
A variant of FLOOKUP that returns the lookup result without the relative percentage similarity. It includes an optional parameter to specify the algorithm used for matching.
HFLOOKUP
Handles horizontally oriented datasets by matching without the relative percentage similarity, similar to a transposed FLOOKUP.
SOUNDMATCH
Looks up values in any column and returns values based on a refined version of the Soundex algorithm.
ULIST
Returns unique values from any list of text entries based on their relative percentage or sound similarities, functioning similarly to the UNIQUE function in Google Sheets.