QBO to CSV Converter
Open a bank's .qbo download as a plain CSV: date, description, amount, memo, check number and transaction ID, ready for Excel, Google Sheets, Xero or a CSV import.
- Upload
- Check
- Download
Drop your .qbo or .ofx or .qfx file here
or choose a file
Files are processed in your browser and never uploaded.
Only have a PDF statement? Convert PDF to QBO →
How to import the file
Open the CSV
- 1Download the .csv file.
- 2Open it in Excel, Google Sheets (File > Import) or Numbers.
- 3Dates and amounts are ready to sort, filter and total.
Back into QuickBooks Online
- 1Go to Transactions > Bank transactions, open the Link account menu and choose Upload from file.
- 2Upload the CSV, choose the account, and map Date, Description and Amount (or Debit and Credit).
- 3Review the transactions under For review.
Questions
How do I open a QBO file in Excel?
Excel cannot open .qbo files directly. Convert the file to CSV here, then open the CSV in Excel. If you want a formatted spreadsheet, use the QBO to Excel converter instead.
Can I get separate debit and credit columns?
Yes. Turn on "Separate Debit and Credit columns" before downloading. Otherwise you get one Amount column with negative numbers for money out.
Which date format will the CSV use?
MM/DD/YYYY by default. You can switch to DD/MM/YYYY or YYYY-MM-DD before downloading.
Does this work with OFX and QFX files too?
Yes. QBO, OFX and QFX share the same format, so any of them converts to CSV here.
Is the QBO file uploaded to your server?
No. The conversion runs in your browser and your file stays on your computer.
More free converters
Have PDF bank statements?
Extract transactions from PDF statements, checked against the statement balances.