How to Open QBO, QFX and OFX Files Without QuickBooks or Quicken

15 April 2026 · Lars Holmström · 5 min read


You've downloaded a file from your bank and it ends in .qbo, .qfx, or .ofx. You double-click it. Nothing happens — or worse, your computer asks which program should open it. You don't have QuickBooks. You don't have Quicken. You just want to see your transactions.

This is one of the most common problems in personal and small business finance, and the fix takes about ten seconds.

What Are QBO, QFX and OFX Files?

These are all financial data formats designed for importing transactions into accounting software. They contain the same basic information — dates, descriptions, amounts, and transaction IDs — just packaged slightly differently for different programs.

OFX (Open Financial Exchange) is the open standard. Most banks generate OFX files when you download transaction history from online banking. It's an XML-based format that works with a wide range of accounting software including Xero, Sage, Wave, and MYOB.

QBO is Intuit's variant of OFX, specifically for QuickBooks. If your bank offers a “Download for QuickBooks” option, this is the file you get. It's essentially OFX with a few QuickBooks-specific fields added.

QFX is Intuit's variant for Quicken. Same idea — an OFX file with Quicken-specific extensions. Banks often label this as “Download for Quicken.”

The problem is that none of these files are human-readable. Open one in a text editor and you'll see raw XML tags and transaction codes. They're designed to be consumed by software, not by people.

How to Convert QBO to CSV

If you have a QBO file and want to see the transactions in a spreadsheet, use SanctumPDF's QBO to CSV converter. Drop your file onto the page, and it instantly parses the QBO format and shows you a clean table of transactions with dates, descriptions, amounts, and running balances.

From there, download as CSV for Excel or Google Sheets, or export to a different format if you need the data in QIF, OFX, or another accounting format.

The entire conversion runs in your browser. The file never leaves your device — nothing is uploaded to any server.

How to Convert QFX to CSV

QFX files work the same way. Since QFX is a variant of OFX, the same converter handles both formats. Drop your QFX file in, see your transactions, download as CSV.

This is especially useful if you've switched away from Quicken but still have old QFX exports you need to access. Rather than reinstalling Quicken just to read a file, convert it to CSV and open it in any spreadsheet app.

How to Convert OFX to CSV

Same tool, same process. OFX, QFX, and QBO are all variations of the same format, so the converter handles all three identically.

What If You Need to Go the Other Direction?

If you have a CSV file and need to create a QBO file for QuickBooks import, use the CSV to QBO converter. It auto-detects your columns, handles date format differences, and generates a valid QBO file with proper transaction IDs that prevent duplicates on import.

For QIF files (used by Quicken, MYOB, Reckon, and GnuCash), use the CSV to QIF converter. For OFX files (used by Xero, Sage, and Wave), use the CSV to OFX converter.

What If You Need to Edit the Transactions First?

Sometimes the raw bank data isn't clean enough to import directly. Descriptions are cryptic, categories are missing, or you need to merge data from multiple accounts before importing.

The SanctumPDF Financial Editor lets you open QBO, QFX, OFX, QIF, CSV, and Excel files directly, edit transactions inline, bulk-categorise with rules, detect duplicates across files, and export in whatever format your accounting software expects — with one-click presets for QuickBooks Online, QuickBooks Desktop, Xero, MYOB, Sage, Reckon, Wave, and GnuCash.

It's the step between “downloaded from bank” and “imported into accounting software” that most people currently do in Excel. Except it actually understands financial data, so you don't have to.

Quick Reference: Which Format Does Your Software Need?

SoftwareImport Format
QuickBooks OnlineQBO, OFX, CSV
QuickBooks DesktopQBO, IIF
Quicken (Windows)QFX, QIF
Quicken (Mac)QFX
XeroOFX, CSV
MYOBOFX, QIF, CSV
SageOFX, CSV
WaveOFX, CSV
ReckonQIF
GnuCashOFX, QIF
FreeAgentCSV

If your bank gives you one format and your software needs another, SanctumPDF converts between all of them — free, private, and browser-based.

Try It Now

Drop your QBO, QFX, or OFX file into the converter and see your transactions in seconds. No signup, no upload, no software to install.