Convert OFX to CSV

OFX is the Open Financial Exchange format every bank claims to follow and none follow correctly. This converter tolerates all of it.

OFX files look like XML but rarely behave like it. Banks ship unclosed tags, unescaped ampersands, timezone-suffixed dates, and empty elements that break strict parsers. Gristmill's parser was built against those real-world dialects.

How to open an OFX file as CSV

1. Download the OFX export from your bank.
2. Drop it into Gristmill.
3. Download the cleaned CSV — ready for Sheets, Excel, or any budgeting app.

Why converters choke on OFX

Common landmines this tool handles that generic ones don't:

• SGML-style headers (OFXHEADER:100) before any XML starts
• Tags left unclosed mid-file
• Ampersands in merchant names breaking XML parsers
• Dates like 20260105120000[-5:EST]
• Both bank-account and credit-card statement layouts

The parsing engine is open source — read it on GitHub or use it as an npm library in your own project.