Convert OFX to XLSX

Turn OFX files into XLSX. 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 statements as spreadsheet rows.Each transaction in an OFX or QFX file becomes one row in an Excel workbook.

  1. What you get

    One XLSX file with a single sheet named after the file. Every bank and credit card statement in the file is included, whether it is OFX 1 with unclosed tags or OFX 2 in XML.

    Each transaction gets a row 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. The header is bold and frozen, and its columns are the same as in the csv conversion.

  2. How values are stored

    Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells shown with as many decimals as the file wrote.

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

  3. What it leaves out

    Investment statements are not converted. A file that holds only investment statements stops with unsupported_elements.

    If you want to combine several converted workbooks, you can merge XLSX afterward.

OFX and XLSX.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 · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

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

terminal
$ cv convert report.ofx report.xlsx
$ cv convert report.ofx report.xlsx

Questions.What people ask about OFX to XLSX.

01OF 04

Yes. OFX 1 with its unclosed tags and OFX 2 in XML are both read. QFX files, Quicken's flavor of OFX, are accepted too.

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

No. Investment statements are left out. A file with only investment statements fails with unsupported_elements.

Every bank and credit card statement in the file is included. All their transactions go into one sheet, and each row carries its account number.

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