NAB statements and Excel

Convert a NAB Bank Statement to Excel

Reviewed 12 September 2026

Short answer

Short answer

Download the original NAB PDF statement, convert it with the dedicated NAB parser, check the date range and balances, then open the resulting CSV in Excel. The CSV contains structured transaction columns and editable rule-based categories, so you can filter, total and review the data without rebuilding the PDF table by hand.

Some NAB credit card PDFs expose text in an order that does not match the visible columns. This is why the NAB route uses its own parser rather than sending the statement through one worldwide extraction model.

What makes NAB statement extraction different

Copy and paste may look reasonable while pairing a value with the wrong field, so the extracted balance path needs checking. The dedicated parser is maintained around the way NAB prints and exposes its statement data.

AussieBankStatements supports NAB transaction, savings and Australian credit card statements. It returns CSV because Excel opens it directly, while the same file stays portable for an accountant or accounting system. The original PDF is processed in memory and never stored.

Step by step

  1. 01

    Download the NAB PDF

    Use the original digital statement where possible rather than a screenshot or resaved scan.

  2. 02

    Choose NAB

    Select the matching bank so the statement runs through the dedicated NAB parser.

  3. 03

    Convert and preview

    Check the extracted dates, descriptions, debit and credit values, balances and categories.

  4. 04

    Download CSV

    Save the clean transaction file after reviewing the free preview.

  5. 05

    Open it in Excel

    Use Excel for filters, formulas, PivotTables or a handover to your accountant.

Checks before you rely on the spreadsheet

  • The account and statement period match the PDF.
  • Debit and credit direction is correct.
  • Opening and closing movement reconciles where printed.
  • Uncategorised rows remain visible for review.

Questions people ask

Can Excel open the converted NAB statement?

Yes. Excel opens CSV directly. The output uses separate Date, Description, Debit, Credit, Balance and Category fields.

Why use a NAB-specific converter?

Some NAB credit card PDFs expose text in an order that does not match the visible columns. A dedicated parser can be refined for those known layouts and edge cases.

Can I combine several NAB statements?

Yes. Batch conversion can merge up to ten statements into one chronological CSV. Keep different bank accounts in separate output files.

Is the original NAB PDF stored?

No. The original PDF is processed in memory and never stored or sent to an AI model.

Skip the manual PDF cleanup

AussieBankStatements converts supported Australian bank PDFs into categorised CSV data that opens directly in Excel. Preview the result before paying.

Convert this bank statement

Related Excel guides

Need the data in accounting software? Visit the Xero guide library.