BR
BankStatementReader

How to Download a Santander Statement (and Convert It)

By BankStatementReader Team ·

If you are budgeting, filing a tax return, or sending figures to an accountant, a paper-style PDF is rarely enough on its own — you need the transactions in a spreadsheet you can sort and total. This guide covers how to download or request a Santander 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 Santander statement via online banking

A desktop browser lets you download several months in one go.

  1. Log in to online banking.
  2. Select the current account, savings account, or credit card you want a statement for.
  3. Look for the statements or documents 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 again later.

If you hold more than one account, double-check you have selected the right one before downloading — sort codes and account numbers look similar at a glance.

Download a Santander statement in the mobile app

The app is useful 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 the statements or documents section.
  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.

How to request a Santander statement you cannot see online

Online statements normally only go back a certain number of months or years. If you need an older period, or a printed copy, you may have to request it separately rather than download it. The usual routes are:

  • Asking through the secure messaging or help section of online banking or the app.
  • Calling the number on the back of your card.
  • Visiting a branch with suitable ID.

A requested statement can take time to arrive and an older or paper copy may carry a fee, so check before you ask. Whenever the statement is available to download, that is the route to use.

Choosing the right statement period

  • Santander statements are normally organised by monthly cycle, so select only 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 or request 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 Santander 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 Santander online banking or the app.
  2. Open the statements or documents area, select the account and period, and download the PDF — or request an older or paper copy if it is not available online.
  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