SheetSense

Categorize spreadsheet rows with AI

Sorting hundreds of free-text rows into categories by hand is slow, and a formula full of SEARCH calls breaks on every new wording. SheetSense reads the whole column and tags each row with a category, using either a list you provide or a list it infers from the values.

The AI works through the column in batches of 100 rows, and you see the results in a before and after preview. Nothing is written to the sheet until you click Apply, and the last apply can be undone.

Worked example: expense descriptions

Column Description holds text such as UBER *TRIP 4F2 and AWS EMEA 03/2026. Your category list: Travel, Software, Meals, Office, Other.

New column Category
Description          Category
UBER *TRIP 4F2       Travel
AWS EMEA 03/2026     Software
Blue Bottle Coffee   Meals

Giving a closed list keeps the labels consistent, and including an Other category gives unclear rows somewhere to go. Check the Other rows and a sample of the rest in the preview, because an AI tag is a judgment call that you should confirm on rows that matter.

How it works

  1. 01Upload a CSV or Excel file, or open the sample sheet.
  2. 02Select the column to categorize and choose the categorize action.
  3. 03Enter your categories, or leave the list empty to have them inferred.
  4. 04Review the preview, adjust the list if needed, then click Apply.

Common questions

Can I use my own category names?
Yes. Type them in as a list and every row is assigned to one of them. Otherwise the tool proposes a list from the data.
How accurate is it?
It depends on how clear the text is. There is no accuracy figure to quote, so use the preview to check a sample before applying.
What does it cost?
A free account includes 10 AI actions. After that, Pro is $19 a month or Lifetime is $149 once.

Try it on your own formula

The Formula Translator is free for 5 formulas a day, with no account.