Convert a QBO file to Excel
Open a QuickBooks Web Connect (.qbo) file as a real spreadsheet: dates as dates, amounts as numbers, one row per transaction.
- Runs in your browser. The file is never uploaded.
- Free for 10 files a day. No account.
- Also writes CSV, QBO, QFX, OFX, QIF, IIF, PDF.
- Nothing is uploaded: the file stays on your computer
- Free for 10 files a day, no account
- Every output format from the same screen
You've used today's 10 free conversions
Plans from $19 a month include unlimited file conversions and 40 PDF statements. See plans, or come back tomorrow.
Click a date, description or amount to fix it before you download.
| Date | Description | Amount | Balance | Row actions |
|---|
Why QBO to Excel
A .qbo file is plain text in OFX's SGML dialect, so Excel can't open it and QuickBooks only lets you import it, not read it. When you need to review a bank download before importing, hand it to a client, or build a reconciliation, you want the transactions in a sheet. Unclip reads every STMTTRN block and writes a workbook with a frozen header row and a filter.
What you get in the workbook
- Columns: Date, Description, Amount, Debit, Credit, Check number and Memo. The amount is signed; debit and credit are split for tools that want them apart.
- Dates are real Excel dates and amounts are numbers, so SUM, SUMIF and pivot tables work straight away.
- The header row is frozen and has a filter, so long downloads are easy to scan.
- Need CSV instead? Choose CSV under Other formats after converting. QFX and OFX files are accepted as input too.
How the conversion works
1. Read
Every STMTTRN block is read: date posted, amount, payee, memo, check number and the bank's transaction ID. OFX 1 (SGML) and OFX 2 (XML) both work, as do credit card files.
2. Check
Rows without a readable date and amount are counted and reported, never silently dropped. Totals in and out and the period are shown so you can compare them with the source before importing.
3. Write
A real .xlsx workbook: Excel dates, numeric amounts, a frozen header row and a filter. No add-ins needed.
Starting from a PDF statement? The statement converter reads it and checks every row against the printed balance.
Related converters
Questions
Can I open a .qbo file in Excel directly?
Excel will show the raw tags on one column if you rename it to .txt. To get a proper table you need to parse the OFX structure, which is what this converter does.
Does this work with QFX and OFX files too?
Yes. QBO, QFX and OFX share the same structure; only the Intuit header tags differ.
Are transaction IDs kept?
They're used to order and de-duplicate rows. If you need the FITID column itself, write to us and we'll add it.