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.
Upload a file
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>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 and QBO to CSV. Going the other way is CSV to OFX.
What the CSV file looks like
The rows you get, shown here as CSV text. The .xlsx has the same four columns, with the amounts stored as numbers. Balance stays empty for an OFX source, because OFX transactions carry no running balance.
Date,Description,Amount (USD),Balance
2026-03-02,Direct Debit 4471 Acme Insurance,-120.00,1880.00
2026-03-04,Card Payment Corner Grocer,-38.40,1841.60
2026-03-06,Transfer Received J Smith,500.00,2341.60How to convert
Upload the OFX file
Drop in the .ofx, .qfx or .qbo your bank produced. Several files can go in at once.
Keep Excel selected
Excel is selected on this page; switch to CSV for a plain .csv.
Open the workbook
Open the .xlsx in Excel, Numbers or Google Sheets.
Statements it handles
Layouts differ from bank to bank, so nothing is matched against a fixed template. An unusual statement still produces a table you can check before exporting — which is what makes it usable for bookkeepers and accountants who receive statements from every client.
PDF statements and CSV exports
A statement downloaded from your bank, or the CSV your bank lets you export. Both arrive as the same clean table.
Multi-page statements, read as one table
A statement that runs over several pages — or several statements uploaded together — is read as one continuous table, not one file per page.
Amounts and dates kept as your bank prints them
Debit and credit signs, decimal places and date formats are left as printed, so the numbers still reconcile against the statement.
Scanned, image-only PDFs, read with OCR
A statement with no text layer is read with OCR and may need a quick review — the one case where a row can come out wrong.
- CSV
- Scan
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.