CSV from BankNatWest Statement to Excel or CSV
Convert your NatWest PDF right in your browser - it never leaves your computer.
- Free
- No sign-up
- Nothing uploaded
- Handles UK dates
NatWest can hand you transactions as a spreadsheet file directly from online banking, and when that option covers the period you need it is the better route - it is the bank's own data and no conversion can improve on it. This page is for the times when all you have is the PDF.
How to get the PDF from NatWest
- Log in to NatWest online banking.
- Open Statements and transactions, then Statements.
- Pick the year and the statement period, and save the PDF.
- Drop the file into the box above.
What a NatWest statement looks like inside
A UK current account line runs date, description, money out, money in, balance. Two amount columns, no minus signs, and a running balance after every line - which is what lets the converter check its own work here.
- The running balance is the useful part: every row is tested against the next one, and you see the result of that check before you download anything.
- Dates are read day first, worked out from the file rather than assumed, with a manual override in the settings panel.
- The download is built in your browser. Nothing is uploaded, which is worth knowing for a document that carries your sort code and your address.
NatWest is the only bank with a page here that offers a direct spreadsheet export from online banking, so this page starts by pointing you at it. The other pages exist because their banks leave you with a PDF and nothing else.
Statements sometimes carry a page footer with the bank's registered details. That text has no date at the start of the line, so it never becomes a transaction row.
Should I use the bank's own export instead of this page?
Yes, if it reaches the period you need. A direct export cannot misread a column, and saying so costs us a conversion but saves you a check. Come back here when the export will not go back far enough, when the account is closed, or when someone has sent you a PDF and that is all there is.
Other banks
The converter reads the layout of the document itself, so it is not limited to these - but these have their own page:
Chase · HSBC · Bank of America · American Express · Wells Fargo · Capital One · Citibank · Barclays