QBO to CSV Converter
Convert QBO bank statement files to CSV for Excel, Google Sheets, and any spreadsheet app. Free, browser-based, no upload.
Drop your QBO file here
or click to browse
How to convert QBO to CSV
Upload QBO
Drop your QBO file from QuickBooks or your bank into the converter above.
Auto-convert
The tool parses all transactions from the OFX data automatically.
Download CSV
Open the CSV in Excel, Google Sheets, or import into any accounting app.
About QBO to CSV conversion
QBO files use the OFX (Open Financial Exchange) SGML format — a structured but not human-friendly format designed for machine-to-machine financial data transfer between banks and QuickBooks. While QuickBooks Online can read QBO natively, opening one directly in a text editor gives you a wall of angle-bracket tags, not a readable statement. Excel, Google Sheets, and most other accounting or budgeting software expect CSV instead.
Our converter reads every STMTTRN (Statement Transaction) block from your QBO file and extracts the date, amount, description, transaction type, and FITID into clean, one-row-per-transaction CSV columns. This makes it easy to sort, filter, pivot, and analyze your transactions in any spreadsheet without touching QuickBooks.
Common use cases: pulling bank data into a spreadsheet for a custom financial report, migrating historical transactions from QuickBooks to a different accounting platform, reconciling a bank statement line-by-line, archiving transactions in a portable non-proprietary format, or just reading what's actually in a QBO file your bank sent you.
What each CSV column contains
| CSV column | Source OFX tag | Example |
|---|---|---|
| Date | DTPOSTED | 2026-06-14 |
| Amount | TRNAMT | -42.19 |
| Description | MEMO / NAME | AMAZON MKTPLACE |
| Type | TRNTYPE | DEBIT |
| FITID | FITID | 2026061400001 |
Troubleshooting
"No transactions found in QBO file." The converter looks specifically for STMTTRN blocks. If your file is a QBO investment statement (INVSTMTTRN) rather than a bank/credit-card statement, or if the file is actually HTML from a failed download, it won't contain the tags the converter expects — open the file in a text editor to confirm it starts with OFXHEADER and contains STMTTRN tags.
Amounts show as negative when I expected positive (or vice versa). OFX convention is negative for money leaving the account (debits/checks) and positive for money coming in (deposits/credits) — this matches how QuickBooks displays them, so the CSV preserves the same sign.
Description column is empty for some rows. Some banks only populate the NAME tag and leave MEMO blank, or vice versa — the converter checks both, but if a bank omits both fields entirely for a transaction (common for internal transfers), the description stays empty.
Frequently asked questions
What is a QBO file?
A QBO file is a bank or credit card statement in OFX (Open Financial Exchange) SGML format used by QuickBooks Online. Banks generate QBO files specifically for QuickBooks' Banking > Upload transactions feature — they're not meant to be opened directly.
Why would I convert QBO to CSV?
CSV is a universal format that opens in Excel, Google Sheets, LibreOffice, and virtually every accounting or budgeting app. Converting QBO to CSV lets you analyze transactions in a spreadsheet, build custom pivot tables and reports, import into non-QuickBooks accounting software, or just read your bank data without opening QuickBooks at all.
What columns does the CSV output contain?
The converter extracts five columns from each transaction: Date (YYYY-MM-DD), Amount, Description (from the OFX MEMO or NAME tag), Type (e.g. DEBIT, CREDIT, CHECK, POS), and FITID — the bank's unique Financial Institution Transaction ID for that transaction.
Can I open the CSV in Excel?
Yes — just double-click the downloaded CSV file and it opens in Excel automatically with each field in its own column. You can also use Data > From Text/CSV for more control over date and number formatting on import.
Will the CSV work in Google Sheets or Numbers?
Yes. In Google Sheets, use File > Import > Upload and choose 'Insert new sheet.' In Apple Numbers, use File > Open and select the CSV — both parse the comma-separated format automatically.
Does this work with QFX files too?
Yes. QFX files use the same OFX SGML structure as QBO — Quicken just renames the extension. You can drop a .qfx file straight into this converter, or use our dedicated QFX to QBO converter if you need a QBO output instead of CSV.
Why are some Description or Amount fields blank in my CSV?
Not every bank populates every OFX tag. If a bank's export omits the MEMO tag, the converter falls back to the NAME tag; if both are missing, the field is blank in the CSV. This is a limitation of the source QBO file, not the converter.
Can I convert a QBO file that has hundreds of transactions?
Yes — there's no size or transaction-count limit. The whole file is parsed and converted in your browser in a fraction of a second, whether it has 10 transactions or 10,000.
Is my data safe?
Your data never leaves your browser. The conversion happens entirely in JavaScript on your device — there's no server upload, no account, and no data retention.