QBO to Excel converter
Turn a QuickBooks Web Connect (.qbo) download into a proper Excel workbook: real dates you can sort and group, numbers you can sum, separate Debit and Credit columns and a File info sheet with the account, period and ending balance.
- ✓ Free, no account, no email
- ✓ Converted in memory and never stored
- ✓ Reads files from any bank or finance app
When you need to convert QBO to Excel
- You need to read or audit a bank's .qbo download without installing QuickBooks.
- You want to categorise, filter or pivot the transactions before importing them.
- A client sent .qbo files and you work in Excel.
How to convert QBO to Excel
- Drop your .qbo file on the converter (up to 5 MB).
- Check that "Convert to" says Excel.
- Click Convert: the Excel file downloads straight away. Nothing is stored.
- Open or import it: Excel, Google Sheets, Numbers, LibreOffice — Open the .xlsx. The Transactions sheet has a frozen header and filters; the File info sheet lists the account, period, totals and ending balance.
What happens to your data
- Transactions sheet: Date, Description, Amount, Debit, Credit, then Memo, Check number, Type and Transaction ID when present, with a totals row.
- File info sheet: source file, account number, account type, currency, period, number of transactions, money in, money out and the ledger balance from the file.
- Dates are true Excel dates (not text), amounts are numbers with two decimals, so formulas work immediately.
Importing the Excel file
- Excel, Google Sheets, Numbers, LibreOffice
- Open the .xlsx. The Transactions sheet has a frozen header and filters; the File info sheet lists the account, period, totals and ending balance.
What is a QBO file?
A .qbo file is a QuickBooks Web Connect file: an OFX bank file with two extra Intuit tags (INTU.BID and INTU.USERID) that QuickBooks checks before it imports. It holds one account's transactions with a posted date, signed amount, payee, memo and a unique transaction ID (FITID) per line, plus the ending balance.
What is an Excel export?
An Excel workbook with typed columns: real date cells, numbers with two decimals, separate Debit and Credit columns and a totals row, so SUM, filters and pivot tables work straight away.
QBO to Excel: questions
Is this a QBO file viewer?
Yes, in practice: the Excel output shows everything the .qbo contains in a readable layout, with no QuickBooks needed.
Can I convert the Excel file back to QBO after editing?
Save the sheet as CSV and use the CSV to QBO converter. Keep the Transaction ID column if you want QuickBooks to recognise lines it already has.
Does it handle credit card .qbo files?
Yes. Credit card statements (CCSTMTRS) convert the same way; charges are negative and payments positive.
Is the QBO to Excel converter free?
Yes. Format-to-format conversions are free and need no account. Files are converted in memory and never stored. Converting PDF bank statements is a separate tool with a free daily allowance.
Only have a PDF statement? Convert a PDF bank statement to Excel — digital or scanned, any bank.
Other converters: QBO to CSV · QBO to PDF · QBO to QFX · OFX to Excel · QFX to Excel · QIF to Excel · All file converters