Netmend

Netmend · Bank statement → CSV · NatWest

Convert a NatWest statement PDF to CSV or Excel

NatWest official statements are PDFs. You can also export recent transactions as a CSV from Online Banking. This page shows both paths and the columns you should expect, so a PDF-only period still becomes a usable sheet.

United Kingdom (NatWest). Royal Bank of Scotland statements are similar but not identical.100% in your browserNo accountFrom $20 if you want it done

Convert a NatWest PDF now

The defaults below are set for a typical NatWest file. You can still change them. The file never leaves your computer.

No statement at hand? (fictional data)

How it stays private: the page uses the open-source pdf.js library (Mozilla) to read the file locally. There is no server and no upload. You can disconnect from the internet after the page loads and it still works.

The NatWest statement format

DatesDates are day-first DD/MM/YYYY in the PDF and in the usual transaction CSV.
NumbersUK format: 1,234.56. Choose UK/US numbers and a comma CSV.
RegionUnited Kingdom (NatWest). Royal Bank of Scotland statements are similar but not identical.

Where to download the official file

Official statements: in the NatWest app or Online Banking, open Statements (or View statements) for the account and download the monthly PDF. NatWest Help covers requesting a copy if a period is missing.

For a spreadsheet of recent transactions, from Online Banking:

  1. Go to Statements & transactions → View transactions.
  2. Choose the account and a date range.
  3. Export as CSV.

That export is not a substitute for the official monthly PDF when you need a legal statement.

What the PDF contains

A typical NatWest current-account PDF lists Date, Type, Description, Paid In, Paid Out and Balance. Only one of Paid In or Paid Out is filled on each row. References can wrap under the description.

Official CSV or Excel, when the bank offers one

The official transaction CSV commonly uses Date, Type, Description, Paid In, Paid Out and Balance, with DD/MM/YYYY dates. Prefer it for any period the bank still lets you export. Use our converter for older PDFs or for files a client emailed you.

What to watch for

Sources (checked 12/11/2026). NatWest Support Centre pages on viewing statements and on transaction details (natwest.com), checked 12/11/2026. CSV/PDF columns (Date, Type, Description, Paid In, Paid Out, Balance; DD/MM/YYYY) from current UK layouts the same day. Banks change layouts without notice: treat the first row of your own file as the authority.

Need it done for you? From $20

The free tool is for a clean, text-based PDF. For scans, password files, a packed year of statements or a layout that has to match your accounting software, we convert them and check every total against the opening and closing balance.

Done-for-you conversion
$20 / 20 pages

75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.

Need it done for you? From $20
Privacy

Your statement is processed only for the order and deleted after delivery. This page itself never uploads the file.

Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. No address, phone or national ID is asked for or published.

FAQ

Can I get a CSV from NatWest?

Yes, from View transactions in Online Banking, for a date range the bank still offers. Official statements remain PDFs.

Is this the same as Royal Bank of Scotland?

Close, but not a promise. Check the header row of the RBS file before you reuse a NatWest mapping.

Why doesn’t the CSV cover four years?

Transaction exports are usually limited to a recent window. Older months have to come from the PDF archive — that is what this converter is for.

Other bank guides

Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services