Bank files · Runs in your browser

Open a QBO file as CSV in your spreadsheet.

A QBO file is a text file that spreadsheets cannot read. This page reads it, shows who it claims to be from, and writes a CSV you can open in Excel or Sheets. The file stays on your device.

How to turn a QBO file into a CSV

  1. Choose the .qbo, .qfx or .ofx file, or paste its text. The page reads the header and shows the institution block.
  2. If the file holds several accounts, choose one or keep “All accounts”.
  3. Choose a layout. The full layout is for inspection and bookkeeping. The 3-column and 4-column layouts match what QuickBooks Online accepts for a manual CSV upload.
  4. Choose how dates are written, and download. ISO dates (2024-03-31) cannot be misread by a spreadsheet set to another country.

Why a QBO file does not open as a spreadsheet

A QBO file is plain text in the Open Financial Exchange format. It begins with header lines such as OFXHEADER:100 and VERSION:102, then nested elements for the sign-on, the account and each transaction. Value elements in this older SGML form have no closing tag, so a general XML reader fails on them too. The open-source ofxtools project documents the same split: it reads both OFX 1.x (SGML) and 2.x (XML), and treats the Intuit-specific INTU tags as extensions it can drop. This page does the equivalent in JavaScript, tolerating missing closing tags and reporting any structural trouble it finds as a warning rather than stopping.

What you get in each layout

  • Full. Account, account type, currency, date, signed amount, transaction type, name, memo, check number and the FITID, one line per transaction, across the statements you picked.
  • 3-column. Date, Description, Amount. The description is the payee name (or the payee element if the file uses that instead).
  • 4-column. Date, Description, Credit, Debit, with zero left blank, as Intuit asks.
  • 3-column plus. The 3-column layout with the memo, check number and transaction ID added for matching later.

Reading the date and the amount

An OFX date is written YYYYMMDD, optionally followed by a time and a bracketed time zone. The CSV uses the calendar date as written in the file and does not apply the time zone, so a transaction stamped late evening in a western zone is not moved to the next day. Amounts are converted with whole-cent arithmetic. A comma used as the decimal mark in a file is read, and flagged in the validator, because many importers expect a period.

Worked example

For the sample file produced on the CSV to QBO page, the three transactions come out in the 4-column layout as:

Date,Description,Credit,Debit
2024-03-04,Corner Cafe,,4.50
2024-03-05,ACME Payroll,2500.00,
2024-03-05,Corner Cafe,,4.50

Notice the two Corner Cafe purchases, identical in every column, remain two lines. Nothing is merged or de-duplicated here: removing genuine repeats is a choice for the person who knows the account.

Common mistakes

  • Opening the QBO in a spreadsheet by renaming it .csv. The text lines then land in a single column.
  • Assuming a file with a .qbo extension is a valid QBO. The name proves nothing, so the page checks the OFX structure inside the file rather than the extension.
  • Treating the exported amounts as a statement balance. The CSV holds transactions only.
  • Re-uploading a converted CSV to QuickBooks Online without choosing the matching account type. For credit cards, Intuit tells users to select the credit card account rather than a bank account.

What this tool does not do

  • It does not decide whether an institution block is valid, or contact Intuit or a bank.
  • Investment statements are read for cash transactions only. Securities and positions are not interpreted.
  • It does not repair a broken file. For that, run the OFX and QBO validator, which lists the problems.

What happens to your QBO file

The conversion is done by JavaScript running inside this page’s tool frame. The frame is sandboxed and its content security policy forbids network requests, so even a bug in the code could not send your file anywhere. The page that holds the advertising is a separate document and cannot read the frame. The file is read with the browser’s own file reader, the result is built in memory, and the download link points at a temporary address that exists only in your tab. Close the tab and it is gone. You can confirm it yourself: open your browser’s network panel, convert a file, and watch for requests. There are none.

Going the other way, use the CSV to QBO converter. For a file with several accounts and cards, the OFX to CSV converter is the closer fit.

Frequently asked questions

How do I open a QBO file in Excel?

Excel cannot read a QBO directly because it is OFX text, not a table. Load the file here, choose a layout and download the CSV, then open that in Excel. The conversion runs in your browser, so the QBO and its account number are not uploaded.

Does this also work for QFX and OFX files?

Yes. QBO, QFX and OFX are all Open Financial Exchange files, in the 1.x SGML or 2.x XML form. The page detects which form it has, and reads bank and credit card statements. It also tolerates stray text or a byte order mark before the header.

What is the institution block shown above the options?

It is the ORG, FID and INTU.BID values in the file’s sign-on section. Intuit products use them to identify the bank. They are shown so you can see where a file claims to come from, for example when a converted file is rejected. The page cannot tell you whether they are valid.

Why are some transactions missing from my CSV?

A transaction whose date or amount cannot be read is left out and counted in a warning above the preview. The OFX and QBO validator page lists exactly which transactions have the problem and why.

Which CSV layout can QuickBooks Online import?

Intuit documents a 3-column layout (Date, Description, Amount) and a 4-column layout (Date, Description, Credit, Debit). Both are offered here. Intuit also asks for one date format, no zero amounts and an account chosen at upload, so check its current instructions before relying on any converted file.

Is the sign of the amount preserved?

Yes. OFX stores money out as a negative number and money in as positive, and the CSV keeps that. In the 4-column layout, positive amounts go to Credit and negative amounts go to Debit as positive numbers, with the other cell empty.

Does the CSV contain my account number?

The full layout includes the account number from the file unless you tick the masking option. The QuickBooks layouts contain no account number at all. Either way, the file is created on your device and is not sent anywhere.

Why is a text cell prefixed with an apostrophe?

A bank description that begins with =, +, - or @ can be run as a formula when a spreadsheet opens the CSV. The page prefixes such text cells with an apostrophe so they stay text. The apostrophe is visible in the cell. Tick the option to turn this protection off if you need the raw text.

Sources

Checked

Runs entirely in your browser. Nothing you load or type is sent or stored. This page is not affiliated with Intuit, Quicken, any bank or the OFX standards body.

Common mix-ups

  1. Open Financial Exchange 2.2 specification (Internet Archive copy)

Checked against these sources on .

Advertisement
Advertisement