Which "QBO" do you have?
People use QBO for two different things, so it is worth checking before you start.
- A file ending in .qbo. Banks offer these on their download page, usually labelled "QuickBooks" or "Web Connect". This tool opens them.
- QuickBooks Online, the accounting service. If you want to get data out of your QuickBooks Online company, use the export option in QuickBooks Online itself: most of its reports can be saved as Excel files from the report screen. Once you have that file, you do not need a converter.
What is inside a .qbo file
A .qbo file is a bank statement in the OFX format, with an extra Intuit bank ID that QuickBooks uses to recognise the bank. Each transaction has a posting date, an amount, a payee name, often a memo and a check number, and a unique transaction ID. The file is plain text, but the tags make it hard to read or total by eye. As a spreadsheet, you can sort, filter and add it up in seconds.
How to convert a QBO file to CSV
- Download the .qbo file from your bank, or find the one you saved earlier.
- Drop it into step 1. You can add several files at once, for example one per month.
- In step 2, pick the date style and whether amounts go in one column or in separate money out and money in columns. Tick the extra columns you want.
- Check the totals in step 3 against your statement, then download an Excel file or a CSV.
Why people turn QBO files into spreadsheets
- To look before importing. See exactly what the bank sent before it reaches your books.
- To send to an accountant or client who works in Excel or Google Sheets rather than QuickBooks.
- To combine months. Drop in several downloads and get one sorted list. When downloads overlap, transactions with the same ID are listed once.
- To keep a readable archive. A spreadsheet will still open in years to come, whatever software you use then.
What the spreadsheet looks like
The Excel file has real dates and numbers, so sorting and totals work straight away, and the header row stays in view as you scroll. The CSV opens in any spreadsheet app. Choose one amount column with money out as negative, or two columns for money out and money in, whichever your next step expects. The transaction ID column is there if you need to trace a line back to the bank's file.
Questions
Is my file uploaded?
No. The file is read by JavaScript in this browser tab and the spreadsheet is built on your device.
Can I convert several QBO files into one spreadsheet?
Yes. Drop them in together. Transactions are sorted by date, and repeats from overlapping downloads are removed using each transaction's ID.
Does it read QFX and OFX files too?
Yes. QBO, QFX and OFX files share the same structure, so this tool reads all three, and QIF files as well.
Will the bank file be changed?
No. The tool only reads it. Your original .qbo file stays exactly as it was.
Can I turn the spreadsheet back into a QBO file?
Yes, with the CSV to QBO converter. It is useful when you have edited or combined transactions in a spreadsheet and want to import them into QuickBooks.
Check for yourself that nothing is uploaded
- Open this page, then turn off Wi-Fi or switch on airplane mode.
- Drop your file into the tool and convert it. It still works, because the conversion runs in your browser, not on a server.
- For a closer look, open your browser's developer tools and watch the Network tab while you choose a file. No request carries your file anywhere.
The tools work in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.
Last reviewed November 11, 2026. Found a bank export this tool reads wrongly? Tell us about the layout and we will look at it.