How to Open a QIF File on Windows, Mac, and in Excel
No account needed for your first conversions. We never store your bank login.
You can open a QIF file in any text editor, such as Notepad on Windows or TextEdit on Mac, because it is plain text. But it will look like a list of short tagged lines, not a table of transactions. To open it as a readable ledger, you convert it to CSV, Excel, or a format your accounting app imports. That gap, between opening the file and actually using it, is what trips most people up, so this guide covers both.
QIF stands for Quicken Interchange Format. It is a legacy export format Intuit built in the 1990s, and it stores each piece of a transaction on its own line with a single-letter tag in front: D for date, T for amount, P for payee, M for memo, and ^ to mark the end of a record. That structure is easy for old software to read and hard for a human to scan. For the full background on the format, see what a QIF file is.
How do I open a QIF file?
Right-click the .qif file, choose Open With, and pick a plain-text editor: Notepad or Notepad++ on Windows, TextEdit on Mac, or any code editor. The file will open instantly and show every transaction as a run of tagged lines. This is the quickest way to confirm the file has data in it and to see roughly how many transactions it holds, but it is not a practical way to read or work with the transactions, because nothing lines up into columns.
If double-clicking the file launches Quicken or prompts you to buy Quicken, that is just the file association. Opening it in a text editor instead does not change the file and does not require any finance software.
How to open a QIF file on Windows
On Windows, the reliable path is a text editor for a quick look and a converter for real use. Open Notepad, then drag the .qif file onto the Notepad window, or use File then Open and switch the file-type dropdown to All Files so the .qif shows up. Notepad++ is better if the file is large, because it handles tens of thousands of lines without slowing down and shows line numbers, which helps if you are checking a specific transaction.
To turn the file into a spreadsheet or load it into accounting software, use a converter rather than Notepad. Upload the .qif to the QIF to CSV converter and you get back a comma file, an Excel workbook, and a QuickBooks-ready QBO file, all with the dates and amounts already split into columns.
How to open a QIF file on Mac
On Mac, open TextEdit, choose File then Open, and select the .qif file. If TextEdit tries to hide the file, press Command-Shift-Period to show all file types. The transactions appear as the same tagged lines you would see on Windows. Quicken for Mac can also import a QIF into an account through File then Import, though newer Quicken releases limit QIF import to certain account types, so many Mac users convert the file first.
If your goal is to load the transactions into a Mac finance app such as Banktivity or MoneyDance, convert the QIF to OFX first with the QIF to OFX converter. OFX is the format those apps import cleanly, where a raw QIF is often rejected.
How do I open a QIF file in Excel?
You cannot open a QIF file in Excel as a proper table by double-clicking it. Because QIF stores each field on its own tagged line instead of in columns, Excel shows a single column of values like D01/15/2026 and T-42.19 stacked on top of each other, with no way to sort or total them. Excel has no idea that a date line and the amount line below it belong to the same transaction.
There are two ways to get a real spreadsheet. The manual route is to rename the file to .txt, walk it through Excel's Text Import Wizard, and then reassemble each transaction from its scattered tag lines by hand, which is slow and error-prone on anything larger than a handful of records. The practical route is to convert first: drop the .qif into the QIF to Excel converter, and it rebuilds the tagged lines into one row per transaction with Date, Payee, Memo, Category, and Amount in their own columns, as real numbers you can sum and pivot.
What program opens a QIF file?
Several programs open or import QIF: Quicken itself, Microsoft Money (discontinued, though still installed and running on some machines), GnuCash, Moneydance, and Banktivity all read the format to some degree. Any text editor opens it for viewing. But opening and using are different things: most of these apps import a QIF into a register rather than showing it as an editable table, and support for QIF has narrowed over the years, especially for bank and credit card accounts. When you need the raw transactions in a spreadsheet or in QuickBooks, a converter is the dependable option because QuickBooks does not accept QIF at all.
Why does my QIF file show the wrong dates?
QIF carries no date-format declaration, so the same line, 03/04/2026, means March 4 to a US-formatted file and April 3 to a European one, and any reader has to guess which was intended. Quicken also writes two-digit years with a leading apostrophe, as in D01/15'26, which most spreadsheet tools misread as text. A good converter scans every date in the file to work out the real format before it writes a single row, which is why converting produces dates that survive an import instead of dates silently shifted by nine months.
| Program | Opens a QIF? | What you get |
|---|---|---|
| Notepad, TextEdit, any code editor | Yes | The raw tagged text. Good for checking the file is not empty |
| Quicken for Windows | Imports | Transactions, but only into asset, liability and cash accounts |
| Quicken for Mac | No | QIF support ended with Quicken Mac 2007 |
| QuickBooks Online | No | Accepts CSV, QBO, QFX and OFX only, so QIF has to be converted first |
| QuickBooks Desktop | No | Reads QBO through Web Connect, not QIF |
| Excel or Google Sheets | Not as a table | One tagged value per row until the file is converted to CSV |
| GnuCash, Moneydance, Banktivity | Imports | Register transactions, mapped to their own accounts |
| Microsoft Money Plus Sunset | Imports | Loose QIF into an existing .mny file |
How do I read a QIF file?
Read it by the tag at the start of each line. A QIF record uses one letter per field: D is the date, T is the amount, P is the payee, M is the memo, L is the category, N is the check number, and a caret on its own line ends the record. The header line, such as !Type:Bank or !Type:CCard, tells you which register the block belongs to.
So a five line block that reads D07/14/2026, T-42.18, PShell Oil, LAuto:Fuel and then a caret is a single 42 dollar 18 cent fuel purchase. Once you can see that pattern, scanning a QIF in a text editor to check the date range or spot a truncated file takes about ten seconds. What it will not give you is a total, a sort, or anything you can hand to an accountant.
What is the difference between a QIF and a QFX file?
QIF is Quicken's old plain text register format with no fixed date rule and no transaction IDs. QFX is Intuit's XML based Web Connect format, carrying a bank ID, an account ID and a unique ID per transaction, which is why software can import it without duplicates. Banks issue QFX and QBO today; QIF is what old software exports. The OFX vs QFX vs QBO vs QIF comparison lays out all four side by side.
How do I import a QIF file into Quicken?
In Quicken for Windows, go to File, then File Import, then QIF File, pick the file and choose the destination account. Quicken's QIF import only accepts asset, liability and cash accounts, so a QIF aimed at a bank or credit card register is often refused. Quicken for Mac has no QIF import or export at all, which surprises people migrating between platforms.
Can I open a QIF file without Quicken?
Yes. Nothing in the format is licensed to Quicken, and the file is plain text, so any editor shows you the contents and any converter can rewrite it. Most people asking this question do not want to buy a subscription just to read one export, and they do not have to. Convert the QIF to the format their current software already accepts and skip Quicken entirely.
How do I convert a QIF file to CSV or Excel?
Upload the file to the QIF to CSV converter and download a normal spreadsheet with date, payee, memo, category and amount in their own columns, splits included. For accounting software, convert to QBO instead with the QIF to QBO converter, which is what QuickBooks reads. Both routes leave the original .qif untouched on your machine.
From a QIF file to something you can use
Opening a QIF is easy; the real question is what you need to do with the transactions. If you just want to confirm the file is not empty, a text editor answers that in seconds. If you need to read, sort, or hand off the data, convert it to Excel or CSV. If it is headed for QuickBooks, the export Quicken data to Excel writes a Web Connect file that imports as a bank feed. And if you are working from paper or PDF statements rather than a QIF at all, a bank statement converter can turn those documents into the same clean data first. Every one of these runs the transactions through a reconciliation check, so the totals in what you open match the totals in the file you started with.