How to Export ANZ Bank Statements as CSV or Excel
ANZ Internet Banking has a straightforward CSV export, but it only covers around 24 months and it's desktop-only. If you're on ANZ Plus, the situation is different. This guide covers both, and what to do when you need data the export won't give you.
Only have a ANZ PDF statement?
Convert your ANZ PDF statement into a CSV of your transactions. Open it in Excel, review your spending or prepare it for your accounting software.
ANZ Internet Banking: exporting transactions as CSV
This works for standard ANZ accounts . transaction accounts, savings accounts, and credit cards. You need to be on a desktop browser.
- 1Log in to ANZ Internet Banking at anz.com.au
Use your customer registration number and password.
- 2Select the account you want to export
Click the account from your accounts list to open its transaction history.
- 3Click "Export transactions"
This option appears above the transaction list. It may show as a small download icon or a labeled button depending on your screen size.
- 4Set the date range and file format
Choose your From and To dates. Select CSV for Excel or Google Sheets. ANZ also offers OFX for accounting software like Xero.
- 5Download the file
The CSV downloads to your computer. Open it in Excel, Google Sheets, or import it into your accounting software.
The CSV includes date, transaction description, debit amount, credit amount, and balance. ANZ splits debits and credits into separate columns, which is useful when you're categorising expenses and want to filter by type.
Need older ANZ transactions in a spreadsheet?
Convert your ANZ PDF statement into a CSV of your transactions. Open it in Excel, review your spending or prepare it for your accounting software.
ANZ Plus: no CSV export (yet)
ANZ Plus is ANZ's newer digital bank, and it currently does not support exporting transactions as CSV or any other spreadsheet format. This is a known limitation and one that comes up constantly for Plus customers trying to do their bookkeeping or EOFY prep.
What ANZ Plus does offer:
- PDF statements, which you can download from the ANZ Plus app
- Transaction history viewable in-app going back to account opening
Turn your ANZ PDF statements into CSV
Convert your ANZ PDF statement into a CSV of your transactions. Open it in Excel, review your spending or prepare it for your accounting software.
How far back does the ANZ CSV export go?
ANZ Internet Banking lets you export transactions from the last 24 months for open accounts. For periods outside that range, use the statement archive or request replacement statements.
ANZ's official transaction export and statement instructions.
For statements older than 24 months, you'll need to use the Statements section within ANZ Internet Banking, which is separate from the transaction export. This lets you download monthly PDF statements going back several years.
If you need that data in spreadsheet form, the PDF route works well. Download the relevant monthly statements, then run them through our ANZ statement converter to get a combined CSV. See also: getting historical statement data from any Australian bank.
Credit card accounts
ANZ credit card exports work the same way as transaction accounts. In ANZ Internet Banking, select your credit card from the accounts list and use the Export transactions option. The CSV layout is the same, though the description format for credit card transactions tends to include merchant category codes that don't appear in transaction account exports.
Opening the ANZ CSV in Excel
The file should open correctly when you double-click it. If the data appears in one column instead of separate fields, import it manually:
- In Excel: Data > From Text/CSV, select the file, set delimiter to Comma
- In Google Sheets: File > Import, upload the file, select comma-separated
Frequently asked questions
Does ANZ Plus support CSV export?
Not currently. ANZ Plus only offers PDF statements. Download those and use a PDF converter to get your data into a spreadsheet.
How far back can I export ANZ transactions?
Up to 24 months via the transaction export in ANZ Internet Banking, for open accounts. For older data, download PDF statements from the Statements section.
Can I export ANZ credit card transactions?
Yes. Select your credit card account in ANZ Internet Banking and follow the same export steps as a transaction account.
Can I export ANZ transactions from the mobile app?
The standard ANZ app does not support CSV export. You need ANZ Internet Banking on a desktop browser. ANZ Plus also lacks a CSV export . download PDFs from the app instead.
Ready to convert your ANZ statement?
Convert your ANZ PDF statement into a CSV of your transactions. Open it in Excel, review your spending or prepare it for your accounting software.