How to Convert Nationwide Statements to CSV (2026)

Nationwide Building Society has a loyal customer base, but its online banking tools haven't always kept pace with the big high-street banks when it comes to data exports. The good news is that Nationwide does offer a CSV download feature through internet banking. The less good news is that the output format often needs cleanup before it's ready for accounting software, and the experience can vary between current accounts and savings products. This guide covers every method for getting your Nationwide data into a clean, usable spreadsheet.

What Nationwide Offers Natively

Nationwide's internet banking platform provides statement viewing, PDF downloads, and — for most current accounts — a CSV transaction download.

Downloading CSV from Internet Banking

1. Log into Nationwide Internet Banking
2. Open the statement for the account you want to export
3. Select a start and end date (maximum range is one fiscal year: 6 April to 5 April)
4. Click the Download transactions dropdown menu at the top-right of the screen
5. Select Download CSV file
6. Save the file to your device

The CSV file will open in Excel or any spreadsheet application and contains the transaction date, description, type, amount paid in, amount paid out, and running balance.

PDF Statements

Nationwide also provides PDF statements through both internet banking and the mobile app. Monthly statements are available in the app's document library, though the app version uses a slightly different font and layout compared to the online banking PDF — both contain the same transaction data.

Limitations to Be Aware Of

The CSV export is limited to a maximum date range of one fiscal year. For savings accounts and some older product types, the CSV option may not be available at all — you'll only see the PDF download. The CSV file format is basic and sometimes requires adjustment before it imports cleanly into accounting software, particularly around how debits and credits are separated into different columns.

Converting PDFs for a Cleaner Result

If the CSV export isn't available for your account type, or if you need a more structured format for your accounting software, converting the PDF statement is a reliable alternative.

BankToFile handles Nationwide PDF statements and produces clean, structured CSV or Excel files:

1. Download your statement PDF from Nationwide's internet banking or mobile app
2. Upload to BankToFile — works in your browser, nothing to install
3. Select CSV or Excel as the output format
4. Download your file — transactions extracted into clean columns with correct formatting

This is also the better option if you have multiple months of PDFs to convert at once, or if you're working with savings account statements that don't offer the CSV export natively.

Making Nationwide's CSV Work with Accounting Software

Nationwide's native CSV format separates money in and money out into two separate columns ("Paid in" and "Paid out"). Most accounting software — Xero, QuickBooks, FreeAgent — expects either a single amount column (with positive and negative values) or explicitly mapped debit and credit columns.

For Xero: When importing, map the "Paid in" column to Credit and "Paid out" to Debit. Xero's import wizard supports dual-column mapping.

For QuickBooks: QuickBooks prefers a single amount column. Before importing, you may need to combine the two columns in your spreadsheet using a formula like =IF(E2>0, E2, -F2) where E is "Paid in" and F is "Paid out."

For FreeAgent: FreeAgent's import handles both single-column and dual-column formats. Follow the guided mapping during upload.

BankToFile's output is already formatted for clean import into these platforms, which saves the column-merging step.

Tips for Nationwide Customers

Check CSV availability for your account type. Not all Nationwide products support CSV export. Current accounts generally do; savings accounts and ISAs may only offer PDF downloads.

Use the fiscal year limit strategically. Nationwide caps CSV downloads at one fiscal year (6 April to 5 April). This aligns perfectly with HMRC's self-assessment period, so set your date range accordingly.

Handle the two-column amount format. If your accounting software expects a single amount column, merge "Paid in" and "Paid out" before importing. Or use BankToFile to get a pre-formatted file that's ready to go.

Keep original PDFs. Nationwide's PDF statements are accepted as official documents for mortgage applications, visa applications, and HMRC correspondence. Always retain them.

Name your files clearly. A convention like nationwide-flexdirect-2026-01.csv will save you searching through generic filenames six months later.

Common Issues and Fixes

CSV option not visible. If you only see PDF download options, your account type may not support CSV export. Download the PDF and convert it through BankToFile instead.

Amounts won't sum in Excel. The "Paid in" and "Paid out" columns may import as text. Select the columns, go to Data > Text to Columns, choose Delimited, and click through to force numeric parsing.

Dates in wrong format. Select the date column, right-click, choose Format Cells > Date, and apply your preferred format.

File opens as a single column. Your spreadsheet isn't detecting the comma delimiter. Use File > Import in Google Sheets or the Text Import Wizard in Excel and explicitly select comma as the separator.

Running balance doesn't match. If the balance column doesn't add up, check for duplicate transactions at the start or end of your date range. Nationwide sometimes includes boundary-date transactions in overlapping exports.

Conclusion

Nationwide's CSV export is more useful than what many UK banks provide, particularly with its fiscal-year date range that aligns neatly with self-assessment periods. The main friction point is the dual-column amount format and the lack of CSV support for some account types.

For a hassle-free conversion that works with any Nationwide account, try BankToFile's free converter. Upload your PDF statement, download a properly formatted CSV, and import it straight into your accounting software.