QBO to CSV Converter
Open the QBO (QuickBooks Web Connect) file from your bank and save its transactions as CSV or Excel.
Drop your bank file here or choose a file
QBO, QFX or OFX · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert QBO to CSV
- Find the QBO file QBO files come from your bank's website, usually from a "Download to QuickBooks" or "Web Connect" option. They are often in your Downloads folder.
- Drop it into the converter Choose the file or drag it onto the box above. QFX and OFX files work too.
- Check the transactions The table shows the date, description and amount of every transaction. Fix or delete rows if you need to. If the file holds more than one account, pick the account.
- Choose CSV or Excel Pick one Amount column (minus for money out) or separate Money out and Money in columns, and the date format you want.
- Download Click Download CSV file (or Excel). The file is saved straight to your computer.
How to open the CSV in a spreadsheet
Microsoft Excel
- Open the file Double-click the downloaded CSV, or choose File › Open in Excel.
- Use the Excel download for numbers If you plan to sort and total, download Excel instead; dates and amounts are then real date and number cells.
Google Sheets
- Import the file In a new sheet, choose File › Import › Upload and pick the file.
- Keep the defaults Comma separator, and let Sheets convert dates and numbers.
Why convert QBO to CSV
A QBO file is built for QuickBooks, not for people: the transactions sit inside tagged text that spreadsheets can’t open. A QBO to CSV converter pulls out the date, description, amount, memo and check number of each transaction and writes them as rows and columns. Use it to check a bank download before you import it, to send transactions to a bookkeeper, to fix a file QuickBooks rejected, or to move the data to another program.
What you get in the CSV
Each row is one transaction with these columns: Date, Description, Amount (or Money out and Money in), Memo and Check number. Amounts use a dot for cents and a minus sign for money out, with no currency symbols, so any spreadsheet reads them as numbers.
Check a bank download before importing
Converting a QBO file to Excel is a quick way to compare it with your bank statement before QuickBooks sees it: filter by date, total the money in and out, and look for transactions you don’t recognize. The checklist above the download button already shows the count, the date range and the totals.
Supported banks and file layouts
QBO, QFX, OFX and QIF files from any bank
The reader handles both forms of OFX (the older SGML form used by QBO and QFX files, and the newer XML form), bank and credit card statements, and files that hold more than one account. QIF files from Quicken and other apps are read too, including Quicken's old date styles.
Any bank's CSV or Excel file
The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.
Common problems and fixes
- The converter says the file is not a QBO file
- Some downloads named .qbo are really CSV or HTML pages saved by mistake. Open the file in a text editor: a real QBO file starts with lines like "OFXHEADER:100" or "<OFX>". If it is a CSV, the CSV to QBO converter reads it directly.
- The file has more than one account
- The converter lists every account in the file. Choose one, download, then choose the next.
- Names are cut off
- QBO files usually store a short name for each transaction. The full text, if your bank sent it, is often in the memo column; the CSV includes both.
- I need the file for QuickBooks Online instead
- Choose QuickBooks Online CSV before you download. It writes the column layout QuickBooks Online's bank upload accepts. See the QuickBooks Online CSV formatter.
- Accented letters look wrong in Excel
- Download Excel, or open the CSV with Excel's Data › From Text/CSV and choose UTF-8.
QBO vs CSV
| QBO | CSV | |
|---|---|---|
| Made for | QuickBooks (Web Connect import) | Any spreadsheet or app |
| Opens in Excel | No | Yes |
| Holds account details | Yes: account type, account number and bank ID | No, unless you add columns |
| Transaction IDs | Yes, one per transaction | Only if you add a column |
| Easy to read and edit | No: tagged text | Yes: rows and columns |
Frequently asked questions
How do I convert QBO to CSV?
Drop the QBO file into the QBO to CSV converter above, check the transactions, choose CSV and download. It takes less than a minute.
Can I open a QBO file in Excel?
Not directly. Excel doesn't read the QBO format. Convert it to CSV or Excel here first, then open it in Excel.
Can I open a QBO file without QuickBooks?
Yes. This converter shows every transaction in the file and saves them as CSV or Excel. You don't need QuickBooks.
Does it work with QFX and OFX files?
Yes. QBO, QFX and OFX files share the same OFX structure, so the converter reads all of them, from any bank.
Is my file uploaded anywhere?
No. Your QBO file is read by your own browser and never leaves your computer. Nothing is stored.
Can I convert CSV back to QBO?
Yes, with the CSV to QBO converter on the home page.
Related tools
Last updated · EmproIT