Sample Expense Data
Dated business expenses by category, department and payment status — for budget tracking and SUMIFS by month.
What is in the file
7 columns, 160 rows by default. The first ten rows are shown below — the download contains exactly this data.
| Expense ID | Date | Category | Department | Vendor | Amount | Status |
|---|---|---|---|---|---|---|
| EXP-1000 | 2026-06-27 | Software | Operations | Dubois | 24078.69 | Pending |
| EXP-1001 | 2026-04-13 | Software | Sales | Kowalski | 18706.92 | Paid |
| EXP-1002 | 2026-01-27 | Software | Operations | Dubois | 13335.14 | Refunded |
| EXP-1003 | 2026-11-12 | Software | Sales | Kowalski | 7963.37 | Overdue |
| EXP-1004 | 2026-08-29 | Marketing | Marketing | Dubois | 19610.78 | Pending |
| EXP-1005 | 2026-06-14 | Marketing | Support | Bennett | 14239.01 | Paid |
| EXP-1006 | 2026-03-31 | Marketing | Marketing | Andersen | 8867.24 | Refunded |
| EXP-1007 | 2026-01-14 | Marketing | Support | Bennett | 3495.46 | Overdue |
| EXP-1008 | 2026-02-21 | Marketing | Marketing | Rossi | 7059.5 | Pending |
| EXP-1009 | 2026-12-08 | Rent | Support | Sharma | 1687.73 | Paid |
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.
About this dataset
Expense rows are the most common thing people rebuild badly in a spreadsheet, so the practice value here is structural as much as formulaic: a flat table with a real date column groups by month with a PivotTable in three clicks, whereas the twelve-columns-of-months layout people usually build cannot. Amounts vary by category the way they do in reality — rent is steady, travel is spiky.
What you can practise with it
- SUMIFS spend by category and month
- A budget-vs-actual variance column and percentage
- Group dates by month or quarter in a PivotTable
- Filter to overdue items and total them
Tools that work on this data
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this sample expense data free to use?
Yes — for practice, teaching, demos and commercial work alike. The rows are generated, so there is no personal data in the file. Attribution is not required; if you would like to credit it, there is a ready-made line at the bottom of this page.
Do I have to sign up or give an email address?
No. The file is built in your browser when you click download; nothing is uploaded and no account is involved.
Which formats can I download?
Excel (.xlsx), CSV and JSON. All three contain the same rows, so you can use the CSV for an import exercise and the .xlsx for a formula exercise.
Can I choose how many rows I get?
Yes. Pick a row count before downloading — the default is 160 rows, which is what the preview on this page is drawn from.