OFX to XLSX Converter
Convert OFX to XLSX in your browser and get a workbook with one clean sheet: sortable dates and amounts as actual numbers.
Your financial data stays in your browser.
How to Convert OFX to XLSX
An .ofx file is a statement, not a spreadsheet. Excel will not open it cleanly, and retyping the rows is nobody's idea of a good afternoon. This converter reads it in your browser and hands back a real workbook. If you would rather start from the other end (what to do with the numbers once they are in Excel), the OFX to Excel guide covers that.
- 1Choose your .ofx or .qfx file, or drag it onto the drop area
- 2Let the browser parse the statement; nothing is uploaded
- 3Download the .xlsx and open it in Excel, Sheets, or Calc
The download is a single worksheet named Transactions, one row per statement line. No sign-up, no upload: the file stays on your machine.
What Is an XLSX File?
XLSX is the workbook format Excel has saved to by default since 2007. Under the hood it is a package of XML files zipped together, which is what lets a workbook store numbers as numbers, keep several sheets, and carry formatting. This converter writes one sheet, named Transactions, and nothing else: no formulas, no styling, no macros. An OFX to XLSX conversion is mostly a typing job, and that is the part worth getting right: amounts should land as real numbers you can sum, dates as sortable YYYY-MM-DD text, names and memos as plain text. It matters more than it sounds: a statement exported as plain text looks fine until you total a column and get zero.
Microsoft lists .xlsx as "The default XML-based file format for Excel 2010 and Excel 2007". See File formats that are supported in Excel.
Where the XLSX File Opens
The .xlsx is the one spreadsheet format nearly everything reads. The same download opens in all of these, no import wizard:
- Excel on Windows and macOS, and Excel for the web
- Google Sheets: upload it and it opens as a native sheet
- LibreOffice Calc and Apple Numbers
- Bookkeeping tools that accept an .xlsx import
- An accountant or lender, who will ask for a spreadsheet rather than a bank file
OFX and XLSX Are Different Kinds of File
OFX and XLSX are different kinds of file. An OFX statement is a stream of tagged records: each transaction nests inside a statement block, and the date, amount, and payee each live in their own tag. An XLSX workbook is a grid of cells. Excel can import XML, but it wants a flat, well-formed document and a mapping you build yourself. OFX 1.x, which many banks still export, is neither. That is the whole job of an OFX to XLSX converter: flatten the records into rows, map the tags to columns, and write the amounts as real numbers on the way in. If plain text is what the next tool wants instead, OFX to CSV writes the same rows without the workbook around them.
What Each Column in the Workbook Means
Every OFX to XLSX conversion produces the same seven columns, taken straight from the transaction records.
| Column | What it holds |
|---|---|
| Date | The posted date, written as YYYY-MM-DD text that sorts in date order. |
| Type | The transaction type from the file, usually DEBIT or CREDIT. |
| Amount | The signed amount as a real number: money out negative, money in positive. |
| Name | The payee or counterparty, as the bank wrote it. |
| Memo | The free-text note that came with the entry, if any. |
| Transaction ID | The FITID from the file, or the check number when the entry has no FITID. |
| Account | The account the transaction belongs to, taken from the statement. |
Output Specs
What this conversion involves, in numbers.
| Specification | Value |
|---|---|
| Fields per transaction row | 7 |
| Output formats | 2 — an XLSX workbook or a plain CSV table |
| Statement tags read | 9 OFX tags — DTPOSTED, TRNTYPE, TRNAMT, NAME, PAYEE, MEMO, FITID, CHECKNUM, ACCTID |
| Bytes of your file uploaded | 0 — the conversion runs entirely in your browser |
| Practical statement size | Tens of thousands of transactions — the output is assembled in your browser's memory, so very large files take longer |
| Excel's worksheet ceiling | 1,048,576 rows by 16,384 columns — a limit of Excel itself, not of this converter |
Microsoft lists "Total number of rows and columns on a worksheet" as 1,048,576 rows by 16,384 columns — see Excel specifications and limits.
Using the Workbook After You Download It
Nothing about the file needs setup. Four things cover the first five minutes:
- 1Open it directlyDouble-click the .xlsx. Excel, Sheets, and Calc all open it without an import step.
- 2Check the Amount columnAmounts arrive as real numbers, so they right-align and SUM works. The date column is YYYY-MM-DD text and sorts in order.
- 3Filter the rowsTurn on AutoFilter on the header row to narrow the statement by type, month, or payee.
- 4Save it or hand it onKeep the .xlsx if someone will edit it; export CSV only when another tool demands plain text.
Questions About OFX Files
Choose your .ofx or .qfx file, let the browser parse it, then download the .xlsx. No sign-up, nothing uploaded.
OFX is a statement stream (tagged records, not a table), so Excel reads it as raw text instead of rows. Your bank exports it next to PDF and CSV; converting it flattens those records into columns.
Same conversion, two names. This page covers the file you get back: its format, columns, and where it opens. The OFX to Excel guide covers what to do with the numbers once they are in Excel.
Real numbers. The Amount column holds signed numeric values, so SUM, sorting, and charts work. Dates are different: they are YYYY-MM-DD text, which sorts correctly but is not an Excel date value.
No. The workbook is assembled in your browser's memory; no part of the statement is sent to a server. Close the tab and it is gone.
No. .qbo is QuickBooks' own dialect; this page reads .ofx and .qfx only. For .qbo, use the QBO to XLSX converter instead.