Last updated 07-30-2026
Category:
Reviews:
Join thousands of AI enthusiasts in the World of AI!
goodlookup
goodlookup is a spreadsheet automation add-on for Google Sheets that adds a semantic lookup function for users who need to link messy text columns without writing fragile VLOOKUP rules. You install it from the Google Workspace Marketplace, activate it under Extensions, and call =GOODLOOKUP() inside a sheet to score how closely two strings relate in meaning, not just spelling.
Classic fuzzy matching stops at character distance, which breaks when one list says "Football" and another says "Soccer," or when a short nickname should map to a full person name. goodlookup uses a pre-trained model described on its site as combining GPT-3 style intuition with join-style matching, returning a score that reflects neighboring words in vector space. Longer exact matches rank higher, but related concepts can still surface as valid pairs.
The product targets analysts, ops teams, and researchers who cluster topics, reconcile CRM exports, or unify survey tags that were typed differently across sources. Pricing is a simple yearly subscription at $15, and the homepage walks through subscribe, install, and activate steps before you open the sample spreadsheet.
=GOODLOOKUP() custom function works inside Google Sheets like VLOOKUP or INDEX MATCH
Yearly subscription listed at $15 on the official goodlookup site
Scores matches using semantic relationships, synonyms, and cultural variants
Installs from the Google Workspace Marketplace as a Sheets add-on
Returns match scores so longer identical strings rank above weaker neighbors
Brings semantic matching into native Google Sheets formulas
Low $15 yearly price for solo analysts cleaning small datasets
Useful for synonym and cultural variant joins that VLOOKUP cannot catch
Sample spreadsheet and activation steps are documented on the homepage
Requires an active subscription before the add-on will work
Google Sheets only, with no standalone desktop app
Homepage is a simple Google Sites page with limited live product documentation
How much does goodlookup cost?
goodlookup costs $15 per year according to the pricing shown on goodlookup.com. You must subscribe before installing the Google Sheets add-on from the Workspace Marketplace.
Where does goodlookup run?
goodlookup runs as a Google Sheets add-on. After subscribing, you install it from the Google Workspace Marketplace and activate it under Extensions > Manage add-ons > goodlookup.
How is goodlookup different from VLOOKUP?
goodlookup compares meaning, not just exact text. It can relate strings like Ronaldo to Soccer or Football using semantic similarity scores, which standard VLOOKUP and basic fuzzy matchers miss.
What formula does goodlookup use?
goodlookup exposes a =GOODLOOKUP() function you enter directly in sheet cells. The homepage links to an example spreadsheet that shows how to call it after activation.
What problems does goodlookup solve?
goodlookup helps spreadsheet users link records when data lives in multiple tabs or files with different naming conventions. It is built for topic clustering and text-to-text joins that need semantic understanding.
Does goodlookup replace fuzzy matching?
No. goodlookup positions itself as another tool in a data ops stack rather than a full replacement for fuzzy matching. It adds semantic scoring on top of traditional join workflows.