How to open a QFX file in Excel
You pressed Download at the bank, picked the Quicken or Money option, and now have a .qfx or .ofx file that Excel won't show as a table. Here is the two-minute way to a spreadsheet.
What the file is
A QFX file is Quicken's "Web Connect" download; an OFX file is the same Open Financial Exchange format without Quicken's bank ID. Both are tagged text made for money apps, one tag per field (<DTPOSTED>, <TRNAMT>, <NAME>), not rows and columns. Excel's and Google Sheets' own help pages describe opening CSV files; neither lists QFX, OFX or QIF (their words are in the table on QFX vs OFX vs QIF).
Turn it into a CSV
- Open the Bank File Converter and drop the file in (several at once is fine: checking, savings and cards).
- Check what was read: the account (only its last 4 digits), how many transactions, the date range and the bank's own ending balance, with a preview of the lines.
- Leave CSV picked, choose how dates look (2026-10-31 sorts best; 10/31/2026 is what US Excel shows) and whether you want one Amount column (minus = money out) or separate Debit and Credit columns.
- Press Download and open the .csv in Excel. In Google Sheets use File → Import → Upload.
Each row has the date, payee, memo, amount, check number, the bank's transaction type, the bank line id (FITID: handy for spotting the same line in two downloads) and the account.
When it looks wrong
- Accents come out as é. Keep "Excel-safe accents (UTF-8 mark)" ticked; it adds the byte-order mark Excel needs to read UTF-8. The converter itself reads UTF-8, UTF-16 and Windows-1252 bank files.
- Everything lands in one column (Excel in Europe). Pick "1234,56, semicolon-separated" under Numbers: European Excel expects semicolons and a decimal comma.
- Charges are plus amounts. Some card files write charges as positive numbers. The converter spots that and flips them so money out is minus; untick "Flip signs" if you want them as the file has them.
- Fewer lines than expected. If the download was cut off, you are told so and only the complete lines are kept: download it again from the bank.
- A formula ran, or a payee starts with an apostrophe. A payee that starts with = + - or @ gets a leading apostrophe so Excel shows it as text instead of running it.
Private by design
The page converts the file inside your browser tab. Its Content Security Policy forbids it (and its worker) from connecting anywhere, so the file cannot be uploaded, and nothing is stored. Account numbers are cut to their last 4 digits as the file is read. Privacy.
Keeping a register on Windows? Stubbook opens these files by double-click (on the Microsoft Store). Tracking bills? Paid Up.