Flookup

Fuzzy Matching Functions for Google Sheets

Flookup is a suite of functions for data cleaning inside Google Sheets by using fuzzy match and fuzzy lookup techniques. It can be used to lookup tables, compare text and merge data based on percentage or sound similarity.

discussion
Would you recommend this product?
2 Reviews5.0/5
Andrew Apell
Maker
Creator of Flookup for Google Sheets
Hello fellow hunters and thank you for taking interest in Flookup. Flookup was born out of necessity. We were working on a project that required matching thousands of rows of data to thousands of rows of more data. Since most of this data was "dirty", it usually took about week to manually work through it. After trying many different solutions, we settled on developing the initial (private) version of Flookup and our task time was immediately cut down to about 30 minutes. We drew inspiration from several implementations available online and reinforced its core with lessons learned from using different fuzzy matching algorithms. Today, Flookup is a freemium add-on for Google Sheets and many of my users report that it has indeed improved their productivity. Take time to add it to your software stack; I'm sure you'll find it worthwhile. You can find out all about Flookup by visiting https://www.getflookup.com
Upvote (3)
ShareReport
Andrew Apell
Maker
Creator of Flookup for Google Sheets

It can be used to perform vertical lookups on any column and horizontal lookups on any row, based on percentage or sound similarity. It can also be used to highlight or delete duplicate values by sound or percentage similarity.

Pros:

Flookup makes working with unsorted, uncleaned or even clean data much easier

Cons:

It doesn't work offline

Upvote (1)
ShareReport
Kurosh HashemiFounder of RoadGoat - Map Your Travels
Hey guys, sounds cool but I'm getting an error when trying to sign in. Google says temporarily disabled
Upvote
ShareReport
Andrew Apell
Maker
Creator of Flookup for Google Sheets
@kurosh_hashemi Apologies for that. The error appeared because of Google's security review process, but it is now complete and Flookup back online. Please try to run the installation again. Thank you.
Upvote (1)
ShareReport
Alex Conway 🇿🇦
Machine Learning Nerd
This is super cool - I once had to hack together a Levenshtein distance function in VBA to use in Excel so it's rad to have this in Google Sheets - great work Andrew!
Upvote
ShareReport
Andrew Apell
Maker
Creator of Flookup for Google Sheets
@alxcnwy Thanks for the encouraging words Alex... very kind of you! I have also used Levenshtein distance in the past (as I said in my story). I was fascinated by the way it matched words that didn't look the same; something I had not seen or known before that time. It played a huge role in bringing Flookup to where it is today.
Upvote
ShareReport