Turn a QBO File into an Excel Sheet
A .qbo download is a bank file meant to be imported into bookkeeping software, but sometimes you just want to look at it, total it or send it to someone who works in Excel. Converting it to an XLSX workbook gives you a normal grid with one transaction per row.
Your file is never uploaded. The OFX, QFX and QBO converter runs in your browser and makes no network requests while it works. Always review the rows before you use them.
Steps
- Save the .qbo file from your bank's download page.
- Drop it on the OFX to CSV tool; QBO uses the same internal layout as OFX.
- Set Format to Excel (XLSX).
- Press Download and open the workbook.
- Add a total under the Amount column and compare it with the change between opening and closing balance on your statement.
Good to know
Number cells, not text
In the XLSX download every amount is a real number, so formulas, pivot tables and currency formatting work without any cleanup. In a CSV, the program you open it with decides how to read each value.
Check numbers
When the bank records a check number, it lands in its own Check number column, which makes it easy to tick off written checks against your own register.
This is a read-only copy
Editing the workbook does not change the QBO file. If you need to send corrected data back into bookkeeping software, the reverse tool on this site builds a new file from a CSV.
Questions
Why does a QBO file show an error in some programs?
Some importers check for a specific bank ID inside the file. Reading it here does not depend on that ID.
Can I get CSV instead?
Yes. The same download menu offers CSV and Excel.
Are multiple months supported?
A single QBO file can span any date range your bank allows; every transaction in it becomes a row.
Have bank statements as PDFs instead? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.