QBO to CSV Converter
Open your QuickBooks Web Connect file as a clean spreadsheet - dates, payees, debits, credits and a running balance.
Drop your file here, or click to choose
Accepts .qbo, .qfx and .ofx - up to 15 MB
What a .qbo file actually is
A .qbo file is QuickBooks' Web Connect format, and it was never meant for you to read. It is built for one thing: importing into QuickBooks. Open it in a text editor and you will see a wall of tags. Open it in Excel and everything crams into a single useless column. The data you want is in there — it is just locked inside a format designed for software, not people.
Most of the time that is fine, because you are importing it straight into QuickBooks anyway. But not always. Sometimes you do not want it in QuickBooks at all — you want the transactions in a plain spreadsheet so you can reconcile them, filter them, check something against another record, or hand them to someone who lives in Excel and does not touch accounting software. That is where a converter helps.
What this converter does
It reads your .qbo file the same way QuickBooks does, then writes out an ordinary CSV that opens cleanly in Excel or Google Sheets. You get one row per transaction, with everything sorted into its own column:
- The date
- The payee
- The memo or description
- The transaction type
- The amount, split into separate debit and credit columns
- The cheque number, where the file includes one
- A running balance, anchored to the closing balance the file itself declares
So instead of a tangle of tags, you get a clean, readable list of transactions you can actually work with.
It handles Quicken files too. .qfx (Quicken) and plain .ofx files use the same underlying format, so they convert here the same way — no separate tool needed.
Two things that are easy to get wrong
Plenty of generic converters exist, and most of them cut corners in ways that quietly corrupt your data. Two details in particular are handled properly here.
Descriptions do not end in columns and start again in other columns
If the payee or memo has a comma or a quotation mark in it, a slapdash converter allows the character to disrupt the CSV structure, causing part of the description to fall into the wrong column, and everything following the part to lose its column alignment. In this place those fields are correctly quoted as per RFC 4180, meaning that a description containing a comma remains in one cell.
You don't need to worry about your spreadsheet working against you
This is a very real risk that most people don't consider. If the transaction description begins with an Excel formula-starting character, a CSV open can cause the formula to be executed. This is known as the CSV injection attack — a concern if you receive the file from a bank statement that you did not create. Any field of that type will be neutralized prior to reaching your spreadsheet file; therefore, opening the file is safe.
This is as elementary as it gets: a .qbo, .qfx or .ofx file is entered and a clean and correct safe-to-open CSV is generated to reconcile, filter, or share.
How it works
- 1
Upload your QBO file
Drop in a .qbo, .qfx or .ofx file downloaded from your bank or exported for QuickBooks.
- 2
We read every transaction
Dates, payees, memos, amounts, cheque numbers and the declared balances - both the SGML and XML dialects of the format.
- 3
Download your CSV
Opens cleanly in Excel, Google Sheets or Numbers, with debits and credits in separate columns. Your file and the CSV we generate are erased automatically - we never keep them.
What it handles
Excel-ready columns
Date, description, type, debit, credit, amount, balance, reference and cheque number - properly quoted so commas in payee names never break a row.
Formula injection neutralised
Cells that would execute as formulas in Excel are escaped, so a malicious payee name cannot run code on your machine.
Running balance
Anchored to the closing balance the file declares, so the last row matches your bank. Omitted rather than invented when the file has none.
QBO, QFX and OFX
All three are flavours of the same format, and all three convert here - you do not need to know which one your bank gave you.
How this compares to other QBO converters
A QBO file is written for QuickBooks, so most tools either import it or tip it out as-is. A spreadsheet you can rely on needs a bit more care than that.
| Feature | Bank Statement Magic | Typical free online converter | Opening it in QuickBooks |
|---|---|---|---|
| Takes .qbo, .qfx and .ofx | Yes | Varies | No |
| Commas and quote marks inside descriptions quoted to RFC 4180 | Yes | No | Not applicable |
| A cell starting with = or + cannot run as a formula in Excel | Yes | No | Not applicable |
| Debit and credit kept in separate columns | Yes | No | Varies |
| Running balance when the file gives a closing balance | Yes | No | Yes |
| Balance column left out rather than guessed at | Yes | No | Not applicable |
| Opens in Excel, Google Sheets and LibreOffice | Yes | Yes | No |
| No QuickBooks subscription needed | Yes | Yes | No |
| Nothing to install | Yes | Yes | No |
| Uploads removed automatically | Yes | Varies | Not applicable |
| Cost | Free daily allowance | Free | Paid subscription |
Frequently asked questions
- Why is a CSV more use to me than the QBO file?
- Because you can actually read a CSV. A QBO file is not meant for you to read — it is meant for QuickBooks to read. The moment you need to check a figure, send a number to a client or reconcile in a spreadsheet, you need columns. That is what this is for.
- What is a .qbo file?
- It is QuickBooks Web Connect format, built by Intuit. It is the file your bank gives you when you pick the QuickBooks download option. All the dates, payees, amounts and balances are in there — they are just wrapped in tags, because the file was written to be read by software.
- I opened it in Excel and got one long column. Why?
- Excel does not know what a QBO file is. It treats it as plain text and drops the whole thing into column A. Nothing is broken and nothing is lost — the data simply has not been separated into columns. Put it through here and you get date, payee, debit, credit and balance where they belong.
- Does it read QFX and OFX files too?
- Yes, all three. QFX is Quicken's version and OFX is the open standard the other two are built on. Banks are not consistent about which they hand out, and some still use the older SGML style while newer ones use XML. Upload whichever you have.
- Will it open in Google Sheets?
- Yes, and in Excel, LibreOffice and Numbers. The output is standard RFC 4180 CSV with a UTF-8 byte-order mark, which is the part most converters skip. Skip it and accented names come out mangled. Yours will not.
- Are the debits and credits split into separate columns?
- Yes. You get the signed amount, plus separate debit and credit columns, because that is the layout most bookkeeping software expects on import. It saves you splitting them by hand afterwards.
- What does it cost?
- Converting a file is free within a daily allowance. Without an account you get 5 pages a day across 2 files; with a free account, 15 pages a day across 5 files. A file counts as one page for every 40 transactions, so an ordinary month of banking is a single page. Paid plans start at $10 a month — ₹799 in India — for 600 pages, which is around 24,000 transactions. Full prices are on the pricing page.
- How long do you keep my file?
- Your QBO file and the CSV we build from it are wiped from our servers and our database automatically. We do not share them with anyone.
Convert your QBO file now
Upload a .qbo, .qfx or .ofx file and get a clean CSV back.