I created a Google Sheets add‑on 5+ years ago and it is still #1 for data cleaning

I’m Andrew, creator of Flookup Data Wrangler, a lightweight yet powerful Google Sheets add‑on built in 2019 that is consistently rated #1 for data cleaning.

What Flookup does

Flookup enables smarter data cleaning without leaving Sheets:

• Fuzzy lookup and merge by percentage similarity, sound similarity or semantic (meaning‑based) matching

• Strip punctuation, diacritics and stop words before matching

• Highlight or remove near‑duplicates, even with typos or inconsistent formatting

• Calculate similarity scores between any two text entries based on percentage or find their semantic meaning using AI

• Extract unique values based on threshold similarity levels

• Combine lookup values to increase specificity when data contains similar strings
  

New enhancements

I recently added semantic fuzzy matching (meaning‑based text comparison powered by AI) and launched a REST API for automation and integration. You can now automate data cleansing tasks, schedule jobs or embed Flookup functions in other applications.

Why it works

Flookup gives users control over match logic: choose percentage thresholds, sound vs semantic, best match or next matches and scale to thousands of rows with enterprise‑grade performance. Thousands of businesses trust Flookup daily.

Use cases

• Cleaning email lists before sending marketing campaigns

• Reconciling CRM records or product catalogues

• Extracting address data and normalising formats

• Mapping redirects or internal linking via topic clusters

---

Head over to getflookup.com if you’d like to explore more, try the free plan or integrate via API.

Let me know if you’d like to share feedback.