# OFX to Excel converter

Upload an .ofx file and download an Excel workbook with one row per transaction — date, description and signed amount in their own columns, amounts stored as numbers. Excel opens an OFX as raw tags rather than a table, so this is the quick way to read, filter or total a bank download. Choose CSV in the format menu for a plain .csv instead.

## What the Excel file contains

- A header row, then one row per transaction in the file
- Date as YYYY-MM-DD, description and a signed amount in their own columns
- Amounts stored as numbers, so SUM, filters and pivot tables work straight away
- The file’s currency from <CURDEF> in the Amount header, for example Amount (USD)
- Several OFX files in one upload come back as one table

## How OFX tags become columns

Inside an OFX file every transaction is a `<STMTTRN>` block like this:

| OFX tag | Column | Notes |
|---|---|---|
| `<DTPOSTED>` | Date | As YYYY-MM-DD; the time and time zone are dropped. `<DTUSER>` is used when the posted date is missing. |
| `<NAME>` or `<PAYEE>`, then `<MEMO>` | Description | Joined into one cell, for example “CORNER GROCER — Card payment”. |
| `<TRNAMT>` | Amount | Signed as the file writes it: money out negative, money in positive. |
| `<CURDEF>` | Amount header | The currency goes in the header, because a spreadsheet cell has no currency of its own. |
| `<FITID>`, `<TRNTYPE>`, account number | — | Bank-feed details with no spreadsheet use; the sign already says debit or credit. |

```
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260304120000.000[-5:EST]
<TRNAMT>-38.40
<FITID>2026030400017
<NAME>CORNER GROCER
<MEMO>Card payment
</STMTTRN>
```

One transaction in an OFX file. Version 1 (SGML, no closing tags) and version 2 (XML) are both read.

## OFX to CSV

Pick CSV in the format menu and the same rows come out as a .csv file for Google Sheets, Numbers or any importer. The CSV is UTF-8 with a header row; a description that starts with = + - or @ is written as text, so it cannot run as a formula.

A .qfx from Quicken or a .qbo for QuickBooks is OFX underneath and converts the same way; see also [QFX to CSV](https://statementconverterai.com/qfx-to-csv) and [QBO to CSV](https://statementconverterai.com/qbo-to-csv). Going the other way is [CSV to OFX](https://statementconverterai.com/csv-to-ofx).

## How to convert

1. **Upload the OFX file** — Drop in the .ofx, .qfx or .qbo your bank produced. Several files can go in at once.
2. **Keep Excel selected** — Excel is selected on this page; switch to CSV for a plain .csv.
3. **Open the workbook** — Open the .xlsx in Excel, Numbers or Google Sheets.

## Frequently asked questions

### How do I convert an OFX file to Excel?

Upload the .ofx above, keep Excel selected and download the .xlsx file. Every transaction becomes one row with date, description and amount.

### Can Excel open an OFX file directly?

It opens as text: tags such as <TRNAMT>-38.40, one per line, rather than a table. Converting gives you one row per transaction with the values in columns.

### How do I convert OFX to CSV?

The same way — choose CSV in the format menu before converting.

### Does it work with QFX and QBO files?

Yes. Both are OFX with an Intuit bank ID added, and the same reader takes all three.

### Is it free?

Each OFX file counts as one page, and the first 3 pages of your first upload are free. After that it is $0.20 a file with a $3.90 minimum per batch.

### Is my file kept after conversion?

No. The file is deleted when the conversion finishes; only the converted copy stays at your private link.

## Related

- [CSV to OFX](https://statementconverterai.com/csv-to-ofx)
- [QFX to CSV](https://statementconverterai.com/qfx-to-csv)
- [QBO to CSV](https://statementconverterai.com/qbo-to-csv)
- [What is an OFX file?](https://statementconverterai.com/guides/what-is-an-ofx-file)
- [PDF bank statement to Excel](https://statementconverterai.com/bank-statement-to-excel)
- [All bank statement converters](https://statementconverterai.com/)