Show HN: Google Sheets add-on to fuzzy lookup, highlight and remove duplicates 5 years ago, I created an add-on for Google Sheets called Flookup Data Wrangler for lightweight data cleaning inside the Google Sheets environment. It features both a menu function and a spreadsheet function component. Flookup can be used to: 1. Lookup and match data regardless of text-based differences. 2. Highlight and delete duplicates even if the dataset has mismatched text. 3. Calculate the percentage similarity between text entries. 4. Extract unique values from any column based on percentage similarity. 5. Remove stop words based on text similarity and strip punctuations from strings as well. Because of its versatility, Flookup can be used to return the best match, the next best match, etc. until the minimum percentage similarity is reached. This feature avoids weaknesses other fuzzy matching algorithms have because it safely hands power to you, the user, and I believe the user is the best judge of which data is a match or not. One other great feature Flookup has is that it can be used to combine lookup values. This is particularly helpful when your dataset has many similar strings, and you want to include extra information to your lookup value in order to increase the specificity of your query. In case you are interested in finding out more, head over to our official website at https://ift.tt/mi9hn87 March 4, 2024 at 12:45PM
Show HN: Google Sheets add-on to fuzzy lookup, highlight and remove duplicates https://ift.tt/ZgoSDs3
Related Articles
Show HN: I built this website about Sikh History and don't know how code works https://ift.tt/ZeSGQudShow HN: I built this website about Sikh History and don't know how co… Read More
Show HN: Ephemeral VMs in 1 Microsecond https://ift.tt/W4dvQCmShow HN: Ephemeral VMs in 1 Microsecond https://ift.tt/XfB7Mbk Decembe… Read More
Show HN: Get e-signatures & pay per signed doc https://ift.tt/SpKLDqfShow HN: Get e-signatures & pay per signed doc Woke up today with … Read More
Show HN: Web worker and polling exp / HN client app https://ift.tt/wCxpByeShow HN: Web worker and polling exp / HN client app demo and src insid… Read More
Show HN: Simple SEC Discord Bot https://ift.tt/xZXg9BMShow HN: Simple SEC Discord Bot I built a Discord bot that monitors SE… Read More
Show HN: Rivet Actors – Durable Objects build with Rust, FoundationDB, Isolates https://ift.tt/fHQEMF0Show HN: Rivet Actors – Durable Objects build with Rust, FoundationDB,… Read More
Show HN: Skybear.net – A managed platform automating Synthetic HTTP API testing https://ift.tt/DwcflMHShow HN: Skybear.net – A managed platform automating Synthetic HTTP AP… Read More
Show HN: Otto-m8 – A low code AI/ML API deployment Platform https://ift.tt/PmQSgv9Show HN: Otto-m8 – A low code AI/ML API deployment Platform Hi all, so… Read More
0 Comments: