What is an OFX file?
OFX — Open Financial Exchange — is the format banks have offered since the late 1990s for downloadable statements, built so desktop software like Quicken and Microsoft Money could read transactions without screen-scraping. An OFX file wraps each transaction in a STMTTRN block holding its posted date, signed amount, type, payee, and a bank-assigned id. It comes in two flavors — 1.x is SGML with a plain-text header and no closing tags, 2.x is real XML — and QFX is the same format with Quicken-specific branding tags added. For the full anatomy, read What is an OFX file? in the Learn section.
Who has OFX and QFX files?
Anyone who ever clicked "Download to Quicken" or "Download to Money" in online banking — plus bookkeepers and accountants handed years of statement downloads during a cleanup, migration, or audit. Many banks still offer the download even though the desktop software era has faded, and old .ofx/.qfx files are often the only machine-readable record of accounts at banks that have since merged, changed systems, or dropped the export entirely. If you just need those transactions in a spreadsheet, converting to CSV is the fastest path.
The columns you get
- Date: The transaction's DTPOSTED, normalized to YYYY-MM-DD.
- Amount: TRNAMT, signed — deposits positive, withdrawals and charges negative.
- Type: TRNTYPE: DEBIT, CREDIT, CHECK, ATM, DIRECTDEP, PAYMENT, and so on.
- Name: The payee — the NAME tag, or the name inside a PAYEE block when the bank sends one.
- Memo: The bank's free-text memo line, when present.
- Check #: CHECKNUM, for check transactions.
- FITID: The bank's unique transaction id — handy for de-duplicating overlapping downloads.
The converter handles both bank statements (STMTRS) and credit-card statements (CCSTMTRS), and reads the statement's currency, masked account number, and closing ledger balance into the summary above the preview.
How to convert OFX to CSV
- Drop your .ofx or .qfx file above. Parsing happens on your device — the file is never uploaded.
- Check the summary: account (masked to the last 4 digits), currency, date range, and ledger balance.
- Preview every transaction — date, amount, type, payee, memo, check number.
- Export as CSV for Excel, XLSX, or JSON.
For the fuller walkthrough — including what to do when your bank only offers QFX — see How to convert OFX or QFX to CSV.
OFX and QFX questions, answered
What's the difference between a QFX file and an OFX file?
QFX is Quicken's branded variant of OFX — the same header, the same tags, the same STMTTRN transaction blocks, plus a few Intuit-specific extras like an INTU.BID tag identifying the bank to Quicken. Quicken refuses to import a plain OFX file without that branding, but going the other direction is easy: this converter reads both identically, so a .qfx converts to CSV exactly like a .ofx.
Why did my bank stop offering OFX downloads or Direct Connect?
OFX was designed in the late 1990s for desktop software like Quicken and Money to talk to banks directly (Direct Connect). As banks moved to their own web and mobile apps — and to API-based aggregators like Plaid — many quietly dropped Direct Connect and buried or removed the OFX/QFX download option, since maintaining it costs money and serves a shrinking audience. That's exactly why old .ofx files pile up: they were often the only machine-readable export, and now the tool that read them is gone.
Can I just open an .ofx file in Excel?
Not usefully. OFX 1.x is SGML — tags without closing tags, preceded by a plain-text header block — and OFX 2.x is XML, so Excel either refuses the file or renders a wall of tags rather than a transaction table. Converting the file properly means pairing each STMTTRN's date, amount, payee, and memo into one row, which is what this converter does before handing you a clean CSV.
Is this OFX converter really free?
Yes — every file parses and previews free with no signup and no upload. Free exports include the first 100 transactions; a one-time $19 license unlocks unlimited exports on every LegacyFile tool.