Convert Santander UK CSV to QBO / QFX / OFX
Drop your Santander UK CSV or Excel export below and get a Santander UK → QuickBooks/Quicken/Xero file in seconds. Private — nothing leaves your browser.
Advanced — bank identifiers (for "file not recognized" issues)
QuickBooks/Quicken use INTU.BID to recognize the file. Pick your bank above to autofill, or paste your own.
Free: up to 25 transactions per file. Pro (one-time $29): unlimited.
How to export your transactions from Santander UK
Export via Santander UK Online Banking (web). Retail (personal): log in > select account > view transactions/statements > choose 'All available transactions' (date range) OR 'Since last download' > pick a format from the dropdown > Download. Business: same flow under the business banking portal. Formats offered (per Santander help page): Microsoft Excel, Quicken (QIF), Adobe PDF, Microsoft Money - plus CSV in practice. Download limits: max 600 transactions per download on Personal, 3000 on Business (split by date range for more). A separate 'midata' option on personal current accounts gives 12 months of history as CSV. IMPORTANT: Santander UK does NOT provide a QuickBooks Web Connect (.QBO) download and has NO INTU.BID; in the UK, QuickBooks links to Santander via Open Banking bank feeds, not OFX/QBO file import. Page value: 'Santander UK only gives you CSV/Excel/QIF; here is how to turn that into a QBO/OFX QuickBooks will accept.' CSV/Excel layout: Date, Description, then SEPARATE money-in/money-out columns (Credits and Debits) and Balance - i.e. NOT one signed Amount column. Quirks: (1) date is DD/MM/YYYY and some exports render ORDINAL dates like '3rd May 2024' (strip the ordinal suffix when parsing); (2) separate Credit/Debit columns must be combined into one signed amount (credit positive, debit negative); (3) the CSV is widely reported as not directly recognised by QuickBooks - exactly the conversion gap this page fills. The QIF export is an alternative path if a Quicken-style import is preferred.
Once you have the file, drop it into the converter above. LedgerBridge auto-detects the date, amount and description columns — adjust the mapping if needed, choose QBO for QuickBooks (or QFX for Quicken, OFX for Xero), and download.
Tips for Santander UK files
- Choose DD/MM/YYYY as the date format if auto-detect guesses wrong.
- If withdrawals come in as positive numbers, tick “Flip amount sign”.
- For credit-card exports, set the account type to Credit card.
- If QuickBooks rejects the file, open Advanced and confirm the INTU.BID — selecting “Santander UK” in the bank dropdown autofills it.
FAQ
How do I export a CSV from Santander UK?
Export via Santander UK Online Banking (web). Retail (personal): log in > select account > view transactions/statements > choose 'All available transactions' (date range) OR 'Since last download' > pick a format from the dropdown > Download. Business: same flow under the business banking portal. Formats offered (per Santander help page): Microsoft Excel, Quicken (QIF), Adobe PDF, Microsoft Money - plus CSV in practice. Download limits: max 600 transactions per download on Personal, 3000 on Business (split by date range for more). A separate 'midata' option on personal current accounts gives 12 months of history as CSV. IMPORTANT: Santander UK does NOT provide a QuickBooks Web Connect (.QBO) download and has NO INTU.BID; in the UK, QuickBooks links to Santander via Open Banking bank feeds, not OFX/QBO file import. Page value: 'Santander UK only gives you CSV/Excel/QIF; here is how to turn that into a QBO/OFX QuickBooks will accept.' CSV/Excel layout: Date, Description, then SEPARATE money-in/money-out columns (Credits and Debits) and Balance - i.e. NOT one signed Amount column. Quirks: (1) date is DD/MM/YYYY and some exports render ORDINAL dates like '3rd May 2024' (strip the ordinal suffix when parsing); (2) separate Credit/Debit columns must be combined into one signed amount (credit positive, debit negative); (3) the CSV is widely reported as not directly recognised by QuickBooks - exactly the conversion gap this page fills. The QIF export is an alternative path if a Quicken-style import is preferred.
Is my Santander UK data uploaded anywhere?
No. The conversion happens entirely in your browser. Your statement and account number never leave your device — safe even for client confidentiality requirements.
Will the file import into QuickBooks?
Yes. We generate a valid OFX 1.0.2 (SGML) document with the correct header and identifiers. Convert a small file free first to confirm it imports cleanly, then unlock unlimited.