Convert QBO to CSV
Export QuickBooks
transactions.
Free QBO to CSV converter. Upload any .qbo or .ofx file and download a clean spreadsheet with every transaction — date, amount, payee, memo and reference. Runs entirely in your browser. Your financial data never leaves your device.
Three steps to open QuickBooks transactions in Excel or Google Sheets.
Drop your .qbo, .ofx or .qfx file. CSVShift reads the OFX data — both SGML-style (most QuickBooks bank feeds) and XML-style — and counts the transactions automatically before you convert.
Choose your preferred date format (ISO, US or European), whether amounts appear in a single signed column or split into separate Debit and Credit columns, and the output delimiter for the CSV file.
Download the CSV and open it directly in Excel, Google Sheets or any accounting tool. The file includes account metadata (account number, bank ID, currency, closing balance) as comment rows at the top.
Understanding QBO files before exporting your transaction data.
A QBO file is an OFX (Open Financial Exchange) file — a structured format designed for machine-to-machine exchange of financial data between banks and accounting software. It is excellent for importing into QuickBooks but nearly impossible to read, analyze or edit without specialized software.
OFX files come in two variants. SGML-style OFX (used by most bank feeds and older QuickBooks exports) uses tag-value pairs without closing tags — similar to HTML but simpler. XML-style OFX uses proper opening and closing tags and is more common in newer bank exports. CSVShift handles both automatically.
Converting QBO to CSV gives you the transaction data in a format that works in Excel, Google Sheets, Power BI, Python and any other tool you use for analysis, reporting or reconciliation. Every field — date, type, payee, memo, amount, reference number and transaction ID — becomes a column in the output spreadsheet.
Common situations where opening a QBO file as a spreadsheet solves the problem.
QuickBooks reporting is powerful but sometimes you need raw transaction data in a spreadsheet for custom analysis — pivot tables, VLOOKUP matching, conditional formatting or charts. Converting QBO to CSV gives you the raw data to work with.
Moving from QuickBooks to Xero, FreshBooks or Wave? Export your transaction history as QBO, convert to CSV here, and use the CSV to import historical data into the new system — preserving dates, amounts and descriptions.
Auditors and bookkeepers often need to verify transaction lists outside of QuickBooks. Exporting as CSV produces a flat, verifiable file that can be compared against bank statements, invoices or other records in a spreadsheet.
If you build financial dashboards in Power BI, Tableau or Google Data Studio, you need raw transaction data as CSV or TSV. Converting the QBO bank feed to CSV is the first step in any custom financial reporting workflow.
Choosing the right format for your workflow.
| Option | Values | When to use it |
|---|---|---|
| Date format | ISO · US · EU · Dot | ISO (2024-01-15) is the safest — universally recognized and sorts correctly. US (01/15/2024) for Excel files used in the US. EU (15/01/2024) or Dot (15.01.2024) for European locale systems. |
| Amount columns | Signed · Split · Absolute | Signed uses one column with negative values for debits — easiest for formulas and SUM calculations. Split creates separate Debit and Credit columns — matches the format used by most banks in their own CSV exports. Absolute removes the sign — useful when the Type column already identifies direction. |
| Output delimiter | Comma · Tab · Semicolon | Comma for standard CSV. Tab for TSV used in data pipelines and database imports. Semicolon for European locales where Excel uses semicolons as the list separator. |
Other free converters on CSVShift you might need.
Financial data handled
with full privacy.
QBO files contain sensitive financial data — account numbers, transaction history, balances. CSVShift parses the entire file in your browser using JavaScript. Nothing is uploaded, nothing is stored, and nothing is transmitted. Your data stays on your device from start to finish.
Open your browser's Network inspector during conversion and you will see zero outbound data requests. The only network activity is loading the page itself — not your financial data.