Nationwide · Excel
Convert your Nationwide statement PDF to an Excel spreadsheet
Get a Nationwide statement into Excel with dates you can sort and amounts you can total. Your statement never leaves your computer.
Beta Not yet tested on real Nationwide statements. What that means
or drop it here
Read in this browser. Your file is never uploaded.
Rows wrong or missing?
Send us the shape of this statement, not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Date | Description | Paid in | Paid out | Balance |
|---|
Send us the shape of , not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Check | Result | What we found |
|---|
Statements
| Period | File | Opening | Closing | Rows | Used as |
|---|
| Date | Description | Paid in | Paid out | Balance | From |
|---|
Works with text PDFs that have Date, Description, Paid in / Paid out (or Amount) and Balance columns. Scanned or photographed statements are not supported yet. The samples are fictional test data.
Putting Nationwide statements into Excel is useful for budgeting, checking income for a mortgage application, or getting a year ready for an accountant.
Nationwide’s own download, or the PDF statement?
Nationwide’s Internet Bank can also let you download recent transactions. That covers a limited recent period. For older months or figures that match the statements exactly, convert the PDF statements.
Nationwide PDF statement to Excel, step by step
- Save the statement PDFGet it from Nationwide. The Nationwide statement to CSV page describes where to find it.
- Convert it aboveChoose the file and wait for the balance check. As Nationwide is in beta, look for “Verified” before you use the result.
- Download the CSV for ExcelIt has Date, Description, Paid in, Paid out and Balance columns.
- Open and save in ExcelDouble-click the file, then save it as an Excel workbook (.xlsx) before adding formulas.
Working with Nationwide transactions in Excel
- Running balance check. Add a column computing previous balance plus money in minus money out, and compare it with the Balance column.
- Bills by month. Filter for direct debits and build a pivot table by month to see how bills change through the year.
- Flag large payments. Use conditional formatting on Paid out to highlight anything over a chosen amount.
Support status: beta
StatementToCSV reads statements by their columns, not with a fixed template for each bank, so some Nationwide statements may already convert. But we haven’t yet tested a real Nationwide statement, so we don’t claim support. Verified means every extracted row adds up to the balances printed on the statement. If you don’t see Verified, the converter shows you where the balances stopped adding up.
StatementToCSV is independent and not affiliated with or endorsed by Nationwide. The name is used only to describe the statements the converter reads.
Questions people ask
How do I convert a Nationwide statement to Excel?
Save the PDF statement from the Internet Bank, convert it here and download the CSV for Excel.
Will money in and money out be in the right columns?
Columns are matched by their headings, and every conversion is checked against the running balance, so a column read the wrong way round would show up as a failed check.
Is Nationwide fully supported?
Not yet; it is in beta. The balance check tells you whether each statement converted completely.