# How to Open a QFX File Without Quicken

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2026-06-26
- Updated: 2026-06-26
- Category: Import file formats
- Canonical: https://www.simplebankconvert.com/blog/how-to-open-a-qfx-file

> How to open a QFX file to see what's inside: read it in a text editor, convert it to a spreadsheet, or import it into Quicken or QuickBooks properly.
A QFX file is plain text, so the quickest way to open one is in a text editor such as Notepad or TextEdit. You will see tagged lines for each transaction. To read it as a table, convert it to CSV for Excel. To load it into your books, import it through Quicken or QuickBooks rather than opening it.

## Opening a QFX file in a plain text editor

A plain text editor opens a QFX file safely and shows exactly what the bank sent. Right-click the file, choose Open with, and pick Notepad on Windows or TextEdit on a Mac. Nothing in your accounting software changes, and as long as you close without saving, the file stays as it was.

What you will see, from top to bottom:

1. **A header** of a few lines, such as `OFXHEADER:100` and `DATA:OFXSGML`, or an XML-style line starting `<?xml`. This says which generation of the OFX standard the file follows, a difference explained in [OFX SGML versus XML files](/blog/ofx-sgml-vs-xml).
2. **A sign-on block** naming the bank, often with an `INTU.BID` line that Quicken uses to recognise it.
3. **The account block**, with the account type and a masked or full account number.
4. **The transactions**, each between `<STMTTRN>` and `</STMTTRN>`, with tags for the date, amount, payee and an ID.
5. **A closing balance** in a `LEDGERBAL` block near the end.

On a Mac, TextEdit may try to show the file as formatted text. If the tags look odd, choose Format, then Make Plain Text, before you read it.

Dates appear as eight or more digits, year first. 20260518 is May 18, 2026. Amounts are signed: a minus means money out.

### Ways to open it, compared

| Method | What you see | Changes your books? |
| --- | --- | --- |
| Text editor | Raw tags, every field | No |
| Excel, via text import | Tags in one column, needs reshaping | No |
| A QFX to CSV converter | One row per transaction | No |
| Free QFX viewer program | A table, if it works | No, but check what it uploads |
| Quicken Web Connect import | Transactions in a register | Yes |
| QuickBooks Online bank upload | Transactions for review | Yes, once accepted |

The first four are for reading. The last two are imports and should be done once, into the right account.

## Can you open a QFX file in Excel as a table?

Not directly. Excel will open a QFX through its text import, but it does not understand the tags, so every tag lands on its own row in one column. Getting one row per transaction takes splitting and reshaping, which works but is slow for a long file.

The full method, from renaming the copy to fixing the dates, is in [opening a QFX file with Excel's data import](/blog/qfx-to-csv#can-excel-open-a-qfx-file-directly). If you only want to glance at a few amounts, the text editor is faster. If you want to sort, filter or total, convert to CSV first.

Avoid saving the QFX from Excel after viewing it. Excel will save it as a spreadsheet or a CSV, and the result is no longer a QFX file your software can import.

## Is a free QFX reader download worth installing?

A free QFX reader download can save time if you open these files often, but it is rarely needed for one file. Before installing one, check who makes it, whether it runs on your own computer or uploads your file to a server, and whether it shows the transaction ID and memo as well as date and amount.

Points to weigh:

- **Bank data is sensitive.** A QFX file can include your account number. A program that runs locally keeps it on your machine. A website converter sends it somewhere else.
- **Read-only is enough.** You want a viewer, not an editor. Anything that offers to "fix" the file is changing what the bank sent.
- **Compare totals.** If the reader shows a total, check it against the bank's own figure for the same dates.

A text editor already on your computer does the same job for free, with no download at all.

## Opening a QFX file in Quicken or QuickBooks as an import

Putting a QFX file into your books is an import, not an open. In Quicken for Windows, start from the File menu, pick File Import and then Web Connect File, and point it at the download. [Quicken's own help article on bringing data into Quicken for Windows](https://www.quicken.com/support/how-do-i-import-data-quicken-windows) gives that path and calls the bank's .QFX download a Web Connect file.

### QuickBooks Online

Online takes a QFX through its bank file upload. Intuit's article on [manual transaction uploads in QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) recommends QBO first but accepts QFX too. Pick the matching bank account when the upload asks, then review each line before you add it.

### QuickBooks Desktop

Desktop will not take it. Intuit's [Web Connect error guide for Desktop](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-connectivity/fix-web-connect-import-errors/L8o5eQjO4_US_en_US) states that Web Connect reads .qbo files only. Either fetch the QuickBooks download from the bank, or change the QFX into a QBO before you import.

### Shop deposits in the file

If the account receives payouts from an online shop, the QFX shows the deposits after fees, not the individual sales. [Importing Etsy sales into QuickBooks](/blog/import-etsy-sales-into-quickbooks) covers recording the sales side so the deposits match.

## Saving over a QFX file after viewing it in Word or Excel

Saving over a QFX file from Word or Excel is the usual way people damage one. Word can add formatting and change the line endings, and Excel rewrites the content as a spreadsheet. The import that worked yesterday then fails, and the bank may no longer offer the same date range to download again.

To stay safe:

- Work on a copy. Keep the original download in its own folder, untouched.
- Close the text editor without saving if you only read the file.
- If you must edit, for example to remove a line before an import, use a plain text editor and save under a new name.
- Never open it in a word processor at all.

Not every bank file is a QFX underneath. Business accounts sometimes come with other text formats, and [the BAI2 file format explained](/blog/bai2-file-format) helps if your file is full of numbered records instead of tags. For a version you can print or email, [turning a QBO file into a printable report](/blog/qbo-to-pdf) shows the approach for QBO, the QuickBooks cousin of QFX.

If your bank gives you only PDF statements for the months you need, SimpleBankConvert is being built to turn those PDFs into CSV or QBO files; [get started](/get-started) to hear when it opens.