What is a QIF File? How to Open, Convert, and Import One

What is a QIF File?

A QIF file (Quicken Interchange Format) is a plain-text file used to store financial transaction data. Developed by Intuit in the late 1980s for Quicken, it became one of the earliest standards for exchanging financial data between applications.

Despite being over 30 years old, QIF is still in active use. Many banks still offer QIF downloads, and Quicken (the personal finance software) still imports them. The format is simple enough that it has outlasted dozens of more sophisticated standards.

What Does a QIF File Look Like?

A QIF file is plain text with single-letter field codes:

!Type:Bank
D01/15/2024
T-125.00
PStarbucks
^
D01/16/2024
T2500.00
PDirect Deposit - Payroll
^

Each transaction ends with a caret (^). Field codes:

The !Type: header declares the account type: Bank, CCard, Invst, Cash, etc.

How to Open a QIF File

QIF files are plain text — you can open them in any text editor (Notepad, TextEdit, VS Code). However, the raw format isn't human-readable at a glance. For viewing transactions, your options are:

1. Import into Quicken — the native application
2. Convert to CSV — use the QIF to CSV converter, then open in Excel or Google Sheets
3. Convert to QBO — use the QIF to QBO converter to import into QuickBooks Online

How to Convert QIF to CSV

If you want to view or analyze your QIF transactions in Excel:

1. Go to the QIF to CSV converter
2. Upload your QIF file
3. Download the CSV
4. Open in Excel (Data > From Text/CSV) or drag into Google Sheets

The output includes four columns: Date, Amount, Payee, Memo.

How to Convert QIF to QBO (for QuickBooks)

If you need to import QIF transactions into QuickBooks Online:

1. Go to the QIF to QBO converter
2. Upload your QIF file
3. Download the QBO file
4. In QuickBooks Online: Banking > Upload transactions > select the QBO file

QIF vs QBO vs OFX: What's the Difference?

QIF is the oldest and simplest. OFX, QFX, and QBO are all based on the same newer standard — they're structured SGML/XML with richer metadata and unique transaction IDs (FITIDs) that prevent duplicate imports.

Which Banks Still Export QIF?

Many smaller banks, credit unions, and older financial applications still offer QIF. Look for download options labeled "Quicken (2005 and earlier)", "Quicken for Windows 2004", or just "QIF" in your bank's export menu.

If your bank offers both QIF and OFX/QFX, prefer OFX — it includes FITIDs that prevent duplicate imports and handles more account types correctly.