NatWest bank statement to CSV
Convert NatWest bank statements from PDF into a clean spreadsheet with dates, descriptions, signed amounts and balances. Free, no signup, and your file is never stored.
Convert a NatWest statement
Drop your NatWest PDF statement here
or click to browse · 10MB max · nothing is stored
About NatWest statements
NatWest statements print a dated ledger with type codes and a running balance, and business customers often need years of them converted for accounting catch-up work.
How to download your NatWest statement as a PDF
Sign in to NatWest online banking, open the account, choose Statements, and download the PDF.
Always take the statement file the bank issues rather than printing a transaction list from the browser. The issued statement is the document of record, and it converts more reliably than a printed page.
What a NatWest statement looks like
A dated table runs type, description, paid in, paid out and balance, with the account header at the top.
NatWest quirks to watch for
These are the details that break a copy-paste into Excel, and the reason a NatWest statement rarely lands cleanly on the first try:
- Type codes such as POS, D/D, S/O and BAC appear before the description.
- Charges are summarised in a separate section on some accounts.
- Statement periods are set by the account cycle, not the calendar month.
- UK statements print dates day first, so 03/04 is the third of April. Dates are normalised on export so Excel cannot silently read them as March 4th.
What you get back
Every NatWest conversion returns the same columns, in GBP, so statements from different months and different accounts stack in one spreadsheet without rework:
| Date | Type | Description | Amount | Balance |
|---|---|---|---|---|
| 2026-03-04 | DD | CARD PAYMENT TO SUPERMARKET | -64.20 | 2,481.19 |
Check the export before you use it: opening balance plus the sum of the amount column should equal the closing balance printed on your NatWest statement.
Why not just export from NatWest directly?
Use the direct export when it covers the period you need. It rarely does. Direct CSV, OFX and QBO downloads are usually capped at a recent window, while PDF statements stay available for years, and they are the only thing left once an account is closed. Converting the PDF removes the date limit entirely.
Frequently asked questions
+Does it convert NatWest business statements?
Yes, business current account statements use the same table format.
+What happens to the charges summary?
The summary is skipped, but the individual charge transactions are exported as rows.
+Is the NatWest statement converter free?
Yes. No signup, no email and no watermark on the output. The only limit is a 10MB file size.
+Do you store my NatWest statement?
No. The PDF is processed in memory to build the CSV and is never written to disk or retained.
+Is this service affiliated with NatWest?
No. This is an independent tool with no connection to NatWest. It reads a PDF you already have and never connects to your account.