Why Excel can’t open OFX files
Double-click an OFX file and Excel either refuses it or shows a single column of text like <TRNAMT>-48.20. That’s because OFX isn’t a spreadsheet format. Most OFX files (version 1.x) are written in SGML, a loose relative of HTML that Excel doesn’t understand. Newer OFX 2.x files are XML, and Excel’s Get Data → From XML can read them, but the result is a set of nested tables — statement, account, transaction list — that takes some unpicking before it’s usable.
Open an OFX file in Excel in three steps
- Drop the OFX file on the converter above, or try the sample.
- Check the count of transactions and the totals of money in and money out against your statement.
- Excel workbook (.xlsx) is preselected in step 3 — download it and open it in Excel, Google Sheets or Numbers.
What the workbook contains
The workbook has one sheet, Transactions, with a heading row and a row per transaction. The OFX converter to Excel stores dates as real Excel dates, so sorting and date filters work, and amounts as numbers, so SUM, pivot tables and charts work straight away. There are separate Debit and Credit columns as well as one signed Amount column — use whichever your formulas need. The payee and memo are joined into one Description, and check numbers get their own column.
Things to do with OFX data in Excel
- Categorise spending. Add a Category column and a pivot table to total each category per month.
- Prepare a tax return. Filter the year and total deductible expenses.
- Reconcile. Sort by amount to find a payment quickly, or compare against invoices with
XLOOKUP. - Send it to an accountant who doesn’t use the same software as you.
When the numbers don’t look right
- Dates shown as numbers. If a date appears as 46027, the column has lost its date format — select it and choose a date format. The values are correct.
- Everything is negative. That’s normal for a credit card OFX, where purchases are money out. Use the Debit column if you want positive spending figures.
- Missing recent transactions. Banks usually leave pending transactions out of OFX downloads.
- More than one account. If the OFX held several accounts, their transactions are in one list. Download each account separately to keep them apart.
Need a plain text file instead? OFX to CSV writes the same columns as a CSV. For Quicken’s variant, see QFX to Excel.
Frequently asked questions
Can Excel open an OFX file directly?
Not usefully. OFX 1.x files aren’t a format Excel reads, and OFX 2.x XML files import as nested tables. Converting gives a normal sheet with one row per transaction.
Are dates and amounts real Excel values?
Yes. Dates are stored as Excel dates and amounts as numbers, so sorting, filters, SUM and pivot tables work immediately.
Is my OFX file uploaded to convert it?
No. The conversion runs in your browser and the workbook is saved to your device.
Does it work in Google Sheets or Numbers?
Yes. Both open .xlsx workbooks. Or choose Clean CSV in step 3 for a plain CSV file.
Is there a limit on transactions?
No fixed limit. Files up to 25 MB are accepted, which is many years of transactions.