How to Convert QBO to CSV: Export QuickBooks Transactions

Why Convert QBO to CSV?

You might have a QBO file and want to analyze the transactions in Excel or Google Sheets. Common reasons:

• Reconciling transactions outside of QuickBooks
• Sharing data with an accountant who prefers spreadsheets
• Migrating to a different accounting system
• Running custom analysis or pivot tables

Method 1: Export Directly from QuickBooks Online (Easiest)

If the QBO file has already been imported into QuickBooks Online, exporting to CSV is straightforward:

1. In QuickBooks Online, go to Banking > Transactions
2. Select the account you want to export
3. Click the Export icon (top right of the transactions list)
4. Choose Export to CSV
5. Open in Excel or Google Sheets

This gives you a clean CSV with Date, Description, and Amount columns.

Method 2: Open the QBO File as Text and Extract Data

A QBO file is plain text. You can open it in a text editor and parse out the transactions manually:

1. Right-click your .qbo file → Open with → Notepad or TextEdit
2. Look for <STMTTRN> blocks — each one is a transaction
3. Inside each block, find:

- <DTPOSTED> — date (format: YYYYMMDD)

- <TRNAMT> — amount (negative = debit)

- <MEMO> — description

This works for a small number of transactions, but gets tedious at scale.

Method 3: Use QuickBooks Reports

For a more structured export:

1. In QuickBooks Online, go to Reports
2. Search for "Transaction List by Date"
3. Set your date range
4. Click Export → Export to CSV

This exports all transactions (not just bank feed ones) with full account and category data.

What if You Only Have the QBO File?

If you haven't imported the QBO into QuickBooks yet and need the data as CSV:

The QBO format follows the OFX standard. Each transaction looks like this:

<STMTTRN>
  <TRNTYPE>DEBIT</TRNTYPE>
  <DTPOSTED>20260115120000</DTPOSTED>
  <TRNAMT>-125.00</TRNAMT>
  <FITID>2026011500001</FITID>
  <MEMO>Office Supplies Co</MEMO>
</STMTTRN>

You can copy/paste this data into a spreadsheet manually, or use a scripting tool (Python, etc.) to parse it.

Converting in the Other Direction: CSV to QBO

If you have a CSV and need to create a QBO file for QuickBooks Online import, our [CSV to QBO converter](/) handles that in seconds — free and unlimited.

Tips for Clean Data

• Dates: QBO stores dates as YYYYMMDD — convert to MM/DD/YYYY for Excel
• Amounts: Negative values are debits (money out), positive are credits (money in)
• Duplicates: If exporting from QuickBooks, filter by date range to avoid duplicates