Convert QBO to CSV
Planned: turning a .qbo bank file into a CSV spreadsheet. Not built yet, nothing can be uploaded for it. CSV, Excel, QFX and OFX to .qbo work now.
Not built yet: QBO to CSV
QBO to CSV is planned and does not work yet; nothing can be uploaded for it. The box below converts CSV and Excel statements into a QuickBooks .qbo file.
Want to hear when QBO to CSV ships? Email zebinpan08@gmail.com.
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
QBO to CSV conversion is not built yet, and nothing can be uploaded for it on this page. The box below converts in the other direction: CSV and Excel statements into a .qbo file. Email the maintainer if you want to hear when QBO to CSV ships.
When it is built, a QBO to CSV converter will read the OFX transaction list inside a .qbo file and write one row per transaction: date, description, amount, memo and check number. Dates will be in a format a spreadsheet recognises and amounts will be signed numbers, so sums and pivot tables work without a cleanup pass. The result would open in Excel, Google Sheets or Numbers, where you could sort it, filter it, hand it to a client or reconcile it against a bookkeeping file.
People ask 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 want it when an import went wrong and they need to see exactly what was in the file. Until it exists, a .qbo file is plain text: opening it in a text editor shows every transaction between STMTTRN tags, which is enough to check a few rows by hand.
The plan is for this conversion to run in the browser with no upload, like the converters that work today, so a statement full of account numbers would stay on your machine. Today the site converts CSV, Excel, QFX and OFX files into .qbo, and nothing else.
How to convert QBO to CSV
- This direction is not built, so there is nothing to do here yet.
- When it ships, you will drop a .qbo file into the converter and get a CSV with one row per transaction.
- Today the box below only converts CSV and Excel statements into .qbo.
Frequently asked questions
- Can I convert a .qbo file to CSV here?
- Not yet. QBO to CSV is planned and not built. The converter on this page only goes from CSV and Excel to .qbo.
- 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 will the CSV have?
- The plan is date, description, amount, memo and check number — the fields a .qbo file carries — with signed amounts, so money out is negative.
- Is this the same as exporting transactions from QuickBooks Online?
- No. This page is about a .qbo file you already have. Exporting the register out of QuickBooks Online is done inside that product, under the reports screen.
- Can I convert a CSV into a .qbo file?
- Yes, that direction works today: drop the spreadsheet into the converter on this page and download a .qbo.
You can also convert
Guides by bank
Last updated .