How to Convert Santander Bank Statements to CSV (2026)

Santander's online banking has a reputation among UK accountants and bookkeepers for being... quirky. The "Microsoft Excel" download option doesn't always produce a true Excel file. The CSV option disappeared for some account types after a platform update. And there's a 600-transaction limit on personal account exports that forces you to download in smaller chunks. If you've been searching for a straightforward way to get your Santander data into a spreadsheet, this guide has you covered.

What Santander Offers Natively

Santander's online banking does include transaction download features, though the experience differs between personal and business accounts — and the file formats aren't always what they claim to be.

Personal Account Exports

1. Log into Santander Online Banking
2. From the My Accounts and Transactions tab, choose your current account
3. Click Download transactions above the transaction table
4. Choose a date range (either "All available transactions" or "Since last download")
5. Select a format from the dropdown: Microsoft Excel, Quicken, PDF, or Microsoft Money
6. Click Download

The "Microsoft Excel" option is the closest you'll get to a CSV, but there's a well-known issue: Santander frequently saves this file as an HTML table with an .xls extension rather than a genuine Excel file. It opens in Excel, but it can cause problems when importing into accounting software or opening in LibreOffice. More on how to fix this below.

Santander also offers a midata CSV download specifically designed for current account comparison sites. This covers 12 months of transaction history in a standardised format, though some personal data is masked for privacy.

Business Account Exports

Business banking customers get the same format options, but with a higher transaction limit of 3,000 per download (versus 600 for personal accounts). The same HTML-masquerading-as-Excel issue applies.

The 600-Transaction Limit

Personal account exports are capped at 600 transactions per download. If you have more than about 50 transactions per month and need a full year, you'll need to break the export into smaller date ranges and combine the files manually.

The Simpler Route: Convert PDFs with BankToFile

Given Santander's formatting quirks and transaction limits, many users find it easier to download the PDF statement and convert it to a proper CSV.

BankToFile handles Santander PDF statements natively:

1. Download your statement from Santander as a PDF (via the Download transactions page or the Statements section)
2. Upload to BankToFile — it works in your browser with nothing to install
3. Select CSV or Excel as your output format
4. Download your converted file — clean columns, correct dates, properly formatted amounts

This sidesteps the HTML-as-Excel issue entirely and avoids the 600-transaction limit since PDF statements contain the complete month regardless of transaction count. For tax season, you can convert a full year of monthly PDFs in minutes rather than fighting with Santander's export tool.

Fixing Santander's "Excel" File

If you've already downloaded the .xls file from Santander and it isn't behaving, here's what's happening and how to fix it.

Santander is saving the transaction data as an HTML table with an .xls file extension. Excel opens it (with a warning), but other applications may reject it. To get a genuine CSV:

1. Open the .xls file in Excel (click "Yes" if prompted about the file format)
2. Go to File > Save As
3. Select CSV (Comma delimited) from the format dropdown
4. Save the new file

Alternatively, rename the file extension from .xls to .html, open it in a web browser, select all the data, and paste it into an empty spreadsheet. Either method produces a usable file, but it's an extra step that BankToFile eliminates entirely.

Importing into Accounting Software

With a clean CSV, importing into your accounting platform follows the standard process.

Xero: Accounting > Bank Accounts > Import a Statement. Map columns on first import.

QuickBooks: Banking > Upload transactions. QuickBooks previews before finalising.

FreeAgent: Banking > Bank Accounts > Import. Guided column mapping makes the first upload simple.

If you're importing Santander's native "Excel" file directly, some accounting platforms will reject it because it's actually HTML. Converting through BankToFile avoids this issue since the output is a genuine, properly formatted CSV.

Tips for Santander Customers

Don't trust the .xls extension. Always check the actual file format. If your accounting software rejects the import, it's likely because the file is HTML disguised as Excel. Re-save as CSV or use BankToFile to convert the PDF instead.

Break large exports into chunks. With the 600-transaction personal limit, plan your downloads by quarter or by month if your transaction volume is high.

Use midata for comparison, not accounting. The midata CSV is useful for switching banks, but it masks some data and isn't suitable for bookkeeping or tax preparation.

Align to the tax year. Export statements covering 6 April to 5 April. Santander's date range picker allows custom dates, so match to HMRC's self-assessment periods directly.

Keep original PDFs. Santander's PDF statements are your official financial records. Always retain them alongside any converted CSV files.

Common Issues and Fixes

"Excel" file won't import into accounting software. The file is likely HTML with an .xls extension. Open in Excel, save as CSV, then re-import. Or convert the PDF through BankToFile instead.

Hit the 600-transaction limit. Reduce your date range and export in smaller batches. Alternatively, download the PDF statements (which have no transaction limit) and convert them.

Dates in wrong format. Select the date column in your spreadsheet, right-click, choose Format Cells > Date, and pick your preferred format.

Missing recent transactions. Santander's export may have a short delay before the most recent transactions appear. Wait 24–48 hours after a transaction posts before expecting it in the export.

Conclusion

Santander's export tools work, but they come with enough quirks — the fake Excel format, the 600-transaction cap, and the inconsistent file outputs — that many users end up spending more time fixing files than they would on alternative approaches.

For a straightforward, no-surprises conversion, try BankToFile's free converter. Upload your Santander PDF, download a genuine CSV, and get on with your accounting.