Convert Santander Statements to Excel & CSV
Upload a Santander PDF statement and get every transaction back in clean, ready-to-use columns. $0.15 per page, no subscription.
What a Santander statement looks like
Santander prints its transaction table with these columns. We read every row exactly as it appears and return clean, normalized data.
- Dates are printed as ordinal day and month without a year (e.g. 21st January) — the statement period in the header carries the year
- A running Balance column on every row. The £ sign appears on balances only — Money in and Money out are bare numbers in two separate columns.
- Statements open with a BALANCE BROUGHT FORWARD row and close with BALANCE CARRIED FORWARD — capitalised rows with no amount that we exclude from totals. Real statements print descriptions in block capitals with embedded references and mandate numbers that wrap across lines; we reassemble them, strip the st/nd/rd/th suffixes, and complete every date with the year.
Why convert your Santander statement here
Santander statements have their own quirks. We built our converter for them.
Ordinal dates, cleaned up
Santander dates rows "6th January" or "21st January" with no year, and statement periods run mid-month to mid-month. You get complete ISO dates, including periods that span December into January.
Money in and out, merged
Credits and debits never share a column on a Santander statement. We merge them into one signed amount — money out negative, money in positive — and keep the original two columns alongside.
Only real transactions
Brought-forward and carried-forward rows, the News and Information box, and the interest and charges mini-table are excluded automatically — and used to double-check your balances instead.
Nothing to lose
If a conversion fails, your credits are refunded automatically — and your first 10 pages are free.
How to download your Santander statement
You need the PDF first. Here is where Santander keeps it.
Online banking
- 1 Log on to Online Banking at santander.co.uk
- 2 Open "Statements and documents" in the top-right of the page
- 3 Select your account and the statement you need
- 4 Download the PDF to save or print it
Mobile app
- 1 Tap "Mailbox" in the top-right corner of the home screen
- 2 Select "Statements and documents" — you can filter by account, document type, and date range
- 3 Tap the statement to open it in the PDF viewer
- 4 Tap the download icon in the top-right corner to save the PDF
Santander keeps your account activity and statements from the last 7 years in Online Banking. Even after closing an account, you can request up to 5 years of payment transaction history.
What people convert Santander statements for
Bookkeeping
Feed clean monthly transactions into your books instead of retyping them.
Tax preparation
Pull a full year of statements into columns that are ready for the return.
Reconciliation
Line statement transactions up against your ledger in one spreadsheet.
Loan & mortgage applications
Hand over tidy transaction histories when lenders ask for them.
Expense tracking
See where the money went without copying rows by hand.
Audit preparation
Produce consistent, sortable records for reviews and audits.
How to convert a bank statement to Excel
Three steps, no manual typing, no templates to set up.
Upload your PDF statement
Drag in one statement or twenty, from any bank. Up to 200 pages and 20 MB per file.
We extract every transaction
Dates, descriptions, and amounts are read straight from the document, row by row. Nothing is summarized, merged, or invented.
Download Excel or CSV
Both formats come with every conversion. Open the spreadsheet or import the CSV wherever you need it.
Simple pay-per-page pricing
Know the price before you upload. Your first 10 pages cost nothing.
$0.15 / page
- First 10 pages free
- No subscription, no minimum
- Excel and CSV included
- Failed conversions refunded automatically
What customers say
"Santander's "21st January" dates with no year meant Excel never sorted my statements properly, especially over New Year. Here every row comes back with a full date. My monthly bookkeeping for the shop finally takes one sitting."
Gemma Whitfield
"The mortgage adviser wanted twelve months of statements as spreadsheets. Santander had them all in Online Banking, and the converter turned the whole year into tidy CSVs — brought-forward rows already stripped out."
Daniel Okonkwo
"My client's Santander business statements print everything in capitals with references and mandate numbers wrapping over two lines. Every other tool split those rows in half. This one stitched them back together perfectly."
Fiona MacLeod
Convert statements from other banks
Any bank works. These are the ones we convert most often.
Convert your first Santander statement free
Upload a Santander PDF and download clean Excel or CSV in minutes. Your first 10 pages are on us.
First 10 pages free · No credit card · No subscription