Bank files · Runs in your browser

Convert OFX to CSV, every account in the file.

Read an OFX file that may hold several bank accounts and credit cards, see each one listed, and export all of them or just one as CSV. Everything happens in your browser.

Converting a multi-account OFX file

  1. Choose the OFX file. The page parses it immediately and reports how many statements and transactions it found, and whether it is the 1.x SGML or the 2.x XML form.
  2. Use the Which account or card list. “All accounts” writes one CSV with an Account column. A single choice writes just that account.
  3. Pick the layout. The first option keeps account details on every line, which suits a bookkeeper merging accounts. The 3-column and 4-column options drop the account details and match the layouts QuickBooks Online accepts for a manual upload.
  4. Download the CSV. A UTF-8 byte order mark is included so that Excel shows accented characters correctly.

Bank statements, credit card statements and the rest

An OFX file groups financial data into message sets. A deposit account statement sits in the bank message set and is identified by a bank ID, an account number and an account kind (checking, savings, money market, credit line or CD). A credit card statement sits in its own message set and is identified by an account number alone. Investment accounts have a third structure with positions and trades. This page reads the first two completely and the third only for cash transactions. If a file mixes them, which a brokerage download or a single sign-on covering several accounts often does, each is listed separately so you can see what it found before exporting.

Signs: what a negative number means

In OFX the amount of a transaction is signed from the account holder’s point of view. A purchase on a credit card or a withdrawal from a chequing account is negative. The conversion keeps the sign as written. Some banks nevertheless write credit card purchases as positive numbers in their CSV exports, which is a different file type; here, the sign comes straight from the OFX amount, so a card payment that reduces the balance shows as positive. If you see TRNTYPE values that disagree with the sign, the validator page flags them.

What happens to the date

OFX dates look like 20240331120000.000[-5:EST]. The converter takes the year, month and day exactly as written and ignores the time and zone, so a transaction posted at 23:30 is not pushed into the next day. The CSV writes dates as ISO text, month-first or day-first as you choose. A date that is not real, such as 20240230, is not converted; the transaction is skipped and reported.

Worked example

A file contains a chequing account ending 0123 with three transactions and a credit card ending 4111 with one. Choosing All accounts yields four data lines, each starting with the account (or its last four characters), then the type (Checking or Credit card), currency, date, amount, transaction type, name, memo, check number and transaction ID. Choosing only the card yields one line. In the 3-column layout the Account columns are omitted, so make a separate export for each account before merging them elsewhere, or you will not be able to tell them apart.

Common mistakes

  • Merging several accounts into the 3-column layout, which has nowhere to say which account a line belongs to.
  • Treating a card payment and a card purchase as the same sign. A payment is money in and positive.
  • Opening the CSV by double-clicking and trusting Excel’s date and number guesses. Importing through the data tools and marking date columns as text avoids surprises.
  • Forgetting that the CSV is sensitive: it contains every transaction. Delete it when you are done.

What this tool does not do

  • It does not merge or de-duplicate transactions; two identical lines stay two lines.
  • It does not categorise anything, and it does not convert currencies.
  • It does not repair damaged files. Use the validator to see what is wrong with one.

What happens to your OFX 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.

If your file is a QuickBooks download, the QBO to CSV converter covers the Intuit-specific fields. To create an OFX file from a spreadsheet, use the CSV to OFX converter.

Frequently asked questions

How do I convert an OFX file to CSV?

Choose the .ofx file (or paste its text), pick whether to export every account or only one, pick a layout and date style, and press Convert to CSV. The CSV is made in your browser and offered as a download. The OFX file is not uploaded.

What if the file has more than one account?

Each statement in the file is listed with its account number (last four characters), type, currency and transaction count. Export all of them into one CSV, where an Account column tells them apart, or choose one statement. Credit cards are labelled as such.

How are bank and credit card statements told apart?

A bank statement carries a bank ID, account number and account kind. A credit card statement carries only an account number and sits in its own message set. The CSV labels the second kind as Credit card.

Does it read OFX 2.x as well as 1.x?

Yes. OFX 1.x is SGML, where most elements have no closing tag, and 2.x is XML. The reader handles both, and also QFX and QBO files, which are Intuit variants of 1.x. If the file is malformed, the page reports warnings such as an element that was never closed rather than failing silently.

Will Excel keep the leading zeros in my account number?

No. Excel treats a value like 00123456 as a number and drops the zeros when it opens a CSV. Use the masking option to show only the last four characters, or import the column as text through Excel’s data import. The CSV itself contains the characters exactly as they appear in the file.

What about investment accounts?

Investment statements are read for their cash transactions only. Trades, positions and securities are not interpreted, and the page tells you when a file contains an investment statement.

Why is the number of rows smaller than the transaction count?

A transaction with a missing or invalid date or amount cannot go into a CSV with real dates and numbers, so it is skipped and counted in a warning. The OFX and QBO validator page shows which ones and why.

Does the CSV include balances?

No. The CSV holds transactions. The validator page shows ledger balances, and can check them against an opening balance you enter.

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