Convert QBO to Excel
Free QBO to Excel converter. Turn a .qbo bank download into an .xlsx workbook with one row per transaction. Runs in your browser, no upload.
Coming soon: QBO to Excel
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 Excel
Web Connect files are written for accounting software, not for people. Open a .qbo download in Excel and you get a wall of tags — OFXHEADER, STMTTRN, TRNAMT — one per line, with the numbers you want buried in the middle. Converting QBO to Excel turns that document into a workbook: a header row, then one row per transaction with the date, description, amount, memo and check number in their own columns.
An .xlsx file is the better target when the next step is human review. Excel keeps dates as dates instead of guessing at them, keeps long payee names readable, and keeps leading zeros in check numbers, all of which a plain CSV can mangle depending on your regional settings. Once the statement is a workbook you can filter by payee, subtotal by month, mark up the rows you have questions about, and send it to a client who will never know what a Web Connect file is.
Bookkeepers use this when a bank hands out .qbo downloads but the engagement runs on spreadsheets, when a client's import failed and someone has to look at what was actually in the file, or when transactions must be coded before they reach the ledger.
Nothing is uploaded. The workbook is built by your browser from the file on your own disk, so an account statement stays where it belongs. QBO reading is the next piece being built; the converter below already goes the other way, turning Excel and CSV statements into .qbo files.
How to convert QBO to Excel
- Find the .qbo file — usually in your downloads folder, or attached to an email from a client.
- Drop it into the converter once QBO reading ships; right now the same box converts .xlsx and .csv files into .qbo.
- Look over the preview: row count, date range, totals in and out.
- Download the .xlsx workbook and open it in Excel, Numbers or Google Sheets.
- Code or clean the rows, then convert the sheet back to .qbo when it is ready to import.
Frequently asked questions
- Will the dates come through as real dates in Excel?
- Yes. Dates are written as spreadsheet date values rather than text, so sorting and month grouping work without reformatting the column.
- What is the difference between the Excel and CSV output?
- The data is the same. Excel preserves types, so dates stay dates and check numbers keep their leading zeros; CSV is better if the file feeds another program.
- Do I need Excel installed?
- No. The .xlsx file opens in Google Sheets, LibreOffice and Numbers as well.
- Is the converter free for large statements?
- Yes, with no row limit. Only the QuickBooks Online import itself caps out, at 1,000 transactions per upload.
- Is my statement sent to your server?
- It is not. Everything happens inside the browser tab, and nothing is stored after you close it.