Convert OFX to ODS

Turn OFX files into ODS. Every bank and credit card statement in the file, OFX 1 with its unclosed tags or OFX 2 in XML, gives a row for each transaction with the account number, the posting date, the amount, the currency, the payee, the memo, the check or reference number, the transaction type and the bank's transaction id.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop OFX files on the dialor turn it to pick what to do

Bank transactions in a spreadsheet.Each bank and credit card transaction in an OFX or QFX file gets a row in an ODS sheet.

  1. What you get

    One ODS file with one sheet, named after the file. It reads both OFX 1, with its unclosed tags, and OFX 2, which is XML. Each bank or credit card transaction in the file becomes a row.

    A row holds the account number, the posting date, the amount, the currency, the payee, the memo, the check or reference number, the transaction type and the bank's transaction id. A bold header names these columns, and they are the same columns as the csv conversion.

  2. How cells are typed

    Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells shown with as many decimals as the file wrote, so you can sort and add them.

    Every other column is text. Account numbers and transaction ids keep their leading zeros and all their digits.

  3. What it leaves out

    Investment statements are not converted. If a file holds only investment statements, the conversion stops with unsupported_elements. If a file holds both kinds, the bank and credit card transactions are converted and the investment ones are left out.

OFX and ODS.What each format is.

The formats

From · OFX

OFX Bank Statement

Open Financial Exchange, the statement download of North American banks and card issuers that Quicken, GnuCash and most money apps import; QFX is Quicken's flavor of it.

Extensions
.ofx .qfx
MIME type
application/x-ofx
Kind
Text and data
To · ODS

OpenDocument Spreadsheet

OpenDocument spreadsheet, the native format of LibreOffice Calc.

Extensions
.ods
MIME type
application/vnd.oasis.opendocument.spreadsheet
Kind
Documents

In your code.The same OFX to ODS conversion through the API, for your app or your agent.

terminal
$ cv convert report.ofx report.ods
$ cv convert report.ofx report.ods

Questions.What people ask about OFX to ODS.

01OF 04

Yes. QFX is Quicken's flavor of OFX, and it is read the same way as an OFX file.

No. Account numbers and ids are stored as text, so the leading zeros and all the digits stay.

The file holds only investment statements. Those are left out, so no rows remain to write.

Yes. See every ODS conversion for the full list.

More conversions.Other ways in and out of OFX and ODS.