How to download your NatWest bank statement
NatWest lets you download statements as PDF in online banking and in the app. Transactions can also be exported as Excel, PDF, CSV, OFX. Below: the exact steps, how far back you can go, and how to turn a PDF statement into Excel, CSV or QuickBooks.
Download a PDF statement in online banking
- Log in to Online Banking at onlinebanking.natwest.com.
- Select 'Statements & transactions' in the main menu, then 'Statements'.
- Choose the account and the year from the dropdowns.
- Click the statement period link; it downloads as a PDF.
Download a statement in the NatWest app
- Log in to the NatWest app and select the account.
- Tap the 3-dot icon at the top and choose 'Statements'.
- Select the statement you want to view.
- Tap the export button at the top right and choose how to save or send it.
Export transactions as CSV or another format
ExcelPDFCSVOFX
- Log in to Online Banking and select 'Statements & transactions', then 'View transactions'.
- Choose the account and adjust the search fields (date, type, description or amount).
- Press 'View transactions' to show the results.
- Select 'Export to Excel' or 'Download PDF'.
NatWest's export instructions name Excel and PDF; a separate NatWest FAQ on accounting software lists OFX (Microsoft Money, Quicken, Sage Line 50) and CSV (Excel, text) files.
How far back can you go?
NatWest says statements can be downloaded going back up to 7 years, and transactions can be searched back 7 years in Online Banking, provided the account has been open that long.
Good to know
- The data export sits under 'View transactions' in Online Banking; the app route documented by NatWest only produces PDFs.
- NatWest no longer offers midata downloads and points customers to the Excel or PDF transaction export instead.
- If you cannot print a PDF statement, a posted copy has to be requested through Cora chat.
Convert your NatWest statement to Excel
Statement PDFs can't be sorted, summed or imported. Drop one on Rowvert and get a spreadsheet with one row per transaction — date, description, debit, credit, balance — checked against the statement's own closing balance. Excel, CSV, QuickBooks (.qbo or CSV), Xero, OFX and QIF.
- Download the PDF statement using the steps above.
- Drop it on the converter — no template to choose, scanned PDFs work too.
- Download Excel, CSV, or a QuickBooks / Xero-ready file.
Free for 1 page a day without an account · 5 pages a day with a free account
Already exported a CSV, QFX or QBO from NatWest? Convert it to another format for free.
| A · Date | B · Description | C · Debit | D · Credit | E · Balance | |
|---|---|---|---|---|---|
| 1 | 2026-08-02 | CARD PURCHASE 08/01 STARBUCKS #2231 NEW YORK NY | 6.85 | 4,805.55 | |
| 2 | 2026-08-03 | ACH DEBIT CON EDISON UTILITY PAYMENT | 142.19 | 4,663.36 | |
| 3 | 2026-08-04 | ZELLE PAYMENT FROM J. MARTINEZ | 350.00 | 5,013.36 | |
| 4 | 2026-08-08 | DIRECT DEPOSIT ACME CORP PAYROLL | 3,240.00 | 7,664.94 | |
| 5 | 2026-08-12 | CHECK #1042Verify — read from image | 130.00 | 7,534.94 |
Example output. Layout is identical for every bank; only your transactions change.
Can I download my NatWest statement as a CSV?
Yes: NatWest's transaction export offers Excel, PDF, CSV, OFX (steps above). Statements themselves come as PDF. If the export doesn't reach back far enough, convert the PDF statements to CSV with Rowvert.
How far back can I download NatWest statements?
NatWest says statements can be downloaded going back up to 7 years, and transactions can be searched back 7 years in Online Banking, provided the account has been open that long.
How do I convert a NatWest PDF statement to Excel?
Download the statement PDF, drop it on the Rowvert converter and download Excel, CSV, QuickBooks (.qbo or CSV), Xero, OFX or QIF. Each row is checked against the statement's running balance, and 1 page a day is free without an account.
Does Rowvert work with scanned NatWest statements?
Yes. Scanned or photographed statements go through OCR automatically. Rows read from an image are marked so you can double-check them.
Is my NatWest statement stored?
The PDF is processed in memory and never kept. Only the extracted spreadsheet is stored, for your plan's retention window, then deleted.
Which date format will the Excel file use?
NatWest statements usually show dates as DD/MM/YYYY or MM/DD/YYYY; Rowvert converts them to real Excel dates so they sort and filter correctly.