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.
Description Category
UBER *TRIP 4F2 Travel
AWS EMEA 03/2026 Software
Blue Bottle Coffee MealsGiving 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
- 01Upload a CSV or Excel file, or open the sample sheet.
- 02Select the column to categorize and choose the categorize action.
- 03Enter your categories, or leave the list empty to have them inferred.
- 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.