Santander · Excel
Convert your Santander statement PDF to an Excel spreadsheet
Get a Santander statement into Excel with dates you can sort and amounts you can total. Your statement never leaves your computer.
Beta Not yet tested on real Santander statements. What that means
or drop it here
Read in this browser. Your file is never uploaded.
Rows wrong or missing?
Send us the shape of this statement, not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Date | Description | Paid in | Paid out | Balance |
|---|
Send us the shape of , not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Check | Result | What we found |
|---|
Statements
| Period | File | Opening | Closing | Rows | Used as |
|---|
| Date | Description | Paid in | Paid out | Balance | From |
|---|
Works with text PDFs that have Date, Description, Paid in / Paid out (or Amount) and Balance columns. Scanned or photographed statements are not supported yet. The samples are fictional test data.
Getting Santander statements into Excel lets you total income, track spending or prepare figures for an accountant, with the statement’s own balances confirming the rows are complete.
Santander’s own download, or the PDF statement?
Santander online banking may also let you download recent transactions in a format for spreadsheets or money-management software. That is useful for recent activity. For statements going further back, or for figures that need to match the official statements, convert the PDF statements instead.
Santander PDF statement to Excel, step by step
- Save the statement PDFGet it from Santander. The Santander statement to CSV page describes where to find it.
- Convert it aboveChoose the file and wait for the balance check. As Santander is in beta, look for “Verified” before you use the result.
- Download the CSV for ExcelIt has Date, Description, Paid in, Paid out and Balance columns.
- Open and save in ExcelDouble-click the file, then save it as an Excel workbook (.xlsx) before adding formulas.
Working with Santander transactions in Excel
- Check the closing balance. The last value in the Balance column should match the closing balance printed on the statement.
- Monthly totals. Add a Month column with
=TEXT(A2,"yyyy-mm")and summarise money in and out with a pivot table. - Cashback and interest. Filter the description for “cashback” or “interest” to total them for the year.
Support status: beta
StatementToCSV reads statements by their columns, not with a fixed template for each bank, so some Santander statements may already convert. But we haven’t yet tested a real Santander statement, so we don’t claim support. Verified means every extracted row adds up to the balances printed on the statement. If you don’t see Verified, the converter shows you where the balances stopped adding up.
StatementToCSV is independent and not affiliated with or endorsed by Santander. The name is used only to describe the statements the converter reads.
Questions people ask
How do I get a Santander statement into Excel?
Download the PDF statement, convert it here and click “Download CSV for Excel”.
Is Santander fully supported?
Not yet. It is in beta until we have tested real Santander statements. Every conversion shows whether the balances add up.
Can I merge a year of Santander statements?
Yes. Add them all in “Several statements” to get one combined, checked CSV.