United Kingdom · GBP

Convert Santander Bank Statements to Excel

Santander UK statements present date, description, money in, money out and balance with card transactions carrying purchase-date suffixes. US Santander statements use an entirely different layout; both are recognized. The converter normalizes either into one consistent export schema.

Drop your bank statement here

PDF, JPG or PNG · up to 25 MB

No signup required · Files deleted after processing · How files are handled

Works with statements from 1,000+ banks

How Santander statements are structured

  • Money in / money out columns (UK)
  • Card rows include “ON 12-01-2026” purchase date suffixes
  • US entity statements use a distinct ledger layout
  • Interest and fee summaries between months on combined PDFs

Fields extracted

  • Posting date, with card purchase date kept in the description
  • Cleaned description
  • Debit / credit amounts
  • Running balance

How to download a Santander statement

  1. 1Log on to Santander online banking.
  2. 2Open “Statements and documents”.
  3. 3Pick the account and statement month, then download the PDF.
  4. 4Upload it here to extract transactions.

Common Santander conversion problems

Purchase-date suffixes make descriptions inconsistent for pivot tables.

Suffixes are preserved but separated, keeping the merchant name consistent across rows.

UK and US Santander layouts are completely different.

Layout detection selects the right regional parser per document.

Example output

A converted Santander statement lands in these columns:

DateDescriptionDebitCreditBalance
28 Jan 2026CARD PAYMENT PRET A MANGER ON 27-01£9.45—£987.12
29 Jan 2026FASTER PAYMENT RECEIVED RENT—£1,050.00£2,037.12
30 Jan 2026STANDING ORDER SAVINGS£200.00—£1,837.12

Santander conversion FAQ

Are Santander US statements supported?
Yes — the US layout is detected separately and exports to the same schema.
Can I convert a full year of statements in one go?
Upload each monthly PDF (batch upload on paid plans) and merge the CSVs, or use the API to automate the whole year.

Related

StatementConvert is an independent service and is not affiliated with, endorsed by, or sponsored by Banco Santander, S.A.. Santander trademarks belong to their respective owners.