p/flookup Fuzzy match, highlight and remove duplicates.

Start new thread

Flookup - Fuzzy match, highlight and remove duplicates from your data

Andrew Apell

Flookup Data Wrangler

•

6yr ago

Flookup is a Google Sheets add-on that relies on fuzzy matching to do any of the following data cleaning tasks:
1. Remove duplicates.
2. Highlight duplicates.
3. Match or merge data.
4. Calculate the percentage similarity between strings.

Replies

Best

Kurosh Hashemi

RoadGoat

Hey guys, sounds cool but I'm getting an error when trying to sign in. Google says temporarily disabled

Report

5yr ago

Andrew Apell

Flookup Data Wrangler

Maker

@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.

Report

5yr ago

Alex Conway

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!

Report

5yr ago

Andrew Apell

Flookup Data Wrangler

Maker

@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.

Report

5yr ago

Andrew Apell

Flookup Data Wrangler

Maker

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

Report

6yr ago