Export QuickBooks Transactions to Excel: 3 Ways to Get QBO Data into a Spreadsheet

Getting QuickBooks transactions into a spreadsheet is one of those tasks with three different right answers, depending on where your data currently lives. If the transactions are already inside QuickBooks Online, you never need a converter — QuickBooks exports CSV natively. If you have a raw .qbo file sitting in your downloads folder that you haven't imported yet, you need a different approach entirely.

This guide covers all three, starting with the one most people actually need.

Which method do you need?

Method 1: Export from Banking (fastest, bank data only)

If the QBO file has already been imported into QuickBooks Online, the transactions are sitting in your bank feed and QuickBooks will hand them over as CSV directly:

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

This gives you a clean CSV with Date, Description, and Amount columns. What it does not give you is any of the categorisation work QuickBooks has done — for that, use Method 2.

Method 2: The Transaction List report (adds categories and accounts)

The Banking export only covers the bank feed. The Reports module exports everything, including the chart-of-accounts categories assigned during reconciliation:

1. Go to Reports
2. Search for Transaction List by Date
3. Set your date range
4. Click Export > Export to CSV

Use this one when you're handing data to an accountant or migrating to another accounting system — the extra account and category columns are usually the whole point of the export.

Method 3: Convert a raw QBO file you never imported

If the .qbo file came straight from your bank and was never imported into QuickBooks, neither of the above applies — there's nothing in QuickBooks to export. A QBO file is OFX (Open Financial Exchange) data in SGML format: readable by QuickBooks, but not by Excel.

The [QBO to CSV converter](/qbo-to-csv) on this site parses the file in your browser and hands back a spreadsheet-ready CSV. No software, no signup, and the file never leaves your device.

What ends up in the CSV

Doing it by hand instead

A QBO file is plain text, so for a handful of transactions you can skip the converter entirely. Open the file in Notepad or TextEdit and look for <STMTTRN> blocks — each one is a single transaction:

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

This is fine for ten transactions and miserable for a thousand.

Getting a QBO file from your bank in the first place

Most major banks still offer QuickBooks-format downloads:

1. Log in to your bank's website
2. Go to Account Activity or Statements
3. Click Download or Export
4. Choose QuickBooks (QBO) or OFX
5. Pick your date range and download

Chase, Bank of America, Wells Fargo, Citi, US Bank, TD Bank, PNC, and Capital One all support this. If yours only offers CSV, you already have the spreadsheet format — use the CSV directly, or run it through the [CSV to QBO converter](/) if what you actually needed was a QuickBooks import file.

Opening the CSV cleanly in Excel

1. Open Excel, then File > Open and select the CSV
2. If amounts land as text rather than numbers, select the column and use Data > Text to Columns > Delimited > Comma
3. Fix dates by selecting the column and choosing Format Cells > Date > MM/DD/YYYY

In Google Sheets, drag the CSV into a new sheet and it parses automatically.

Things that trip people up

• Dates come out as YYYYMMDD. That's how OFX stores them internally. Convert to MM/DD/YYYY before Excel will treat them as real dates.
• Every amount looks negative. OFX convention: negative is money leaving the account, positive is money arriving. It matches how QuickBooks displays them.
• Duplicate rows after exporting. Usually an overlapping date range across two exports — filter by date before exporting rather than deduplicating afterwards.
• The CSV is empty. Some QBO files carry only account metadata with no <STMTTRN> records at all. Open the file in a text editor to confirm transactions are actually in there.

Frequently asked questions

Is the converter really free?

Yes — free and unlimited, no signup, no trial, no row cap.

Does my QBO file get uploaded to a server?

No. Conversion runs entirely in your browser in JavaScript, so your financial data never leaves your device.

Can I convert several QBO files?

Yes, one after another. There's no daily limit.

Can I go the other way, from CSV back to QBO?

Yes — that's the [CSV to QBO converter](/), which builds a QuickBooks-importable file from any bank's CSV export.