StatementDecoder
Upload

How to export statements from Santander UK (and beat the 600-row cap)

2026-09-06 · 5 min read

Santander UK keeps statements as e-Documents in one part of its banking, and hides the transaction download in another — with a per-download cap that catches almost everyone exporting more than a year. Both are documented by Santander itself; here's the whole picture in one place.

Statements (the e-Documents)

In the mobile app: tap Mailbox in the top-right corner, then Statements and documents, select the statement, and use the download icon to save it as a PDF. In Online Banking: log on, click Account services, open the statement, and download or print it. Santander says you can see your account activity from the last 7 years, so historic months are normally available.

The transaction download

  1. Log on to Online Banking and open the account.
  2. Choose the transaction download option.
  3. Select All available transactions or Since last download.
  4. Pick a format from the dropdown — Microsoft Excel, Quicken, Adobe Acrobat (PDF) or Microsoft Money — and click Download.

Note what's not in that list: plain CSV. The Excel option is the spreadsheet route, and it opens straight into Excel or Google Sheets.

The 600-transaction cap

Santander's own help is explicit: 600 transactions per download. Their worked example — an account doing roughly 50 transactions a month needs a second download for any range beyond about twelve months. If your export seems to stop mid-year, this is why: narrow the date range and export in chunks, then combine the files.

One more trap: Since last download is stateful. It exports only what's new since the previous export — run it twice in a row and the second file is nearly empty. Use All available transactions with a date range for one-off jobs.

Getting a clean spreadsheet

For recent periods, the Excel download is exact — mind the cap and stitch chunks if needed. For older months, or when the statement is the only thing you have, the Santander statement converter reads the PDF e-Document directly, reconciles every line against the statement's printed balances, and outputs CSV — the format Santander never offers — plus Excel, QIF or OFX, with every merchant named. Background on why PDF conversion usually goes wrong is in this guide.