Expense Tracker in Excel: Build It in 10 Minutes
Excel remains the most powerful place to run a personal budget — offline, private and permanent. Here is the ten-minute build with the two features that matter, and where Excel beats Sheets (and loses).
The build
One tab per month, headers in row one: date, amount, category, note — amount formatted as currency. Give the category column Data → Data Validation → List pointing at an eight-to-twelve-item category range on a settings tab; the dropdown is what keeps totals meaningful. Total the month with =SUM(B2:B500) and each category with =SUMIF(C:C,"housing",B:B). Finally, format the range as a Table (Ctrl+T) so formulas extend themselves as rows are added.
The two features worth using
First, PivotTables: select the table, Insert → PivotTable, drag category to rows and amount to values — a full spending breakdown in ten seconds, refreshed after every session. Second, conditional formatting that highlights the ten largest amounts makes the big spends jump out during review. Resist charts, dashboards and macros for the first quarter — they are the reason Excel budgets get abandoned: maintenance grows while insight does not.
Excel vs Google Sheets
Excel wins offline: full function on a plane, in a dead zone, on a machine with no browser login — and the file stays on your disk, which many people rightly prefer for financial data. Its pivot tables remain stronger than Sheets’ equivalents. Sheets wins on sharing (a couples budget lives in one URL, not an emailed file) and on quick phone edits. Solo and privacy-minded leans Excel; shared money leans Sheets — and the four-column data moves between them without loss either way.
Keep the exit door open
Whatever you build, keep the skeleton — date, amount, category, note — because it is the common language: the free web tracker here exports and imports exactly that CSV, so a year of Excel rows becomes tracker history in one import, and vice versa. Tools should stay replaceable; the data format is what makes that true. The method around the numbers is the same one in budgeting for beginners.
| Job | What to type | What it does |
|---|---|---|
| Month total | =SUM(B2:B500) | adds every amount in the column |
| One category total | =SUMIF(C:C,"food",B:B) | adds amounts only where category is food |
| All categories at once | PivotTable: category → rows, amount → values | full breakdown, refreshed in one click |
| Self-extending ranges | Ctrl+T (format as Table) | formulas and pivots grow as rows are added |
| Clean categories | Data → Data Validation → List | dropdown kills free-text drift |
Frequently asked questions
Excel or Google Sheets for expenses?
Excel for offline power and local files; Sheets for sharing and phone edits. The four-column format works in both, so switching is free.
How do I total one category in Excel?
SUMIF: =SUMIF(C:C,"food",B:B) adds every amount whose category is food. A PivotTable does all categories at once.
Buy an XLSX template or build from scratch?
Build it — ten minutes with the steps above, and you own every formula. Templates bury logic you did not write and cannot debug.