Google Sheets add-on to compare text, fuzzy-match, highlight duplicates
I created an add-on for Google Sheets called Flookup, and it comes both as a free version and a VERY AFFORDABLE paid version. At its core, Flookup is a fuzzy matching add-on that helps you manage text that is less than a 100% match. Beyond that it can be used to: 1. Search for and match data regardless of whether it contains typos. 2. Highlight and delete duplicates duplicates even if the data has mismatched text. 3. Calculate the percentage similarity between strings. 4. Extract unique values from any column based on percentage similarity. 5. Sum and find the average of numbers based on…
What it does
In the maker’s words, at launch
I created an add-on for Google Sheets called Flookup, and it comes both as a free version and a VERY AFFORDABLE paid version. At its core, Flookup is a fuzzy matching add-on that helps you manage text that is less than a 100% match. Beyond that it can be used to: 1. Search for and match data regardless of whether it contains typos. 2. Highlight and delete duplicates duplicates even if the data has mismatched text. 3. Calculate the percentage similarity between strings. 4. Extract unique values from any column based on percentage similarity. 5. Sum and find the average of numbers based on corresponding partial matches. 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 the user, and I believe the user is the best judge of which data is a match or not. Another great feature Flookup has is that it can be used to combine lookup values. This is particularly helpful when your data has many similar strings and you want to add extra information to your lookup value in order to increase the specificity of your query. Finally, Flookup is good for more than just fuzzy matching; it is the improved replacement for VLOOKUP and INDEX/MATCH that you have been looking for. Find out more by heading to https://www.getflookup.com, Subscription information is available at https://www.getflookup.com/pricing
Does the same job
all alternatives →- FDFlookup – Data cleaning by fuzzy matching2022 · ▲8
Hello HN! It has been about three years since I launched this current iteration of my Google Sheets add-on called Flookup. I'm a solo developer and, currently, I handle absolutely everything to do with Flookup from writing code, replying support emails and even marketing. It is a lot of work but very satisfying because I get to see, first hand, how helpful it has been to my userbase. Before Flookup was launched, there was only one prominent Google Sheets add-on that could be used for data cleaning (to a certain degree) but, luckily for me, that add-on had left a gap in functionality that I…
- WSWeb Scraping in Google Sheets2018 · link.fish · ▲153
- XSX-spreadsheet – A JavaScript canvas spreadsheet for web2019 · github.com · ▲347
More life & fun this month
the category →- TL
Life & fun · 10d ago · louisabraham.github.io
Photosynthesis fires two of your iPhone
Life & fun · 28d ago · photosynthesis.camera
SoloUno▲310Take control of hair pulling, nail biting & skin picking
Life & fun · 28d ago · solouno.io
Scroll through all 43,252,003,274,489,856,000 reachable Rubik's Cube permutations.
Life & fun · 26d ago · everycube.alen.is
Hi HN, I built Eigendrum, a web tool that solves the 2D wave equation for arbitrary shapes so you can hear what they sound like as drums. How it works: * Solves -∇²u = λu using finite element analysis (Kφ = λMφ) on a triangle mesh. * Validated to <0.1% error against closed-form solutions for circles (Bessel zeros) and rectangles. * Sound model factors in strike location, Rayleigh damping, and mallet width. * Includes Kac drums I & II to demonstrate identical sound spectra from different geometries. * No frameworks, build steps, or dependencies. Repo and tests:…
Life & fun · 27d ago · baselashraf81.github.io
Launched alongside, January 2020
the whole month →
MicroAcquire▲1,553A free & anonymous startup acquisition marketplace
Commerce · 2020 · microacquire.com
YourStack▲1,251A new community for sharing the products you use and ❤️
Life & fun · 2020 · yourstack.com
The ultimate resource for starting profitable side projects
Growth · 2020 · indiehackers.com
- IW
Hey folks. Last year I was fortunate enough to sign a deal to write a book with my favorite technical publisher, The Pragmatic Bookshelf. When I started out as an Engineering Manager many years ago, I found that there wasn't a huge amount of material that specifically and practically helped me understand how to do my job. When you learn to program there's all of these amazing tutorials, examples and guides, but what was there for new managers? In response to this, a couple of years ago I started a blog over at https://www.theengineeringmanager.com which got a decent amount of…
Work · 2020
