What a QFX file is
QFX is Quicken’s version of OFX. Inside, it’s an ordinary OFX statement with one addition: an INTU.BID tag carrying the Intuit ID of the bank, which Quicken uses for its Web Connect downloads. Banks offer it as “Quicken”, “Quicken Web Connect” or simply “QFX”. If you don’t use Quicken — or have stopped using it — the file still holds a perfectly good transaction history, and converting it is the quickest way to read it.
QFX to Excel or QFX to CSV
The converter on this page starts with Excel workbook (.xlsx) selected. For QFX to CSV, switch step 3 to Clean CSV (all columns); the columns are the same. Choose Excel when you want to work in the data, and CSV when you’re feeding it into another app that only accepts CSV.
Convert a QFX file
- In online banking, download the account’s activity in the Quicken (QFX) format, or find an old .qfx file on your computer.
- Drop it on the converter. You’ll see the transaction count, the date range and the money in and out.
- Download the workbook or CSV. Nothing is installed and you don’t need Quicken.
Columns in the converted file
| Column | What it holds |
|---|---|
| Date | The date each transaction posted. |
| Description | The payee (NAME) followed by any memo text. |
| Debit and Credit | Money out and money in, both positive. |
| Amount | A single signed amount, negative for money out. |
| Check No. | Cheque numbers, when the bank includes them. |
Why people convert QFX files
- Leaving Quicken. Years of downloaded QFX files become readable spreadsheets you can keep or import elsewhere.
- A bank that offers QFX but no CSV for older periods.
- Moving to QuickBooks or Xero. Convert the same QFX into a QuickBooks CSV or Xero statement file from the list in step 3.
Problems you might hit
- Quicken says the file is from an unsupported bank. That’s a Quicken account-matching problem, not a damaged file; converting it to Excel still works.
- The file contains several accounts. Their transactions are combined; download accounts separately to keep them apart.
- Pending transactions are missing. QFX downloads usually include posted transactions only.
Keeping an archive of old QFX downloads
If you’ve used Quicken for years, you may have a folder of QFX files named by date. Convert each to Excel and save the workbooks alongside them: unlike the QFX files, they’ll open on any computer without Quicken. To build one long history, combine the converted workbooks with Combine CSV and Excel files, which lines up the columns and drops transactions repeated where two downloads overlapped.
Have a QuickBooks Web Connect file instead? Use QBO to Excel. Our guide to OFX, QFX and QBO files explains how the three differ.
Frequently asked questions
Do I need Quicken to open a QFX file?
No. Converting the QFX to Excel or CSV lets you read every transaction in a spreadsheet without Quicken.
What is the difference between QFX and OFX?
A QFX file is an OFX file with an extra Intuit bank ID tag for Quicken. The transactions inside are the same.
How do I convert QFX to CSV?
Drop the QFX file on the converter and choose Clean CSV (all columns) in step 3 before downloading.
Is my QFX file uploaded?
No. It is converted in your browser and the result is saved to your device.
Can I turn a QFX file into a QuickBooks file?
Yes. Choose a QuickBooks Online CSV or QBO (Web Connect) in step 3.