Show HN: Google Sheets add-on to fuzzy lookup, highlight and remove duplicates https://ift.tt/HBxtIuf

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/Rlxo8BU March 4, 2024 at 08:15AM