# Convert Santander CSV to QuickBooks (.QBO)

_Canonical: https://qbomaker.com/banks/santander.html_

Santander UK doesn't offer a Web Connect or .QBO download. From Online Banking you go to My accounts and transactions, open the account, choose Download transactions, and pick a format from the drop-down, typically Excel (XLS), text, or midata (CSV). The midata route is the one most people reach for when they need a spreadsheet.That midata CSV has two traits that break QuickBooks. First, it is often semicolon-separated rather than comma-separated, so QuickBooks Online (and Excel, in some regions) reads the whole row as a single cell and the import fails outright. Second, dates are UK DD/MM/YYYY, which QuickBooks tends to misinterpret as US MM/DD. Santander also masks some sensitive transaction detail in midata exports, and the file carries a limited window of history.QBO Maker reads the semicolon delimiter, normalises the dates, separates the description from the signed amount, and outputs a standards-compliant .QBO you can import through QuickBooks Web Connect, no fiddling with delimiters or column mapping in Excel. It all runs locally in your browser, so the statement never leaves your computer. Convert your Santander CSV now.

## Steps

1. Export your transactions from Santander online banking as CSV or Excel.
2. Open the QBO Maker converter and drop the file in.
3. Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
4. Choose .QBO as the output and click download.
5. In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.

**Does Santander provide a QBO or Web Connect file?**
No. Santander UK offers CSV (midata), Excel and text downloads only, there is no native .QBO or Web Connect option. QBO Maker converts your Santander CSV into the .QBO file QuickBooks needs.

**Why won't QuickBooks read my Santander midata file?**
The midata CSV is usually semicolon-delimited, so QuickBooks treats each line as a single column and rejects it. QBO Maker detects the semicolon separator and parses the rows properly, then writes a .QBO that imports cleanly.

**Which Santander download format should I choose for conversion?**
Pick midata (CSV) from the Download transactions drop-down. It is the most consistent layout for converting. If you only have an Excel (.xls) export, QBO Maker accepts that too.

**Is my Santander data kept private?**
Yes. Conversion happens entirely in your browser, nothing is uploaded to any server. You can preview the result on the validator before importing into QuickBooks.

---
Convert free at https://qbomaker.com/#tool, runs entirely in your browser.