Unclip
Sign in

Convert an OFX file to Excel

Open an Open Financial Exchange (.ofx) download as a proper spreadsheet, with one row per transaction.

  • Runs in your browser. The file is never uploaded.
  • Free for 10 files a day. No account.
  • Also writes CSV, QBO, QFX, OFX, QIF, IIF, PDF.
  • Nothing is uploaded: the file stays on your computer
  • Free for 10 files a day, no account
  • Every output format from the same screen

Why OFX to Excel

OFX is what most banks and brokerages use for downloadable statements, in either the older SGML form or the XML form. Spreadsheets don't read either. This converter parses both and writes a clean workbook, keeping the currency and the statement period from the file.

What you get in the workbook

  1. Columns: Date, Description, Amount, Debit, Credit, Check number and Memo.
  2. Both OFX 1.x (SGML, unclosed tags) and OFX 2.x (XML) files are read.
  3. Credit card OFX files (CCSTMTRS) work the same way as bank files.
  4. CSV, QBO, QFX, QIF and PDF are available from the same screen.

How the conversion works

1. Read

Every STMTTRN block is read: date posted, amount, payee, memo, check number and the bank's transaction ID. OFX 1 (SGML) and OFX 2 (XML) both work, as do credit card files.

2. Check

Rows without a readable date and amount are counted and reported, never silently dropped. Totals in and out and the period are shown so you can compare them with the source before importing.

3. Write

A real .xlsx workbook: Excel dates, numeric amounts, a frozen header row and a filter. No add-ins needed.

Starting from a PDF statement? The statement converter reads it and checks every row against the printed balance.

Related converters

  • QFX to ExcelTurn a Quicken Web Connect (.qfx) download into a spreadsheet, with real dates and numbers, in your browser.
  • QBO to ExcelOpen a QuickBooks Web Connect (.qbo) file as a real spreadsheet: dates as dates, amounts as numbers, one row per transaction.
  • OFX to CSVGet a plain CSV out of an .ofx download for Google Sheets, Xero, Wave, YNAB or your own scripts.
  • OFX to QBOYour bank gives you an .ofx file and QuickBooks wants a .qbo. The difference is a header and two Intuit tags. Fix it in your browser.

All file converters

Questions

My OFX file came from a broker. Will investment transactions convert?

Only bank-style transactions (STMTTRN) are read. Investment positions and trades are not, yet.

Is the running balance included?

OFX files carry a closing balance but no balance per transaction, so there's no Balance column.

Where is the file processed?

In your browser. Nothing is uploaded, so there's nothing to delete afterwards.