Goodlookup

Goodlookup is a smart spreadsheet function for people who live in Google Sheets and constantly fight messy data. It is a pre-trained model that combines the intuition of a large language model with the join capabilities of fuzzy matching, used like VLOOKUP or INDEX/MATCH to speed up topic clustering and record linking directly in your sheet.

The problem it solves is an old one for spreadsheet users: data lives in multiple places without uniform naming conventions, making it hard to get a clean, unified view. Traditional fuzzy matching only compares the strings themselves and ignores similarities outside of them, so it misses cases where two records clearly refer to the same thing. Goodlookup addresses this by getting close to semantic understanding — it can match 'Ronaldo' to 'Ronaldo Luís Nazário de Lima', and it can also recognize looser relationships like 'Ronaldo' to 'Soccer' or 'Football'.

The tool does not try to replace fuzzy matching; it adds a new option to your data-ops toolkit. Pricing is straightforward: a yearly subscription of US $15 per year. To use it you subscribe, install the add-on from the Google Workspace Marketplace, and activate the function via the sheet menu under Extensions > Manage add-ons. A match score next to each result indicates how strongly neighboring words sit in vector space, with longer, identically matching strings scoring highest.