How to Export NAB Bank Statements as CSV or Excel
NAB Internet Banking lets you export up to 24 months of transactions as a CSV file. That's one of the more generous limits among the big four banks. Here's how to do it, what the file looks like, and what your options are when you need to go further back.
Only have a PDF statement? Use our NAB PDF to CSV Converter to extract your transactions instantly — no manual copy-pasting.
Convert NAB PDF →Exporting NAB transactions from Internet Banking
You need to use NAB Internet Banking on a desktop browser. The NAB app does not have a CSV or spreadsheet export option.
- 1Log in to NAB Internet Banking at nab.com.au
Use your NAB ID (or username) and password.
- 2Open the account you want to export
Click the account from your accounts list to see the transaction history.
- 3Click "Export transactions"
This button sits near the top of the transaction list, often alongside search and filter options.
- 4Choose the date range and format
Set your From and To dates, then select CSV for spreadsheets. NAB also offers OFX for direct import into Xero, MYOB, or Quicken, and QIF for older software.
- 5Download and open the file
The file downloads immediately. Open it in Excel, Google Sheets, or import it into your accounting software.
NAB data not going back far enough?
Our converter turns NAB PDF statements into clean CSVs — upload multiple months at once.
What the NAB CSV file contains
NAB's CSV export includes: date, amount, description, and balance. Unlike ANZ and Westpac which split debits and credits into separate columns, NAB uses a single Amount column with negative values for debits. This is a common source of confusion when importing into Excel — just be aware of it before you start summing columns.
NAB transaction descriptions tend to be fairly readable compared to some banks, though longer merchant names are sometimes truncated.
The 24-month limit
NAB allows exports going back approximately 24 months, which covers two full financial years. This is more than CommBank or ANZ typically allow, and it's enough for most EOFY purposes.
If you need data beyond that window — say, for a tax review, a loan application requiring three years of history, or catching up on older bookkeeping — you'll need to use NAB's PDF statement archive instead.
Need NAB data older than 24 months?
Download monthly PDF statements from the Statements section in NAB Internet Banking, then convert them in seconds. Upload multiple PDFs at once and get everything in a single combined file — no manual copying required.
NAB credit card and business accounts
NAB credit card transactions can be exported the same way as transaction accounts. Select your credit card from the accounts list and follow the same steps. The CSV format is consistent across account types.
NAB business banking accounts follow the same export process through NAB Internet Banking. If you use NAB Connect for business, the export options are similar but the interface is different — look for a transaction download or export option within each account view.
Importing into Excel
Opening the file directly usually works. If the data appears in one column instead of separate fields:
- Excel: Data > From Text/CSV, select the file, set delimiter to Comma
- Google Sheets: File > Import, upload the CSV, choose comma as separator
The negative sign on debit amounts means if you want to see total money in versus total money out, you'll need to split the Amount column into separate credit and debit columns, or use SUMIF to sum positive and negative values separately.
Frequently asked questions
How far back can I export NAB transactions?
Approximately 24 months via NAB Internet Banking. For older data, download PDF statements and convert them.
Can I export NAB transactions from the app?
No. NAB's mobile app doesn't support CSV export. Use NAB Internet Banking on a desktop browser.
What formats does NAB support for export?
CSV, OFX, and QIF. Use CSV for Excel or Google Sheets. OFX for Xero, MYOB, or Quicken.
Why does the NAB CSV show negative amounts for debits?
NAB uses a single Amount column with negative values for money going out, rather than separate debit/credit columns. This is normal. When summing transactions in Excel, use SUMIF to separate positive and negative entries.
Need NAB data beyond 24 months?
Download your NAB PDF statements and run them through our converter. Every transaction lands in a clean CSV — ready for Excel, Xero, or your accountant. Upload a full year at once and it's done in seconds.