PDF2TEXT
Try a statement free

Convert Nationwide statements to Excel or CSV

Nationwide lets you download 36 months of PDF statements from the Internet Bank, and current account holders can also download a 12-month midata file. If you need the statements themselves in a spreadsheet, or more history than midata covers, upload the PDFs here and get Excel or CSV with every line accounted for.

Private workspace. HTTPS upload. No credit card needed.

$9 for 25 pages, one-off, no subscription. See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Nationwide statement into Excel

  1. Download the PDF statement from Nationwide online banking

    • Log in to the Nationwide Internet Bank or the Nationwide app.
    • In the Internet Bank, choose the Documents tab, then Statements, and select the account under View by account; in the app, statements are under My Documents.
    • Download the statement PDF for the period you need.
    • Save the statement for the period you need as a PDF.
    Go to Nationwide Online Banking

  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Nationwide statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · GBP
Sample bank statement rows with made-up data, amounts in GBP
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Nationwide statements

Thirty-six months online

The Internet Bank holds 36 months of PDF statements. Many current account holders also get a statement in the post each month, so older history often exists on paper. Scans of those convert too, and a run of statements is checked for missing months when you upload it.

The midata file

Current account holders can download a midata file covering 12 months of transactions from the Internet Bank. It's a handy working file. When you need statement periods with their balances, or anything past 12 months, convert the statement PDFs instead.

Transactions split by a page break

A transaction near the bottom of a page can have its description on one page and its amount on the next, and longer descriptions wrap with a different indent. The converter rejoins the pieces into one row, and the balance check confirms nothing was lost at the break.

Notice of Charges

If you've run up fees on arranged overdraft borrowing, a Notice of Charges appears at the end of the statement. It tells you about charges rather than listing transactions, so when you review the converted file, make sure only real transaction rows go into your books.

Output and review

From Nationwide PDF to your books

Accounting tip

QuickBooks Online recommends dd/mm/yyyy dates for CSV uploads and wants every date in the file in the same format. The QuickBooks-ready file follows that on every row for UK statements; if your QuickBooks company uses another order, set Date format in the export menu before you download.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Nationwide statement questions

How do I get Nationwide statements older than 36 months?
The Internet Bank only keeps 36 months of PDF statements. For older periods, the paper statements posted each month are often the record: scan them and upload them alongside the PDFs. Gaps in the run are flagged, so you can see which months are still missing.
Should I use the Nationwide midata file or the statements?
Midata covers 12 months of current account transactions and is fine for a quick look. Statements give you the official periods and balances. If someone has asked for statements, or you need more than a year, convert the PDFs.
Can I import converted Nationwide rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Nationwide statement to Excel

Private workspace. HTTPS upload. No credit card needed.

More Bank Statement Converters

View all 98 bank pages

pdf2text is independent and not affiliated with or endorsed by Nationwide.