Summarize a spreadsheet by category and month, with totals
314 spending rows turned into a category-by-month table, every total to the penny.
A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 57 s in real time.
The short answer.
A PivotTable does it: Insert, PivotTable, Category in Rows, Date in Columns grouped by month, Amount in Values as Sum. It goes wrong on messy data: “groceries” and “Groceries ” become separate rows, and amounts typed as “£12.50” are silently left out. Clean those first. Stella (stella.sh) merges the category spellings, counts text amounts, and saves a summary with totals per category, per month and for the year.
Stella does this on Windows, Mac and Linux.
What happened.
A summary in about 3 minutes. Checked afterwards against an answer key written before the run: all 80 category-by-month totals correct to the penny, exactly the 8 real categories, the year's total (£21,695.61) and a total per category shown, and the original data still there.
The household and its spending are fictitious, made for this run. The work is sped up 11×.
How Stella does it.
- Finds the spending spreadsheet in Documents: 314 rows from January to 28 October
- Merges 22 spellings of categories (capitals, stray spaces) into the 8 real ones
- Counts 8 amounts typed as text with a £ sign, which a PivotTable would skip, and takes refunds off the month and category they're in
- Saves “Spending summary 2026.xlsx” next to the original with a category-by-month grid, category totals, month totals and the year total
- Sums it up in plain words (biggest categories, dearest month) and flags a possible double broadband charge and some very low bills
The prompt.
My spending spreadsheet for this year is in Documents. Make me a summary of how much I spent in each category in each month, with totals.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
Clean the categories
Add a column with
=PROPER(TRIM(C2))and fill down: it removes stray spaces and fixes capitals, so “groceries” and “Groceries ” become one. Use this column instead of the original in the PivotTable.Make every amount a number
Amounts typed with a £ sign or as text are left-aligned. Add
=VALUE(SUBSTITUTE(D2,"£",""))and fill down, or select the column and use Data, Text to Columns, Finish. Check the column's SUM matches what you expect.Insert the PivotTable
Select the data, Insert, PivotTable, New Worksheet. Drag the clean category to Rows, Date to Columns, the clean amount to Values (it should say Sum of). Excel groups dates by month; if not, right-click a date, Group, Months.
Add totals
PivotTables show row and column grand totals by default (Design, Grand Totals). Format the values as currency with Ctrl+1.
Without a PivotTable
Type the categories down the side and months across the top, then use
=SUMIFS(Amount, Category, $A2, Date, ">="&B$1, Date, "<"&EDATE(B$1,1))with the first of each month in row 1.
Where it stops.
- Stella summarises the categories in your sheet. It can suggest new ones but won't invent them.
- Refunds reduce the category in the month they happened, so a month can show a negative total (Fun was −£32 in October here).
- The spending data goes to the AI model you use in Stella. The summary is built on your computer.
- Recorded on Linux with a free Python library; the summary is an ordinary .xlsx for Excel, Numbers or Google Sheets.
Questions.
Why does my PivotTable show the same category twice?
The two aren't identical: a trailing space or different capitals. Clean the column with TRIM and PROPER first.
Why is my PivotTable total too low?
Some amounts are text, which Sum skips. Convert them to numbers. Stella counted 8 such amounts here.
Can I get a chart too?
Yes: in Excel, select the PivotTable and Insert, PivotChart. Or ask Stella for a chart sheet in the same file.
My data is still in bank PDFs. Where do I start?
Get it into a sheet first: bank statement PDFs to Excel or receipts to a spreadsheet. Then find your subscriptions.
Is Stella free for this?
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.
Can I control what Stella changes on my computer?
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.
Checked against these sources on 13 November 2026.