How to Convert a Nationwide PDF Bank Statement to CSV or Excel
Nationwide Building Society — the UK's largest building society — provides statements as PDF files, and its Internet Bank's own transaction downloads are limited. Here's how to convert those PDF statements into clean, structured CSV data, with your first statement free.
The Problem With Nationwide PDF Statements
Nationwide's Internet Bank lets you view the last 15 months of transactions on screen and download up to 36 months of PDF statements. Its Download transactions option offers a midata file for current accounts, but that is a fixed 12-month file which leaves out the most recent 31 days, and it isn't available in the app. If you need a specific period, an older statement or a full tax year in a spreadsheet or accounting software, the PDF is often what you have to work with.
Copy-pasting from a Nationwide PDF into Excel produces jumbled formatting. The "Payments" and "Receipts" columns collapse into a single mess, descriptions wrap across multiple lines, and dates lose their structure. For a FlexAccount statement with months of transactions, manual re-entry is not a realistic option.
As a building society rather than a bank, Nationwide is member-owned, and its export options are narrower than some commercial banks offer. Open Banking helps for ongoing data, but for historical statements or full-year records, PDF conversion is the practical solution.
Quick answer: Use MatchIQ's free PDF converter. Upload your Nationwide PDF and download a clean CSV that opens straight in Excel. Your first statement of up to 10 pages converts free on a new account.
How to Convert Your Nationwide Statement (4 Steps)
- Download the statement from Nationwide
Sign in to Nationwide online banking and download the PDF statement for each period you need. One PDF per statement period. - Create a free account
Register from the converter page, then open MatchIQ and open the PDF converter inside it. There is no bank to pick from a list — the extraction reads whatever layout is in front of it, which is why statements from banks we have never seen convert just as well. - Upload your PDF
Drag and drop or click to browse. The file is uploaded over an encrypted connection and read on our servers, which is what lets scans and photos work as well as native PDFs. - Download your CSV
Review the extracted transactions on screen, then download the CSV, ready to import into accounting software or to open in Excel for spreadsheet analysis.
Privacy note: Your statement is uploaded over an encrypted connection and read on our servers rather than in the browser. That is a deliberate trade: it is what allows scanned and photographed statements to convert, not just native PDFs.
What the Converter Extracts
The converter extracts these fields from your Nationwide PDF statement:
- Date — transaction date in a clean, sortable format
- Description — payee name, transaction type, and reference details
- Payments — debit amounts (money going out of your account)
- Receipts — credit amounts (money coming into your account)
- Balance — running balance after each transaction
Multi-line descriptions are merged correctly. Amounts with commas and currency symbols are normalised. The separate "Payments" and "Receipts" amounts come through as clean, correctly signed values.
Can I Download Nationwide Statements as CSV Directly?
Partly. The Internet Bank has a Download transactions option. For a current account it includes Download midata, which gives you the last 12 months of transactions, excluding the most recent 31 days, with some details blanked out; depending on the account, other formats may be offered too. Credit card customers can choose Download transactions and pick a format. What none of these do is turn an older PDF statement into data, and the Internet Bank only shows the last 15 months of transactions.
The midata download isn't available in the Nationwide app (on an iPhone or iPad you can only view the file), so you need the Internet Bank in a browser. For statements older than 36 months, or a period midata doesn't cover, converting the PDF is the practical route.
Alternative: Open Banking
Nationwide supports Open Banking, which allows you to connect your account to third-party tools that pull transaction data via API. How much history a connected app can pull varies by bank and by app, and you have to reconfirm access with the app every 90 days. For historical statements, a full year's data, or one-off exports, converting the PDF remains the best option.
Nationwide Statement Formats
Nationwide uses different statement layouts depending on the account type:
- FlexAccount / FlexDirect / FlexPlus — standard current account layout with date, description, payments (out), receipts (in), and balance columns
- Savings Accounts — simplified layout with date, description, withdrawals, deposits, and balance. Covers FlexDirect Savings, ISAs, and fixed-term bonds
- Credit Card Statements — transaction date, posting date, description, and amount format with separate purchases and payments sections, plus interest and fee breakdowns
- Mortgage Statements — annual statement format showing payment schedule, capital repaid, and interest charged. Less commonly converted, but it reads them the same way
The converter handles all common Nationwide UK formats. There are no per-bank templates: it reads whatever layout is in front of it, so older or unusual Nationwide layouts convert too.
What to Do With Your CSV Data
Once you have clean CSV data from your Nationwide statement, you can:
- Import into accounting software — Xero, QuickBooks, Sage, FreeAgent, and Pandle all accept CSV bank imports
- Upload it to IQ Books: ReconcileIQ's free UK accounting software reads the PDF, the CSV or even a photo of the statement directly, and CodeIQ can code the lines for you. See IQ Books
- Reconcile in MatchIQ — upload alongside your accounting data to automatically match and reconcile
- Analyse in Excel — pivot tables, spending analysis, cash flow tracking, budget vs actual comparisons
- Code in CodeIQ — if you're a bookkeeper, CodeIQ can automatically code transactions to your chart of accounts, classify VAT, and post back to your platform
- File with HMRC — structured data for tax return preparation or MTD submissions
- Track mortgage payments — if you hold a Nationwide mortgage, extract annual statement data to verify interest calculations or track overpayments
Convert Your Nationwide Statement Now
Fast, accurate, and checked on screen before you download. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Only partly. The Internet Bank's Download transactions option gives current account holders a midata file of the last 12 months (excluding the most recent 31 days), and it isn't available in the app. For a specific period or an older PDF statement, use a converter to extract the transactions into CSV automatically.
Yes. The converter handles Nationwide current accounts (FlexAccount, FlexDirect, FlexPlus), savings accounts, and Nationwide credit card PDF statements. The converter reads each layout and extracts the correct columns.
Your first statement of up to 10 pages converts free on a new account. After that it uses 2 credits per transaction (minimum 10 credits per file), and the cost is shown before anything is processed.
Nationwide PDF statements use formatted table layouts that do not copy cleanly into spreadsheets. When you paste into Excel, the Payments and Receipts columns merge together, multi-line descriptions break across cells, and dates lose their formatting. A dedicated PDF parser understands the Nationwide statement structure and extracts each field into the correct column.