How to Open QFX File: Import to Quicken or Convert to Excel
A QFX file is a bank or credit card statement in Quicken's Web Connect format, the file you get when you choose "Quicken" in your bank's download options. Quicken opens it with File > File Import > Web Connect File. Without Quicken, the free viewer below shows all transactions and balances in your browser and converts the QFX to Excel or CSV, and it points out the problems that make Quicken reject a file.
Choose what you need
Open QFX File Online: View & Convert to Excel Without Quicken (Free)
Drop a .qfx file below. The viewer shows the bank, the Intuit bank ID Quicken needs, the account, period, balances and every transaction, and exports them to Excel or CSV. It flags the problems that make Quicken reject or skip a download: a missing bank ID, duplicate transaction IDs and dates outside the statement period.
Good to know: your statement is processed on this device; nothing is sent to any server.
🔒 Nothing is uploaded — your bank data never leaves this deviceOn this page
What is a QFX file?
A QFX file is an OFX (Open Financial Exchange) statement with Quicken-specific additions, mainly the <INTU.BID> tag that identifies the bank to Quicken. Quicken calls these downloads Web Connect files. They contain your account, the statement period, the balance and every transaction with a unique ID, so Quicken can match them and skip duplicates.
Not every bank offers QFX: Web Connect downloads come from financial institutions that support Quicken. If your bank only offers OFX, CSV or QBO, see the fixes below.
| .qfx | .ofx | .qbo | |
|---|---|---|---|
| Made for | Quicken | Any finance app | QuickBooks |
| Intuit bank ID | Yes | No | Yes |
| Quicken for Windows imports it | Yes | No | No |
| Inside | The same OFX tags and transactions | ||
How to open a QFX file: quick answer
| What you want | Use |
|---|---|
| Add it to Quicken | File > File Import > Web Connect File |
| Read it without Quicken | The viewer above |
| Excel / Google Sheets | Viewer above > Download Excel or CSV |
| QuickBooks Online | Bank transactions > Upload from file (QFX accepted) |
| GnuCash | File > Import > Import OFX/QFX transactions |
Import a QFX file into Quicken
- Open Quicken and back up your data file (File > Backup and Restore).
- Choose File > File Import > Web Connect File (Quicken for Windows).
- Select the .qfx file and click OK.
- Link it to an existing Quicken account, or create a new one. Quicken remembers the link for future downloads from the same account.
- Review and accept the downloaded transactions in the account register.
Many banks also let you double-click the downloaded QFX to send it straight to Quicken. On Quicken for Mac, use the File > Import menu and choose the bank download (Web Connect) option.
Convert QFX to Excel or CSV
- Drop the .qfx into the viewer at the top of this page.
- Check the account, period and totals in the summary.
- Click Download Excel (.xlsx) or Download CSV. Each transaction becomes one row with date, description, amount, type, memo, check number and the transaction ID.
The conversion happens on your device, so the account details in the file aren't sent anywhere. That matters: many "QFX to CSV" websites upload your statement to their servers.
Open QFX files in QuickBooks, GnuCash and other apps
- QuickBooks Online: Bank transactions > Link account > Upload from file. QBO is preferred, but QFX, OFX and CSV are accepted.
- QuickBooks Desktop: expects .qbo Web Connect files. A QFX usually won't import; ask the bank for the QuickBooks download or use the CSV from the viewer.
- GnuCash (free): File > Import > Import OFX/QFX transactions.
- Moneydance, Banktivity, YNAB: use their file import; they read QFX like OFX.
QFX problems and fixes
Quicken says the bank or file isn't supported
Quicken checks the Intuit bank ID (INTU.BID) inside the file. The viewer shows it: if it's missing, the file isn't a real QFX (perhaps a renamed OFX), and Quicken for Windows won't import it. Download the Quicken option from the bank again, or set up the account with Quicken's online connection.
Some transactions don't appear
Quicken skips transactions whose ID (FITID) it has already seen. The viewer flags repeated IDs; if the bank reused them, those transactions must be entered by hand.
The file links to the wrong account
Quicken matches by account number. Open the wrongly linked account's details, deactivate it on the Online Services tab, and import the file again to choose the right account.
Old dates or a very long range
Many banks limit how far back a Web Connect download can go, often only a few months. For older history, download CSV or PDF statements from the bank.
Double-clicking opens the wrong program
Right-click the file > Open with > Quicken, or import it from Quicken's File menu.
Sources and technical references
- How do I import data into Quicken for Windows? (Web Connect, QIF, CSV) — Quicken
- Web Connect troubleshooting (Mac) — Quicken
- Manually upload transactions into QuickBooks Online — Intuit
- Importing transactions from files (OFX/QFX) — GnuCash Manual
- OFX Work Group — Financial Data Exchange
Frequently asked questions
How do I open a QFX file?
In Quicken for Windows, choose File > File Import > Web Connect File and select the QFX. Without Quicken, drop it into the viewer on this page to see every transaction and convert it to Excel or CSV.
How do I convert QFX to Excel or CSV?
Open the QFX in the viewer on this page and click Download Excel (.xlsx) or Download CSV. The conversion runs in your browser, so your account details aren't uploaded.
Why won't Quicken import my QFX file?
Usually the file has no Intuit bank ID (INTU.BID), so it's really a renamed OFX, or the bank doesn't support Quicken Web Connect. The viewer on this page shows whether the bank ID is present. Download the Quicken option from the bank again.
What's the difference between QFX and OFX?
A QFX is an OFX file with Quicken-specific tags, mainly the Intuit bank ID. Quicken for Windows imports QFX but not plain OFX; most other finance apps read both.
Can I open a QFX file in QuickBooks?
QuickBooks Online accepts QFX uploads in Bank transactions. QuickBooks Desktop expects .qbo Web Connect files, so ask the bank for the QuickBooks download or upload a CSV instead.
Why are some transactions missing after importing?
Quicken skips transactions whose ID it has already imported. If your bank repeats IDs, those transactions are lost. The viewer flags duplicate IDs so you can add them by hand.
Can I open a QFX file without Quicken?
Yes. The viewer on this page shows the full statement, and GnuCash, Moneydance and YNAB can import QFX files. You can also convert it to Excel.
Is a QFX file safe?
It's plain text with your account data and can't run code. Treat it as private: don't upload it to converters that send files to their servers.
Last updated .