Convert QBO to CSV
Free QBO to CSV converter. Turn a .qbo bank file into a spreadsheet you can open in Excel, Google Sheets or Numbers. Private: nothing is uploaded.
Coming soon: QBO to CSV
Reading that format is still being built. The converter below already turns CSV and Excel statements into a QuickBooks .qbo file, which covers most of the same work.
Drop a CSV or Excel statement here
.csv, .txt, .xlsx and .xls — or choose a file
Your file never leaves your browser.
About QBO to CSV
A .QBO file looks like gibberish when you double-click it, because it is not a spreadsheet at all. It is an OFX document: plain text wrapped in SGML tags, written for software to read rather than people. Excel opens it as one long column of angle brackets, which is why so many people end up searching for a way to open a QBO file in Excel.
Converting QBO to CSV unpacks that document into the five columns you actually want: date, description, amount, memo and check number. One row per transaction, dates in a format your spreadsheet recognises, amounts as signed numbers so that sums and pivot tables work without a cleanup pass. Once it is a CSV you can sort it, filter it, hand it to a client, reconcile it against a bookkeeping file, or re-import it somewhere that does not speak Web Connect.
Accountants reach for this when a bank only offers Web Connect downloads, when a client emails a .qbo file instead of a statement, or when a batch of transactions has to be reviewed before it touches the books. Bookkeepers reach for it when an import went wrong and they need to see exactly what was in the file.
This conversion runs in your browser with no upload, so a statement full of account numbers stays on your machine. QBO reading is the next thing being built; the converter below currently handles the opposite direction, CSV and Excel into .qbo, so you can go back once your spreadsheet is clean.
How to convert QBO to CSV
- Get the .qbo file from your bank's download page or from whoever sent it to you.
- Drop it into the converter once QBO reading ships; today the same box converts CSV and Excel files into .qbo.
- Review the parsed transactions: date range, number of rows, money in and money out.
- Download the CSV and open it in Excel, Google Sheets or Numbers.
- Clean up the descriptions if you need to, then convert back to .qbo for import.
Frequently asked questions
- Why can't I just open a .qbo file in Excel?
- Because it is an OFX document, not a table. Excel shows the raw tags instead of rows and columns, so the file has to be parsed into a spreadsheet layout first.
- Which columns does the CSV have?
- Date, description, amount, memo and check number — the fields a .qbo file actually carries. Amounts stay signed, so money out is negative.
- Is this the same as exporting transactions from QuickBooks Online?
- No. This converts a .qbo file you already have. Exporting the register out of QuickBooks Online is done inside that product, under the reports screen.
- Does the converter keep a copy of my file?
- No. It runs in your browser and keeps nothing. Close the tab and the data is gone.
- Can I convert the CSV back into a .qbo file afterwards?
- Yes, and that direction works today: drop the spreadsheet into the converter on this page and download a fresh .qbo.