# Convert OFX, QFX and QIF files to Excel

> Markdown version of https://stella.sh/how/money-household/convert-ofx-to-excel for agents and LLMs.
> Open OFX, QFX and QIF bank downloads in Excel with date, payee, signed amount and memo for every transaction: GnuCash's import and export, or Stella (stella.sh).

OFX and QFX (the Quicken flavour of OFX) are text files that money programs import; QIF is Quicken's older format. Excel can't open any of them properly. The free GnuCash program imports all three and exports the transactions to CSV, or ask your bank for a CSV download instead. Stella (stella.sh) converts them on your computer: one spreadsheet per file with date, payee, amount and memo, spending as negative numbers, and nothing uploaded to a converter site.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: Three spreadsheets in about a minute. Checked afterwards against an answer key written before the run: all 40 transactions from the QFX, all 21 from the OFX and all 25 from the QIF, each with the right date, signed amount and payee, and the memos carried over. The bank files are fictitious, written in the real formats (including the old QFX style without closing tags and a QIF split). The work is sped up 5×.

Video (42 s): https://stella.sh/media/proofs/money-household/convert-ofx-to-excel/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A QFX, an OFX and a QIF bank file are in Downloads.
- 0:02 The prompt: an Excel spreadsheet for each, with date, payee, amount and memo.
- 0:10 Stella replies: one spreadsheet per file, with a count of transactions in each.
- 0:15 Reading the three formats, sped up 5×.
- 0:27 Done: 40, 21 and 25 transactions, saved next to the originals, with a few things to ask the bank about.

What Stella does:

1. Finds three files in Downloads: an old-style QFX for checking, an OFX 2 file for savings and a QIF from a 2019 joint account
2. Reads each format as it is: the QFX without closing tags, the OFX as XML, and the QIF's `1/ 5'19` dates and `T-1,234.56` amounts, keeping a split transaction as one
3. Writes `Checking_Oct2026.xlsx`, `Savings_2026.xlsx` and `Old joint account 2019.xlsx` next to the originals, with date, payee, amount and memo, sorted by date
4. Keeps two identical coffees on the same day as two rows, and shows spending as negative numbers in red
5. Points out things worth asking the bank about, such as one check number used twice, and leaves the original files unchanged

## The prompt to paste

```text
My bank only lets me download transactions as QFX, OFX and QIF files (they're in my Downloads) and I can't open them. Turn each one into an Excel spreadsheet with the date, payee, amount and memo for every transaction.
```

## Convert them yourself

1. **Try a CSV download first.** Most banks offer CSV or Excel alongside OFX, QFX and QIF, sometimes under a different button such as “Spreadsheet” or “Comma delimited”. If yours does, that's the quickest route.
2. **Install GnuCash.** GnuCash is free accounting software for Windows, Mac and Linux. It can import OFX, QFX and QIF, which Excel and Numbers can't.
3. **Import the file.** Make a new GnuCash file, then File, Import, Import OFX/QFX (or Import QIF). Match the transactions to a new bank account when it asks. For QIF it also asks the date format: pick the one your bank uses.
4. **Export to CSV.** Open the account, then File, Export, Export Transactions to CSV. Open the CSV in Excel or Numbers and save it as a spreadsheet.
5. **Check dates and signs.** Compare the first and last few rows with your online banking. A QIF date like 1/5 can mean 5 January or 1 May, and some programs drop the minus sign on spending.

## Where Stella stops

- Investment (brokerage) OFX files hold trades and holdings as well as cash; those come out differently from a bank account and weren't part of this run.
- QIF dates don't say whether they're US or day-first. Stella reads the file to tell, but check one known transaction if your bank isn't American.
- Stella left out the QIF's own spending categories because the prompt asked for four columns. Ask for them if you want them.
- The transactions go to the AI model you use in Stella while it reads them. The spreadsheets are written on your computer.
- Recorded on Linux. On a Mac or Windows PC Stella may first install Python or a small spreadsheet library, which wasn't recorded.

## Questions

**What is an OFX file?**
Open Financial Exchange: a text file of bank transactions made for money programs like Quicken, GnuCash and accounting apps. QFX is the same format with a few Quicken-only fields. Excel shows it as a jumble of tags.

**What is a QIF file?**
Quicken Interchange Format, an older plain-text format with one line per field: D for date, T for amount, P for payee, M for memo, ending each transaction with `^`.

**Can I open an OFX file in Excel directly?**
Not usefully. Excel may import it as text, but you get tags and values on separate lines, not one row per transaction.

**What can I do with the spreadsheet next?**
Build a monthly picture: [make a budget from your bank statement](https://stella.sh/how/money-household/make-a-budget-from-bank-statement), or [find duplicate charges](https://stella.sh/how/money-household/find-duplicate-charges-on-credit-card). If your statements are PDFs instead, see [bank statement PDF to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel).

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [GnuCash: free accounting software (imports OFX, QFX and QIF)](https://www.gnucash.org/).

## Related problems

- [Convert bank statement PDFs to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel.md)
- [Make a budget from your bank statements](https://stella.sh/how/money-household/make-a-budget-from-bank-statement.md)
- [Find duplicate charges on your credit card](https://stella.sh/how/money-household/find-duplicate-charges-on-credit-card.md)
- [How much have I spent on Amazon each year?](https://stella.sh/how/money-household/how-much-have-i-spent-on-amazon.md)
- [Total your mileage log for taxes](https://stella.sh/how/money-household/mileage-log-for-taxes.md)
- [Calculate hours worked from a timesheet](https://stella.sh/how/money-household/calculate-hours-worked-from-timesheet.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
