Classify rows in an Excel file with AI, without an add-in or a formula
Upload the .xlsx workbook, describe the classes, and get the same workbook back with a new column after the last used one, filled for every row. Nothing is installed in Excel and no formula is dragged down 10,000 rows. Formulas, formatting and the other sheets are left as they were, and the first rows are free to check before you pay $5 for the whole sheet.
- Works on .xlsx files; the first sheet with a header row is processed
- New columns go after the last used column, so existing formulas keep pointing at the right cells
- Formula results are read as values; the formulas themselves are not changed
- Up to six new columns, for example Class and Reason
- Up to 20,000 rows for $5, paid once
How to classify Excel rows
-
1
Save as .xlsx and upload
Old .xls files and Google Sheets need to be saved or downloaded as .xlsx or .csv first. Put the sheet to classify first if the workbook has several.
-
2
Name the classes
Paste the allowed values, one per line, and add a one-line instruction. The first rows are classified on screen, free.
-
3
Download the workbook
Unlock the whole sheet for $5 and open the downloaded workbook: the new column sits after your last column.
What happens to the workbook
Only the processed sheet changes, and only by gaining cells at the end of each row. The tool writes those cells into the sheet's existing XML, so styles, merged cells, charts, defined names and the other sheets stay as they were. New columns are added after the last used column rather than next to the source column, because inserting a column in the middle would shift every formula that refers to the cells to its right.
Cells that hold a formula are read through their saved result, so a column of =A2&" "&B2 still gives the model the joined text.
Compared with an AI formula or add-in
Spreadsheet AI functions run once per cell and recalculate when the workbook changes, which can mean waiting, repeated runs and a result that shifts when you reopen the file. Here the classes are written as plain values, once, and the file is yours. If you need to rerun with a better instruction, upload the original again.
How the tool works, what it costs and how your files are handled is on the AI for Every Row page; prices for every tool are on the pricing page.
Last updated
Questions and answers
Can ChatGPT classify the rows of my Excel file?
It can work with an uploaded file for a few hundred rows, often by writing code. On larger sheets it tends to stop partway or fall back on keyword rules, and it returns a new file rather than your workbook. This tool adds the classes to your own workbook, row by row.
Do I need to install anything?
No. Upload the .xlsx file in the browser and download the result. Nothing is added to Excel.
Which sheet is classified?
The first sheet that has a header row and data under it. Move the sheet to the front if you need another one.
Will my formulas break?
No. Existing cells are not rewritten, and the new columns are added after the last used column so no reference shifts.
What does it cost?
Files of up to 100 rows are free in full. Bigger sheets are $5 for up to 20,000 rows, or Unlimited at $19 a week for up to 100,000 rows.