Convert an OFX bank statement to Excel
To track your spending or build a budget you need your transactions in a spreadsheet. Many banks let you download them as OFX or QFX: this tool turns them into an Excel file with one row per transaction.
What OFX is
OFX (Open Financial Exchange) and its QFX variant are standard formats for exchanging bank data with personal-finance software. In online banking it usually appears as an option when downloading transactions, next to PDF or CSV — sometimes labelled "Money", "Quicken" or "OFX".
Step by step
- Download your transactions from online banking in OFX or QFX format.
- In Zero7Files, open Pro Arsenal → OFX ➔ Excel.
- Pick or drop the file and press Convert.
Transacciones.xlsxdownloads, with a sheet named Transacciones (transactions).
Columns in the result
The column headers are in Spanish; here's what each one means:
| Column | Contents |
|---|---|
| Fecha (date) | Transaction date as given by the bank, usually YYYYMMDD (e.g. 20261015). |
| Tipo (type) | Operation type: DEBIT, CREDIT, FEE… |
| Importe (amount) | The amount, negative for debits. |
| Concepto (description) | Merchant name or description; if the bank doesn't provide it, the memo is used. |
| Memo | Additional information from the bank. |
| ID | Unique transaction identifier, handy for spotting duplicates. |
Ideas for using it
- Readable dates: in Excel, use Data → Text to Columns with the YMD date format to turn 20261015 into a real date.
- Spending by category: add a "Category" column and build a pivot table that sums the amount by category and month.
- Several months or accounts: convert each statement and combine them with Excel Power Mapper; the ID column helps you remove duplicates.
If no transactions appear
The tool looks for the format's standard transaction blocks (STMTTRN). If it says it found none, the file may be of another type (a CSV with a renamed extension, for example) or the period may have no transactions. In that case, download the statement as CSV and use CSV to Excel.
Your banking data stays on your computer
A statement reveals your income, your spending and where you shop — which is why you shouldn't upload it to just any website. Here the file is read and converted inside your browser, and the Excel file is created on your device.