How to Convert a Santander PDF Bank Statement to CSV or Excel
Santander UK provides statements as PDF files through online banking. Here's how to turn them into clean, structured CSV data for Excel or your accounting software in a few seconds, with your first statement free.
The Problem With Santander PDF Statements
Santander's online banking lets you view and download statements as PDFs. That's fine for reading or printing — but useless if you need the data in your accounting software, a spreadsheet, or a reconciliation tool.
Copy-pasting from a Santander PDF into Excel produces broken formatting. Dates land in description columns, amounts lose their signs, and multi-line transaction details merge into unreadable text. For a quarterly statement with hundreds of transactions, manual data entry isn't realistic.
Quick answer: Use MatchIQ's free PDF converter. Upload your Santander PDF and download a clean CSV that opens straight in Excel. Your first statement of up to 10 pages converts free on a new account.
How to Convert Your Santander Statement (4 Steps)
- Download the statement from Santander
Sign in to Santander online banking and download the PDF statement for each period you need. One PDF per statement period. - Create a free account
Register from the converter page, then open MatchIQ and open the PDF converter inside it. There is no bank to pick from a list — the extraction reads whatever layout is in front of it, which is why statements from banks we have never seen convert just as well. - Upload your PDF
Drag and drop or click to browse. The file is uploaded over an encrypted connection and read on our servers, which is what lets scans and photos work as well as native PDFs. - Download your CSV
Review the extracted transactions on screen, then download the CSV. It imports into accounting software and opens directly in Excel for spreadsheet work.
Privacy note: Your statement is uploaded over an encrypted connection and read on our servers rather than in the browser. That is a deliberate trade: it is what allows scanned and photographed statements to convert, not just native PDFs.
What the Converter Extracts
The converter turns your Santander PDF statement into a CSV with four columns:
- Date: the transaction date, in one consistent format
- Description: payee and transaction details, kept as they appear on the statement
- Reference: filled where the statement has a separate reference column, otherwise left blank
- Amount: one signed column, negative for money out and positive for money in
Santander's separate Money In and Money Out columns become the one signed Amount column. Multi-line descriptions are rejoined, commas and currency symbols are stripped from amounts, and dates come out in the same format whichever Santander layout you have. The running balance is not carried into the CSV, so tick the closing figure off against the statement once it is imported.
Can I Download Santander Statements as CSV Directly?
Not as CSV. Santander's online banking does have a Download transactions option, which saves your transactions as a Microsoft Excel, Quicken, Microsoft Money or PDF file. Each download is capped at 600 transactions on a personal account (3,000 on Santander Business), so a busy year has to be split into several date ranges, and it works from the transactions available in online banking rather than from statements you already hold.
So if what you have is a set of PDF statements, such as a client's year of statements sent to their accountant, converting the PDF is the quicker route. That holds whichever Santander account the statement comes from: 1|2|3, Everyday, business or credit card.
Alternative: Santander Open Banking
Santander supports Open Banking, which allows you to connect your account to third-party financial apps that pull transaction data via API. How far back that data goes varies by bank and by app, and the app has to ask you to reconfirm access every 90 days. For historical statements, end-of-year data, or a complete record of a set period, PDF conversion is the more dependable route.
Common Santander Statement Formats
Santander uses several statement layouts depending on account type:
- Santander Personal: standard layout with date, description, money in, money out, and balance columns
- Santander 1|2|3 Account: same column structure as personal, often with cashback summary sections
- Santander Business: business account layout with additional reference and payment type fields
- Santander Credit Card: transaction date, description, and amount format with separate sections for purchases and payments
The converter handles all common Santander UK formats. It recognises the layout by itself, and any page it does not recognise, including scans and photos, is read visually line by line, so an unusual layout still converts.
What to Do With Your CSV Data
Once you have clean CSV data from your Santander statement, you can:
- Import into accounting software: Xero, QuickBooks, Sage, FreeAgent, and Pandle all accept CSV bank imports
- Keep the books in IQ Books: IQ Books, ReconcileIQ's UK accounting software, is free for one business with the whole ledger, takes the CSV (or reads the PDF statement itself) and files Making Tax Digital VAT and Income Tax returns at no cost
- Reconcile in MatchIQ: upload it alongside your ledger export and MatchIQ matches it automatically, showing what is matched, missing and extra
- Analyse in Excel: pivot tables, spending analysis, cash flow tracking
- Code in CodeIQ: if you're a bookkeeper, CodeIQ can automatically code transactions to your chart of accounts, classify VAT, and post back to your platform
- File with HMRC: structured data for tax return preparation or MTD submissions
Convert Your Santander Statement Now
Fast, accurate, and checked on screen before you download. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Not as CSV. Santander's online banking can download transactions as a Microsoft Excel, Quicken, Microsoft Money or PDF file, up to 600 transactions at a time on a personal account. To turn PDF statements you already have into CSV, upload them to a free converter tool such as MatchIQ's PDF converter.
Use the free PDF converter at reconcileiq.com/bank-statement-converter. Upload your Santander PDF and download the extracted data as a CSV. CSV files open directly in Excel, or you can copy-paste the preview data.
Your first statement of up to 10 pages converts free on a new account. After that it runs on credits, and the cost is shown before anything is processed.
Yes. The converter handles Santander personal accounts, 1|2|3 Current Accounts, business accounts, and credit card statements, reading each layout and extracting the date, description, reference and amount of every transaction.