Santander Bank Statement Converter
Convert your Santander UK statement PDF to CSV, Excel, OFX, or QBO. Extract transactions automatically and download in the format you need. Our dedicated parser handles this bank with high accuracy.
Drop your bank statement here
PDF, up to 50 pages
Export formats
CSV
Universal spreadsheet format. Opens in Excel, Google Sheets, Numbers, or any data tool.
Excel (XLSX)
Native Microsoft Excel format with formatted columns and headers.
OFX
Open Financial Exchange format. Imports into Quicken, Mint, and most financial software.
QBO
QuickBooks Web Connect format. Direct import into QuickBooks Desktop and Online.
About Santander statements
Santander UK Current Account statements are downloaded as PDFs from Santander Online Banking or the Santander UK mobile app under 'Statements'. Despite the Santander group's Spanish origin, Santander UK plc operates under UK clearing and statements are in GBP, formatted in British conventions; the file header reads 'Santander UK plc' followed by 'Current Account Statement'.
The account block uses the standard British layout — 'Sort code: 09-01-28 Account number: 45678901' — and the statement period is given as 'Statement from 01 January 2026 to 31 January 2026' using full month names. Transaction dates inside the table switch to the more compact DD/MM/YYYY format. Opening and closing positions are labelled 'Balance brought forward £X,XXX.XX' and 'Balance carried forward £X,XXX.XX', matching the long-standing British high-street format.
The ledger has five visible columns — Date, Description, Money out, Money in, Balance — but in the PDF text each transaction collapses to a single row with two pound figures: the unsigned amount and the new running balance. ConvertStatement's Santander parser recovers the correct sign by comparing prev_balance ± amount against the next balance within a 0.01 tolerance, so the exported CSV, Excel, OFX or QBO file is correctly signed and reconciles to the printed brought-forward and carried-forward totals.
How to convert your Santander statement
- 01
Download your statement from Santander
Log in to your Santander UK online banking, navigate to Statements & Documents, and download the PDF for the period you need.
- 02
Upload the PDF above
Drag and drop the PDF into the upload area on this page, or click to browse. The parser detects your bank automatically.
- 03
Preview your transactions
Review the extracted transactions in the preview table. Verify dates, descriptions, and amounts are correct.
- 04
Choose your format and download
Select CSV, Excel, OFX, or QBO and download your converted file. Import it into your accounting software or spreadsheet.
Santander statement format at a glance
Santander UK plc Current Account statements are denominated in GBP — not EUR — and use the date format DD/MM/YYYY for transaction lines, with the header period written out as 'Statement from 01 January 2026 to 31 January 2026' in full month names. Numbers follow US-style 1,234.56 punctuation, every amount is prefixed with £, and the ledger has five visible columns: Date, Description, Money out, Money in, Balance. In the underlying PDF text each row collapses to two pound figures — the unsigned transaction amount and the running balance. Opening and closing positions are labelled 'Balance brought forward £X,XXX.XX' and 'Balance carried forward £X,XXX.XX'. Accounts are identified by a 6-digit sort code such as 'Sort code: 09-01-28' and an 8-digit account number. ConvertStatement converts these PDFs to CSV, Excel, OFX or QBO while reconstructing debit/credit signs from the running balance.
- Date format
- DD/MM/YYYY
- Decimal format
- 1,234.56
- Currency
- GBP
- Column layout
- Date | Description | Money out | Money in | Balance — each line resolves to DD/MM/YYYY Description £amount £balance (one unsigned amount plus the running balance)
- Statement sections
- Current Account Statement · Balance brought forward · Balance carried forward · Statement from ... to ...
Known Santander parsing quirks
These are real layout details that make Santander PDFs different from other banks. Our dedicated parser handles each one explicitly so the exported CSV, Excel, OFX, or QBO is always correctly signed and dated.
- Despite being part of the global Santander group, Santander UK plc statements are GBP, not EUR, and use US-style 1,234.56 number punctuation
- Period header uses full month names: 'Statement from DD MMMM YYYY to DD MMMM YYYY'; transaction rows use the shorter DD/MM/YYYY
- Sort code is given as 'Sort code: 09-01-28' plus an 8-digit Account number — the account number is masked on export
- Opening/closing balances use the British convention 'Balance brought forward £X,XXX.XX' / 'Balance carried forward £X,XXX.XX' (not 'Opening Balance')
- Amounts are unsigned; debit vs credit is reconstructed from the running balance using prev ± amount = balance within a 0.01 tolerance, identical to the Barclays approach
Description prefixes the Santander parser recognises
Direct DebitStanding OrderBill PaymentFaster PaymentCard PaymentFPIFPODDSOBGCBACTFRMulti-line handling: Each transaction is one line. Wrapped descriptions from the PDF are normalised into a single line before regex matching.
Convert to a specific format
Other supported banks
ConvertStatement supports dedicated parsers for many other US, UK, and European banks. Same in-memory processing, same export formats.
Frequently asked questions about Santander statement conversion
How do I download my Santander UK bank statement as a PDF?
Log in to Santander Online Banking at santander.co.uk, go to your current account, select 'Statements', choose the period, and download as PDF.
Does ConvertStatement support Santander UK current accounts?
Yes. ConvertStatement fully supports Santander UK current account statements in GBP. Upload your PDF and the parser will detect and convert it automatically.
Are Santander UK GBP amounts handled correctly?
Yes. Santander UK statements use GBP with standard UK formatting (dot decimal, comma thousands). Our parser correctly handles pound amounts and the Money out / Money in column format.
Is my Santander statement data safe?
Yes. ConvertStatement processes files entirely in memory. No bank data is stored, logged, or shared. All transfers use HTTPS encryption. Your data is deleted from memory as soon as processing completes.
How much does it cost to convert a Santander statement?
ConvertStatement offers 3 free conversions per month (CSV format). Paid plans start at $9/month for 200 pages with all export formats including Excel, OFX, and QBO.
Convert your Santander statement now
No signup required. Upload your PDF and get results in seconds.
Upload Santander statement