What is QFX file format and how to open it?

The QFX format is a file format used for importing and exporting financial data, such as transactions and account information. It is an open standard. Many personal finance and accounting programs support it.

Why the QFX format is used?

QFX is based on the OFX (Open Financial Exchange) format. OFX is a widely used standard for sharing data between banks and software. Like OFX, QFX files carry transactions and account details between banks and personal finance programs.

A key strength of QFX is that it's an open standard. No single bank or software company owns it. This makes it easy to share data no matter which programs you use.

QFX files can also hold other financial data, like investment and tax information. This makes QFX useful for tracking a wide range of financial records.

Use ProperConvert to access or convert transaction files from QFX and to the QFX format.

How to open a QFX file in Excel

QFX is mainly used to import data into programs like Quicken. To work with a QFX file in Excel, convert it to CSV or Excel first.

Use the ProperConvert app to convert your transaction files to CSV/Excel formats.

How to view or open a QFX file

Download and install the ProperConvert app
Start the app and locate a QFX file
Review transactions
Click Save to save a CSV file. Then open it in Excel or another spreadsheet app. Or click Copy to clipboard, switch to Excel, and click Paste.

Supported Account types

Bank (Checking/Savings/Credit Line)
Credit Card
Investment

Differences for Quicken for Windows and Quicken for macOS

The main difference between Quicken for Windows and Quicken for Mac is how the Memo field from a QFX file is imported:

Quicken for PC imports QFX memo into the transaction memo field. This field is fully editable.
Quicken for Mac imports QFX memo under the read-only "FI Notes" column.

Quicken Sunset policy

QFX format is the format to import transactions into Quicken.

Quicken must be no more than three years old to import ".QFX" files. See the Quicken sunset policy for details.

For older Quicken versions, use QIF format or a converter that outputs QIF.

Quicken (PC or Mac) imports QFX files through File->Import->Web Connect

Learn More

OFX - What Is OFX File Format and How to Open it?
QIF - What is QIF file/format and how to open it?
Quicken - How To Import QIF or QFX into Quicken