How to Export a Bank Statement CSV (and Why It Matters for Budgeting)

Download your bank statement as CSV, then analyse spending without linking your bank login. Works with most NZ and international banks.

If you want a clear picture of where money goes, a bank statement CSV is the fastest honest input. You export the transactions yourself, keep control of the file, and skip apps that demand ongoing bank access.

Why CSV beats PDF for budgeting

PDF statements are fine for filing. They are poor for maths. A CSV (comma-separated values) file is a simple table: dates, descriptions, amounts. Budget tools can total categories, find recurring charges, and chart trends in seconds.

Privacy tip: With Spendstat, the CSV stays in your browser session. There is no bank login and no sync token sitting on a third-party server.

How to export a bank statement CSV

Menus differ by bank, but the path is usually the same:

  1. Sign in to online banking (website or app).
  2. Open Accounts, Statements, or Transaction history.
  3. Pick a date range — one calendar month is ideal for a first pass.
  4. Choose Export, Download, or Save, then select CSV (sometimes labelled Excel/CSV or OFX; prefer CSV when offered).
  5. Save the file somewhere obvious (Downloads or a Budget folder).

Common NZ banks (ASB, ANZ, BNZ, Westpac, Kiwibank and others) expose downloads under statements or “previous transactions.” International banks usually hide the same option under “Download” or “Export.”

What a good export looks like

  • One row per transaction
  • A date column and an amount column
  • A description / payee / narrative field
  • Optional balance column (helpful, not required)

If the file opens as gibberish in Notepad, you may have downloaded OFX or QIF — try CSV again, or open it in Excel/Sheets and re-save as CSV UTF-8.

Next step: analyse without a bank link

Upload the file to the free Spendstat spend analyser. You get categories, totals, and reports from that CSV alone. Prefer a guided walkthrough? Use Try It with sample data first.

Related reads: How to analyse your bank statement · Why privacy-first tools keep data local

FAQ

Do I need to remove personal details?

You can leave the file as exported. If you share a screenshot or email the file, redact account numbers first. Browser-only tools never need your password.

Can I combine multiple accounts?

Export each account separately and analyse them one at a time, or merge CSVs carefully in a spreadsheet (same column headers) before upload.

How often should I export?

Monthly is enough for most households. Weekly exports help if you are actively cutting a category (dining, subscriptions, fuel).

← All Financial Insights Analyse your CSV free