Free converter
Convert Santander UK bank statements to CSV or Excel
Upload a Santander UK PDF or CSV and download it as CSV, Excel, QIF, OFX or JSON, with every merchant identified.
Choose a statement file (PDF, OFX/QFX, CSV, XLSX, TXT — up to 5 MB)
CSV
spreadsheets & imports
Excel
XLSX workbook
QIF
Quicken, YNAB, GnuCash
OFX
accounting packages
JSON
developers & scripts
Getting your statement out of Santander UK
Santander UK keeps statements as e-Documents inside Online and Mobile Banking, and says you can see account activity from the last 7 years. Transactions are downloaded separately from the statement archive, through a format dropdown on the account itself, with a per-download transaction cap that catches people exporting a long history.
Download transactions for accounting software
- Log on to Online Banking and open the account.
- Choose the transaction download option.
- Select 'All available transactions' or 'Since last download'.
- Pick a format from the dropdown — Microsoft Excel, Quicken, Adobe Acrobat (PDF) or Microsoft Money.
- Click Download.
600 transactions per download. Narrow the date range and repeat if you need more.
Get statements in Mobile Banking
- Open the Santander Mobile Banking app.
- Tap 'Mailbox' in the top-right corner.
- Tap 'Statements and documents'.
- Select the statement and use the download icon to save it as a PDF.
Get statements in Online Banking
- Log on to Online Banking.
- Click 'Account services'.
- Open the statement you need.
- Use the print icon to print, or download the e-Document as a PDF.
Menu wording shifts between app versions; the destinations above stay stable — confirm against Santander UK's official help. Statements up to 5 MB / 5,000 rows are supported; card numbers are redacted before storage, the original file is deleted within 24 hours, and reports stay in your dashboard only as long as your plan keeps them.
What Santander UK gives you natively
Santander's transaction download offers Microsoft Excel, Quicken, Adobe Acrobat (PDF) and Microsoft Money. Statements themselves are held as e-Documents and download as PDF. There is no plain-CSV option in the download dropdown — the Excel export is the spreadsheet route.
How far back you can go
Santander's own paper-free statements page says you can see your account activity from the last 7 years in Mobile and Online Banking. That is the statement archive; the transaction download is bounded by the 600-row cap per request rather than by a fixed window, so a long history comes out in several files rather than one.
Santander UK statement quirks worth knowing
These are the details that trip people up when a Santander UK export doesn't line up with the statement it came from — worth reading before you assume the conversion is wrong.
- A hard cap of 600 transactions per download. Santander's own help gives the worked example: on an account doing roughly 50 transactions a month, any range longer than about twelve months will need a second download to capture everything.
- The download offers 'All available transactions' or 'Since last download' — the second option is stateful, so running it twice in a row returns almost nothing the second time.
- Statements and transaction downloads are separate things in different places: statements live in the Mailbox (mobile) or under Account services (online), while the transaction export sits on the account itself.
- Santander also offers a 12-month Midata export, which is built for comparison sites rather than bookkeeping and is not the same file as the transaction download.
Sources
Written from Santander UK's own documentation. Menu wording moves between app versions — these are the pages to check against:
Free converter
Convert your statement — and understand it too
A free account converts a statement page every day to CSV, Excel, QIF or OFX — with every transaction matched to a real merchant name, not a cryptic descriptor. No card required; files deleted after 24 hours.
No bank logins · card numbers redacted before storage · everything deleted after 24 hours
Frequently asked questions
Why does my Santander download stop at 600 transactions?
That is Santander's documented limit — you can only download 600 transactions per download. Their help gives the example of an account with about 50 transactions a month, where any range longer than roughly twelve months needs a second download. Split the date range and export in chunks, then combine the files.
Can I get a CSV from Santander UK?
Not directly. The download dropdown offers Microsoft Excel, Quicken, Adobe Acrobat (PDF) and Microsoft Money — the Excel option is the spreadsheet route, and it opens straight into Excel or Sheets. If you need true CSV, convert the Excel file or the PDF statement.
How far back do Santander statements go?
Santander says you can see your account activity from the last 7 years in Mobile and Online Banking. Statements are held as e-Documents in the Mailbox on mobile, or under Account services online.
What does 'Since last download' mean?
It exports only what has appeared since the previous export from that account, which is useful for a regular bookkeeping routine but confusing one-off: run it twice and the second file will be nearly empty. Use 'All available transactions' with a date range when you want a specific period.
Go deeper on Santander UK
We wrote a full walk-through of getting statements out of Santander UK — where each format hides, how far the history reaches, and what to do when the export and the statement disagree: How to export bank statements from Santander UK →