BR
BankStatementReader

How to Download & Convert a NatWest Statement to Excel

By BankStatementReader Team ·

If you need to budget, file a tax return, or hand figures to an accountant, a paper-style PDF is rarely enough — you need the transactions in a spreadsheet. This guide covers how to download a NatWest statement as a PDF from online banking or the mobile app, then convert that PDF into Excel or CSV. (Menu labels change from time to time, so treat the steps below as the typical route rather than exact wording.)

Download a NatWest statement via online banking

Downloading from a desktop browser is usually the quickest way to grab several months at once.

  1. Log in to online banking.
  2. Select the current account (or credit card) you want a statement for.
  3. Look for the Statements & transactions area of the account. The exact menu and wording can vary depending on which version of online banking you are using.
  4. Choose the statement period you need.
  5. Download the file as a PDF and save it somewhere you can find it later.

If you bank for a business as well as personally, double-check you have selected the right account before downloading — sort codes and account numbers look similar at a glance.

Download a NatWest statement in the mobile app

The app is handy when you only need a single month or you are away from your computer.

  1. Open the app and log in.
  2. Tap the account you want, then look for Statements or Documents.
  3. Pick the statement period.
  4. Use the view, share, or download option to save the PDF to your phone.

From the app you can usually email the PDF to yourself or save it to your phone's files, which makes it easier to move onto a computer for the conversion step.

Choosing the right statement period

  • NatWest statements are normally organised by monthly cycle, so select the month or months you actually need rather than downloading everything.
  • For a Self Assessment tax return you may need a full tax year, which runs 6 April to 5 April. Download each consecutive month so there are no gaps. You can check the dates and deadlines on GOV.UK.
  • For a mortgage or loan application you are often asked for the last three to six months — download each period separately.
  • Keep the original PDF even after you convert it. It is your source document if anyone needs to verify the figures.

Why convert the PDF to Excel or CSV?

A PDF is fine for reading, but it is awkward for anything analytical. You cannot sort it, total a column, or filter by payee. Once the transactions are in a spreadsheet you can:

  • Categorise spending and build a monthly budget.
  • Total expenses for an expense claim or tax return.
  • Import the rows into accounting software for bank reconciliation.
  • Spot duplicate or unexpected payments, such as a forgotten subscription or an old standing order.

How to convert a NatWest PDF to a spreadsheet

There are three common approaches, and the right one depends on how many statements you have.

Type it in by hand

For one short statement, you can open the PDF next to a blank workbook and key in each row. It needs no tools, but it is slow and a single mistyped figure in a balance column is easy to make and hard to find afterwards.

Copy and paste

If the PDF has a real text layer (rather than being a scan), you can sometimes select the transaction table and paste it into Excel. Expect to tidy up: columns often collapse together, and longer payment descriptions can break the row alignment. Excel's Data → Text to Columns helps split the pasted text back into separate fields.

Use an automated converter

A dedicated converter reads the statement, detects the transaction table, and exports clean rows straight to Excel or CSV — including scanned or image-only pages that copy-paste cannot handle. This suits anyone who processes statements every month or has several to get through. Drop your file into the free bank statement converter to export tidy rows to Excel or CSV.

For a fuller walkthrough of all three methods and the trade-offs of each, see how to convert a bank statement to Excel.

Pick a format: XLSX or CSV

Export to XLSX when you want formatting, formulas, or several sheets in one file. Choose CSV when you need to import the data into accounting or bookkeeping software, which usually expects a plain comma-separated file. Either way, once the data is structured you can move on to budgeting, reconciling, or filing with confidence.

A quick recap

  1. Log in to NatWest online banking or the app.
  2. Open Statements or Documents, select the account and period, and download the PDF.
  3. Convert the PDF to Excel or CSV — by hand, by copy-paste, or with an automated bank statement converter.
  4. Keep the original PDF as your source document.

Related reading