QBO to CSV Converter — Open QuickBooks Files in Excel Free

Why You Can't Open QBO Files in Excel

A QBO file is QuickBooks' Web Connect format — structured markup based on OFX (Open Financial Exchange), designed for one purpose: feeding transactions directly into QuickBooks. Open one in Excel and you'll see raw SGML tags like <DTPOSTED>, <TRNAMT>, and <FITID> — not a usable spreadsheet. Excel has no native parser for this format.

Converting the QBO to CSV solves this entirely: the transaction records inside (date, amount, payee, memo, transaction ID, type) get extracted into labeled columns, one transaction per row. The result is a normal spreadsheet you can open, filter, sort, pivot and analyze anywhere — in Excel, Google Sheets, LibreOffice Calc, Numbers, or any accounting software that accepts CSV imports.

This is also faster than trying to import through QuickBooks and then export from there. A direct QBO-to-CSV conversion skips QuickBooks entirely and gives you the raw transaction data in the most portable format possible.

How to Export QBO to CSV

There are two paths to export QBO to CSV, depending on whether you have the QBO file already or need to get it from your bank or QuickBooks. Here is the complete workflow:

If you have the original bank statement PDF that the QBO was generated from, you can upload that PDF directly instead. You'll get CSV, Excel, JSON and QBO all from a single conversion, with every transaction balance-verified against the statement's running total — more formats and more validation than a QBO file alone can provide.

Export QBO from QuickBooks Online

QuickBooks Online (QBO the software) does not have a direct "Export to QBO file" menu option — the QBO file format is used for importing bank data into QuickBooks, not exporting from it. To export QBO to CSV from QuickBooks Online, you go via your bank:

1. Log in to your bank's website (Chase, Bank of America, Wells Fargo, Capital One, etc.)
2. Navigate to your account's transaction history or statement download section
3. Select the date range you want to export — most US banks allow up to 12–18 months in a single download
4. When prompted for file format, choose QuickBooks Web Connect (.qbo) or OFX
5. Download the file to your computer
6. Upload that .qbo file to this converter and download as CSV or Excel

Alternatively, if you need to export existing QuickBooks Online register data as a spreadsheet, use the Reports section in QBO: go to Reports → search "Transaction Detail by Account" or "General Ledger" → customize the date range → click Export → Export to Excel. This exports your categorized QBO ledger data, not raw bank transactions.

QuickBooks Online — Downloading Your Bank's QBO File

When banks say "QuickBooks format," they mean the Web Connect (.qbo) file. Here is what the download screen looks like at the main US banks:

• Chase: Account Activity → Download Account Activity → File type: QuickBooks (QBO)
• Bank of America: Accounts → Download → Microsoft Money / Quicken / QuickBooks → QuickBooks Web Connect
• Wells Fargo: Account Activity → Download Account Activity → QuickBooks® Web Connect
• Capital One: Transactions → Download Transactions → QuickBooks (OFX format)
• Citibank: Account Details → Download → Quicken/QuickBooks format

Export QBO from QuickBooks Desktop

QuickBooks Desktop (Pro, Premier, Enterprise) handles QBO files differently from the online version. The QBO file format is the import mechanism — you bring transactions in from your bank via QBO files. To get your QuickBooks Desktop data out as CSV, you have two paths:

Path 1 — Export a Register as CSV (Recommended)

1. Open QuickBooks Desktop and go to the Chart of Accounts (Lists menu → Chart of Accounts)
2. Double-click the bank or credit card account you want to export
3. In the register that opens, click Edit → Select All Transactions
4. Go to File → Export → Lists to IIF Files — or use Edit → Copy and paste directly into Excel
5. Alternatively: run a Transaction Detail report (Reports → Accountant & Taxes → Transaction Detail by Account), set your date range, then click Excel at the top of the report

Path 2 — Use the Bank's QBO File and Convert Directly

1. Download the QBO file from your bank (same process as above for QuickBooks Online)
2. Upload it to this converter before importing into QuickBooks Desktop
3. Download as CSV — you'll have the raw bank transactions as a spreadsheet without ever opening QuickBooks

Path 2 is especially useful when QuickBooks Desktop refuses to import a QBO file due to date range overlaps, duplicate FITIDs, or account mismatches — you can still extract the transaction data as CSV and work with it directly.

US Banks That Provide QBO Files

Almost every major US bank and credit union supports QBO/Web Connect download. Here is a quick reference showing which banks provide the format and what they call it in their download menus:

If your bank only offers OFX (not QBO by name), upload the .ofx file here — it works identically. OFX is the open standard; QBO is Intuit's version of the same format. Both are parsed the same way.

What's Inside a QBO File?

A QBO file is a plain-text file using SGML markup (similar to XML). It has two sections: a header with account and institution identifiers, and a transaction list. Here is what each field maps to in your CSV output:

One important limitation: QBO files do not contain running balances. Each transaction has a signed amount, but there is no cumulative balance column. If you need balances, convert the original bank statement PDF directly — statement PDFs carry the running balance on every row, which our converter extracts and includes in the CSV output.

Convert QBO to Excel — What Your Spreadsheet Contains

When you choose the Excel (.xlsx) output option instead of CSV, you get the same transaction data in a pre-formatted workbook that is ready to use immediately in Microsoft Excel or Google Sheets:

• Header row: Column labels — Date, Amount, Payee, Memo, Type, Transaction ID
• One row per transaction: Every transaction in the QBO file gets its own row, with each field in the correct column
• Date formatting: Dates are formatted as proper Excel date values (not text strings), so sorting and date math work correctly
• Amount formatting: Amounts are numeric values, not text — you can sum, filter and chart them immediately
• Column widths: Auto-sized for readability — no manual resizing needed

Once the Excel file is open, you can immediately add pivot tables to summarize spending by payee or category, create charts showing spending over time, apply AutoFilter to find specific transactions, use SUMIF formulas to total expenses by type, or copy the data into an existing workbook.

QBO to Excel for Accountants and Bookkeepers

Accountants frequently receive QBO files from clients who have downloaded them from their bank but do not use QuickBooks, or whose QuickBooks version is incompatible. Converting QBO to Excel lets you review transaction data immediately, identify categorization issues, and reconcile accounts without needing a QuickBooks license. The FITID column is particularly useful for spotting duplicates when a client has downloaded overlapping date ranges.

QBO to CSV vs QBO to Excel — Which Format Do You Need?

Both formats contain exactly the same transaction data. The choice depends on what you will do with the file next:

When in doubt, download CSV — it is the most universally compatible format and can always be opened in Excel. If you need Excel-specific formatting (number formats, date types, auto-sized columns), use the Excel output.

When You Need QBO to CSV — Common Scenarios

• Leaving QuickBooks: Migrating to Xero, Zoho Books, Wave, FreshBooks or any platform that imports CSV transaction history. QBO files are Intuit-specific; CSV is universal.
• Spreadsheet analysis: Pivot tables, expense breakdowns, merchant frequency analysis, monthly trend charts — all require spreadsheet data. QBO is not a spreadsheet format.
• Failed QuickBooks imports: When QuickBooks rejects a QBO file (duplicate FITID errors, date range conflicts, wrong account type), converting to CSV lets you inspect and fix individual transactions before re-importing.
• No QuickBooks license: Your bank sent a QBO file but you do not use QuickBooks. CSV opens everywhere.
• Archiving transaction history: CSV is an open, plain-text format readable without any software. QBO depends on Intuit parsing it correctly.
• Sharing with stakeholders: Sending transaction data to investors, auditors, or clients who do not have accounting software. CSV or Excel requires nothing to open.
• Reconciliation: Comparing bank transactions against internal records in a spreadsheet — filtering, sorting and VLOOKUP all work on CSV/Excel but not on QBO.

The Cleanest Path: Convert From the Original Bank Statement

QBO files are almost always generated from a bank statement. If you still have that statement PDF, consider uploading it directly to our bank statement to CSV converter instead. Here is why this approach gives you more:

• Running balances included: PDFs carry the balance after every transaction; QBO files do not. The CSV from a PDF includes a balance column.
• All output formats at once: One PDF upload gives you CSV, Excel, JSON and QBO — four formats from a single conversion
• Balance verification: The converter checks that extracted amounts match the statement's opening and closing balances, catching any parsing errors
• No bank download needed: If you already have the statement PDF from your records, you can skip the bank website entirely

Frequently Asked Questions