How to convert QBO to CSV
- Drop your QBO file on the box above, or paste its content into the text box.
- Press Convert. Every amount and date is checked; if any row cannot be read exactly, nothing is written and the rows are listed.
- Download the .csv file, or copy the text.
What is kept when you convert QBO to CSV
- One row per transaction: date, amount, type, name, memo, FITID, check number, reference, account, account type and currency.
- Amounts keep their sign (negative = money out) and exact decimals; dates are written as YYYY-MM-DD so no spreadsheet misreads them.
- Bank and credit-card statements are both read; several accounts in one file are listed together with their account number on each row.
Example
A two-transaction QBO statement becomes:
Output
Date,Amount,Type,Name,Memo,FITID,Check number,Reference,Account,Account type,Currency
2026-09-03,-45.20,DEBIT,Grocery Mart,,2026090301,,,000123456789,CHECKING,USD
2026-09-15,2500.00,CREDIT,Payroll ACME,,2026091502,,,000123456789,CHECKING,USDAbout QBO and CSV files
QBO (QuickBooks Web Connect) is OFX with Intuit’s INTU.BID bank identifier. QuickBooks Desktop and QuickBooks Online import it as a bank feed file. It opens in QuickBooks Desktop, QuickBooks Online.
CSV (comma-separated values) is a table as plain text: one row per line, fields separated by commas, and fields that contain commas, quotes or line breaks wrapped in double quotes. It opens in Excel, Google Sheets, LibreOffice, any database tool.
Good to know
- In QuickBooks, import a short test file first; once a date range is imported, re-importing it can create duplicates if the transaction IDs change.
- If a spreadsheet showed all your data in one column, the file probably uses semicolons (common in Europe); choose the delimiter instead of relying on detection.
Privacy and limits
The file is read and converted by this page in your browser; there is no upload and no account. Amounts are handled as exact decimal text, never as rounded numbers. Files up to 25 MB are accepted; a file of the wrong type or a damaged file is rejected with the reason.