ANZ••4 min read

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.

Convert ANZ PDF to CSV

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.

  1. 1
    Log in to ANZ Internet Banking at anz.com.au

    Use your customer registration number and password.

  2. 2
    Select the account you want to export

    Click the account from your accounts list to open its transaction history.

  3. 3
    Click "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.

  4. 4
    Set 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.

  5. 5
    Download 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.

Convert ANZ PDF to CSV

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.

Convert ANZ PDF to CSV

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:

  1. In Excel: Data > From Text/CSV, select the file, set delimiter to Comma
  2. 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.

Convert ANZ PDF to CSV
How to Export ANZ Bank Statements as CSV or Excel