Santander UK · United Kingdom

Santander UK Statement to Excel, CSV & Xero

Santander UK lets customers download transaction data to spreadsheet and money-management formats, but personal accounts are limited to 600 transactions per download. This guide explains when the native export is enough, when to convert the PDF statement instead, and how bookkeepers can get Santander data into Excel, Xero or QuickBooks.

Last updated 30 October 2026

At a glance

Official statement format
PDF statements and e-documents in Online and Mobile Banking
Spreadsheet export
Transaction download to Microsoft Excel, Quicken, PDF or Microsoft Money
Download limit
600 transactions per personal-account download; 3,000 on Santander Business accounts
Currency and dates
GBP (£), UK day-month date order
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

Santander gives you two different downloads

Santander UK provides transaction exports and PDF statements. They are useful for different jobs.

Transaction downloadPDF statement
What it isA list of transactions for a selected rangeThe official statement for a period
Formats stated by SantanderMicrosoft Excel, Quicken, Adobe Acrobat PDF, Microsoft MoneyPDF/e-document
Limits600 transactions per personal download; 3,000 on business accountsBest for statement periods and records
Best forRecent analysis or a clean export if it covers the full periodAccountants, audits, year-end and missing export ranges

If the export covers the full period and imports cleanly, use it. If it hits the transaction limit, does not match statement periods, or the client only has PDFs, convert the PDF statements instead.

How to download Santander UK transactions

Santander's public help says you can download detailed transactions by choosing whether you want a date range or everything since the last download, then picking a file format such as Microsoft Excel and clicking Download.

Two limits matter:

  • Personal accounts: 600 transactions per download.
  • Business accounts: 3,000 transactions per download.

If the period has more transactions than the limit, Santander says you may need to limit the date range and perform more than one download. For bookkeepers, this is where mistakes creep in: one missing date range can leave a gap in the ledger.

How to download Santander UK statements as PDFs

Santander's paper-free statement pages say documents are available in Mobile and Online Banking, and a PDF can be downloaded and printed. For bookkeeping work, ask the client for the official PDF statement for each month or statement period.

Use the PDF when:

  • the export limit is hit
  • you need opening and closing balances
  • you need the statement period, not an arbitrary search range
  • the client sends e-documents rather than export files
  • an accountant, auditor or lender asks for the official statement

Converting a Santander UK PDF statement

A Santander PDF statement usually needs the same cleanup as other UK bank PDFs: wrapped descriptions, separate money-in and money-out columns, and running balances that need to stay aligned.

Workflow:

  1. Upload the Santander PDF statement.
  2. Use OCR mode if the file is scanned or image-based.
  3. Choose Excel, CSV, JSON, Xero CSV or QuickBooks CSV.
  4. Download one transaction per row.
  5. Check the opening balance, closing balance and a few sample transactions against the PDF.

Dates should stay UK day-first, and amounts should stay in pounds.

Santander UK to Xero, QuickBooks or FreeAgent

For Xero or QuickBooks, a generic Excel file is often not enough. Use the accounting-software output directly:

  • Xero CSV: use when importing statement lines into Xero.
  • QuickBooks CSV: choose 3-column or 4-column based on your QuickBooks import setup.
  • FreeAgent: use CSV and check that the final layout matches FreeAgent's import rules before upload.

Bookkeepers should keep the original Santander PDF with the client records and use the converted file as the working copy.

Santander UK checklist for bookkeepers

Before importing Santander statement data:

  • check whether the native export hit the 600-transaction limit
  • check the period matches the client's bookkeeping period
  • keep PDF statements as source records
  • confirm UK date order after opening in Excel
  • check debit and credit signs before import
  • watch for transfers between Santander accounts
  • avoid overlapping a converted file with an existing bank feed

Choose your output format

Frequently asked questions

Can I download Santander UK transactions to Excel?

Yes. Santander's Online Banking help says detailed transactions can be downloaded to Microsoft Excel, Quicken, Adobe Acrobat PDF or Microsoft Money. Personal accounts are limited to 600 transactions per download, so longer date ranges may need several downloads.

What is Santander UK midata?

Santander says personal customers can download 12 months of transaction history to midata, which can be shared with comparison services. For bookkeeping, an official PDF statement may still be needed because midata is a transaction file rather than a statement.

Can I convert a Santander UK PDF statement to Excel?

Yes. Upload the PDF statement, choose Excel, and download one transaction per row with dates, descriptions, money in, money out and balances where available.

Can I import Santander UK data into Xero or QuickBooks?

Yes. Choose Xero CSV or QuickBooks 3- or 4-column CSV as the output, then import it into the matching Santander account in your accounting software.

What should I do if a Santander export misses transactions?

Check whether the date range exceeded Santander's transaction limit. For personal accounts the public help says 600 transactions per download, so split the period or convert the PDF statements for the missing months.

Is it safe to upload a Santander statement?

Statements contain account details and transaction history, so only use tools with a clear privacy policy. AI Bank Statement deletes uploaded files immediately after processing.

More bank guides

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing