What is a QIF file?

A QIF file (Quicken Interchange Format) is a plain text file finance programs use to exchange accounts, transactions, and categories. Quicken popularized it, and it is still how most personal finance apps move history between programs.

The QIF file format, line by line

QIF is one of the simplest financial formats ever shipped: plain text, readable by people as well as programs. A file is divided into sections that each start with a header line such as !Type:Bank for a checking or savings account, !Type:CCard for a credit card, !Type:Invst for an investment account, or !Type:Cat for a category list. Inside a section, each line starts with a single code letter that says what the rest of the line means, and a ^ on its own line ends each record:

• D is the date.
• T is the amount.
• P is the payee or description.
• L is the category, or an account name in brackets when the entry is a transfer.
• M is a memo, and N is a check number, or the action (Buy, Sell, Div) in investment accounts.
• S and related codes carry the lines of a split transaction.

The header line tells the reader what kind of records follow it. These are the section headers you will meet in a QIF file:

• !Type:Bank holds the transactions of a checking or savings account. TallyMint imports it.
• !Type:Cash holds the transactions of a cash account. TallyMint imports its transactions into the account you pick in the import plan.
• !Type:CCard holds the transactions of a credit card account. TallyMint imports it.
• !Type:Invst holds an investment account: buys, sells, dividends, and similar actions. TallyMint imports it.
• !Type:Oth A holds an other-asset account, such as a house or a car. TallyMint imports its transactions into the account you pick in the import plan.
• !Type:Oth L holds an other-liability account, such as a loan or a mortgage. TallyMint imports its transactions into the account you pick in the import plan.
• !Type:Cat is the list of categories, one record per category, which can be marked as income or expense. TallyMint reads it.
• !Type:Class is the list of classes, a second way Quicken tags transactions. TallyMint skips it.
• !Account lists the accounts in the file, with a name and a type for each, ahead of the transactions that belong to them. TallyMint reads it.

!Type:Bank
D9/15'26
T-126.00
PCity Power & Light
LBills & Utilities:Utilities
^
D9/16'26
T-200.00
PTransfer to Savings
L[Savings]
^

Dates are the format's weak spot: QIF never standardized month/day order or four-digit years, and Quicken itself writes quirks like space-padded days and apostrophe year separators (MM/DD'YY). Programs importing QIF have to guess or ask. TallyMint reads QIF dates in US month/day/year order and normalizes the quirks automatically.

How to open a QIF file

Because it is plain text, any text editor opens a QIF file: Notepad on Windows, TextEdit on a Mac. That is genuinely useful for a quick look at what a file contains before importing it. To actually use the data, you want a program that understands the format, which means personal finance software. TallyMint imports QIF files whole: accounts, transactions, categories, splits, transfers, and investment history. The QIF import guide walks through it step by step.

Both versions of TallyMint import QIF and both start with a free 30-day trial, no card needed: TallyMint for Windows, or TallyMint Web in any browser, including on a Mac.

How to open a QIF file in Excel, or convert it to CSV

Excel does not understand QIF. Open one directly and you get a single column of code letters rather than a table, because QIF puts one field per line instead of one transaction per row. There is no clean one-click route, so the practical options are:

• Import the QIF into a finance app, then export CSV. TallyMint imports the QIF and exports any account register or report to CSV, which Excel opens natively. This route keeps splits and transfers intact.
• Use a file converter. Utilities exist that convert QIF to CSV directly; results vary with the date quirks above, so check a few rows against the source.

QIF vs QFX, OFX, and CSV

QIF predates online banking, and it shows: it carries no bank connection details and no unique transaction IDs. That is why banks replaced it for downloads with OFX and QFX (the flavor Quicken reads), whose built-in IDs make duplicate detection reliable. CSV is simpler still: a plain table with whatever columns the exporter chose, and no standard for what they mean.

• QIF is best for moving history between finance programs. It is the format most likely to carry accounts, categories, splits, and transfers together.
• OFX / QFX are best for bank downloads when your bank offers them.
• CSV works when it is all you have; TallyMint finds the header row for itself, including in files that start with a few lines of account information above it, and recognizes the common ways columns get named.

TallyMint imports all of them from the same place: Settings → Import / Export. It also exports your whole file back out as QIF, so your history is never locked in.

Can Quicken still open QIF files?

Quicken still exports QIF, which is why so much financial history ends up in the format. Importing is the catch: since the mid-2000s, US versions of Quicken for Windows have restricted QIF import for most everyday account types, so a QIF file often cannot go back into the program that made it. Check Quicken's own help for what your version allows. If the goal is to keep using your history, importing the QIF into a program that accepts it fully, TallyMint included, is usually the shorter path.

Moving to a new finance app with a QIF file

If the QIF file in front of you is your own financial history and you are deciding where it should live next, that is the exact migration TallyMint was built to receive. The import shows a plan first, one row per account, so you choose where everything lands; categories arrive typed as income or expense the way the file has them; transfers pair up; and re-importing the same file later is safe because duplicates are skipped. The moving off Quicken guide covers the whole switch end to end, and the Quicken alternative page explains where TallyMint fits.

Frequently asked questions

Related: Import a QIF file · How to move off Quicken · A Quicken alternative with no subscription · Moving from another finance app