Convert Santander CSV to QuickBooks (.QBO)
Works with Santander CSV and Excel exports Nothing uploaded
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.
.QBO QuickBooks accepts. For Santander, its dates are usually DD/MM/YYYY, and amounts arrive as a single signed column (some exports split into Money in / Money out), both detected automatically.A typical Santander export has columns like Date, Description, Amount, Balance and uses DD/MM/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Santander statements into QuickBooks
- Export your transactions from Santander online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Santander-specific things to watch for
- Semicolon delimiter. Santander's midata CSV frequently uses
;instead of,, so QuickBooks reads every row as one field. QBO Maker auto-detects the delimiter and parses correctly. - UK date order. Dates are DD/MM/YYYY and QuickBooks defaults to US order; the converter fixes this so your transactions land on the right day.
- Masked / limited data. midata exports cover a capped window and mask some transaction detail for security, so descriptions can be shorter than on your PDF statement.
- Multiple export formats. Choosing XLS instead of midata gives a different layout, pick CSV/midata for the cleanest conversion.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID.
Frequently asked questions
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 your Santander statement now
Free, in your browser, nothing uploaded. We will set the date format and currency for you.
Open the converter