Convert a QBO File to CSV

Open a QuickBooks® Web Connect (.qbo) file, preview every transaction, and download a clean UTF-8 CSV — all locally in your browser. Your file is not uploaded or stored.

01 File stays on device 02 Parsed in your browser 03 CSV downloaded by you

How it works

Read — your .qbo file is read in this browser only.
Parse — transactions, dates, and amounts are extracted into a stable table.
Preview — inspect the rows and any warnings before exporting.
Export — download a UTF-8 CSV with one click.

About the CSV format

The export is RFC 4180 CSV with a UTF-8 byte-order mark, so Excel opens it as UTF-8 by default. Fields that contain a comma, double quote, or newline are automatically quoted, and embedded quotes are doubled. Values that could be read as a spreadsheet formula are neutralized, while negative amounts stay exact. The default delimiter is a comma; rows are separated with CRLF for broad compatibility.

Opening the CSV

In Excel, use File ▸ Open and pick the .csv (do not use a text-import that changes the encoding). In Google Sheets, use File ▸ Import ▸ Upload. Apple Numbers opens it directly. If characters look wrong, confirm your spreadsheet is reading the file as UTF-8.

Supported fields & compatibility

Ledger File Lab reads the common .qbo / OFX fields used by U.S. bank downloads: STMTTRN records with TRNTYPE, DTPOSTED, TRNAMT, FITID, NAME, MEMO, CHECKNUM, and REFNUM, plus account metadata. It handles both legacy SGML-style and newer XML-style .qbo files. It does not promise compatibility with every bank, every QuickBooks version, or damaged files.

Privacy & security

Your file is processed locally in this browser. It is not uploaded or stored. No accounts, no cookies holding your data, no analytics, no error reporting. Clear the file or refresh the page and the parsed data is gone.

Common errors

Unsupported file — the content does not look like a .qbo / OFX file.
No transactions found — the file parsed but contained no transaction records.
Parsing warnings — duplicate or missing transaction IDs, unreadable dates, or recoverable structural issues. Review them before using the export.

FAQ

What is a QBO file?

A .qbo file is a QuickBooks Web Connect statement download from a bank. It uses the OFX format and contains a list of posted transactions for an account.

Is my financial file uploaded?

No. The file is read and parsed entirely inside your browser. Nothing is uploaded or stored on a server.

Which transaction fields are exported?

Posted date, transaction type, amount, FITID, name, memo, check number, reference number, account type, currency, and source format.

How do I convert a QBO file to CSV?

Open this page, choose your .qbo file, preview the transactions, then click Download .csv. The file is a UTF-8 CSV ready for Excel or Google Sheets.

Can I open the CSV in Excel or Google Sheets?

Yes. The CSV is UTF-8 with an RFC 4180 layout. Excel opens it directly; Google Sheets imports it via File ▸ Import ▸ Upload.

Does this tool import data into QuickBooks?

No. It only reads a .qbo file for export to CSV/Excel. It does not connect to QuickBooks or import anything.

Ledger File Lab is not affiliated with, endorsed by, or sponsored by Intuit Inc. Review the preview and verify the exported transactions before using them in accounting workflows.