Netmend

Netmend · Bank statement → CSV · Santander UK

Convert a Santander UK statement PDF to CSV or Excel

Santander UK already offers a midata CSV of up to 12 months of transactions. Use that when you can. This page covers that official file, the PDF statement layout, and how Spain or Portugal statements differ.

Santander UK current accounts (notes below for Spain and Portugal)100% in your browserNo accountFrom $20 if you want it done

Convert a Santander UK PDF now

The defaults below are set for a typical Santander UK 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 Santander UK statement format

DatesUK PDFs are day-first. Some Santander UK PDF tables print the transaction date as an ordinal day and month without a year (for example “21st January”); the year sits in the statement-period header, so a January statement that also shows late December needs care. Official midata/transaction CSVs use a normal date column.
NumbersUK format: 1,234.56 (comma thousands, dot decimal). Choose UK/US numbers and a comma CSV, unless your Excel is set to a European locale.
RegionSantander UK current accounts (notes below for Spain and Portugal)

Where to download the official file

Official midata CSV, from Santander UK (“Midata — helping you compare current accounts”):
  1. Log in to Online Banking and open the My Accounts and Transactions tab.
  2. Choose the current account, then Download transactions above the table.
  3. In Download to, select midata (CSV) and download.

Midata covers up to 12 months. Personal data such as your name, address and account number is masked, and some sensitive transactions are masked too — so midata is for comparison and analysis, not as a legal statement. For the official monthly PDF, use statements in Online or Mobile Banking.

What the PDF contains

A typical Santander UK current-account PDF lists Date, Description, Money in, Money out and Balance. Only one of Money in or Money out is filled on each row. If the date column omits the year, copy the year from the statement period and be careful on statements that span two calendar years.

Official CSV or Excel, when the bank offers one

Prefer midata or the ordinary “Download transactions” CSV when you need rows for Excel, and keep the PDF as the official document. Our converter is for PDFs you were sent or for periods midata no longer covers.

What to watch for

Sources (checked 12/11/2026). Santander UK midata help (santander.co.uk), checked 12/11/2026. PDF column notes (Date, Description, Money in, Money out, Balance) from current UK statement 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

Should I convert the PDF or download midata?

Download midata (or transaction CSV) for spreadsheet work. Convert the PDF when that export is missing, or when you need the official document turned into rows.

Why is there no year on the date?

Some UK PDFs print “21st January” and put the year only in the header. Add the year before you sort or import, especially around New Year.

Does this work for Santander in Spain or Portugal?

The tool will read a text PDF. Switch to European numbers. The download menus are not the same as Santander UK.

Other bank guides

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