QIF to Excel Converter
Convert QIF to Excel in your browser and get one sheet of transactions, categories included, with nothing uploaded.
Your financial data stays in your browser.
How to Convert QIF to Excel
A .qif file is not a spreadsheet. It is a list of transactions written as plain text, one record after another, so Excel opens it as a wall of text with no columns in it. Nothing here needs installing or signing up for: the file is read in your browser and the sheet is built there too.
- 1Choose your .qif file, or drag it onto the drop area
- 2Let the browser read the records; nothing is uploaded, and the file never leaves your machine
- 3Download the .xlsx, or the .csv if you would rather have plain text
You get one worksheet named Transactions, one row per transaction, and seven columns at most. A date or an amount the file wrote in a way this could not read is carried over as the text it was, rather than guessed at or thrown away. An investment section is the one thing left out, and the result says so when that happens.
What a QIF File Looks Like Inside
A QIF file is older than XML and it shows. There is no schema, no header, no quoting and no delimiters. A record is a run of plain lines, and the first character of each line says what the rest of that line is. Once you know that much, a .qif stops looking like noise. Here is the shape of a single transaction: a D line carrying the date, a T line carrying the amount, a P line carrying the payee, sometimes an M line with a memo and an L line with the category, and then a caret on a line of its own, which closes the record. That caret is the only structural punctuation the format has. Everything between two carets belongs to one transaction. Files are usually organised into sections. An account block near the top names the account the records came from, and a line beginning !Type: opens each section: !Type:Bank for a current account, !Type:CCard for a card, !Type:Cash for cash. Quicken writes the same shape for all of them. A QIF to Excel conversion can only work with what a file actually holds, which is why the rest of this page is as specific as it is.
The format is old, but it is not abandoned: Quicken's own help still documents exporting data to a QIF file, while noting that QIF is a legacy format being replaced over time by QXF.
The Letters a QIF Record Uses
Every QIF file is written in the same small alphabet, and it is worth knowing even if you never edit one by hand. The letter in front of a value is where the sheet got it, and it is the thing to look at when a QIF to Excel conversion leaves a cell as the text the file wrote rather than as a value it could read. The same values are written by the plain CSV version of this page, if a table without a workbook is what you are after.
| Line begins with | What it carries |
|---|---|
| D | The date. Quicken writes it as 3/4/2026, and the file carries no clue whether that means March 4th or the 4th of March. |
| T | The amount. Money out is negative in most files, but not in every one, which is why the converter reads the sign rather than assuming it. |
| P | The payee: the name that appears on the register line. |
| M | A memo or note, when the bank sent one along with the transaction. |
| L | The category, or the account the money moved to when the record is a transfer. Nested categories arrive as Parent:Child. |
| N | The check or reference number. In a card download this line is often simply absent. |
| ^ | Not a field at all. The caret ends the record, and everything since the previous caret belongs to one transaction. |
| !Type: | Also not a field. It opens a section: Bank, CCard, Cash, Oth A, Oth L, or Invst. Only the transaction sections are read. |
| !Account | The account block, whose N line names the account its section belongs to. The converter copies that name into the Account column. |
QIF, CSV and OFX: Three Ways to Write Down a Transaction
All three of these formats answer the same question, which is how you write a transaction down so that another program can read it. They answer it three different ways, and the differences explain almost every problem people run into when they try to open one of these files in Excel. A CSV is a grid. Commas separate the fields, the first line names them, and every spreadsheet has read that shape for decades. Because it already is a grid, Excel opens it directly. QIF is the oldest of the three. It dates from a time when files were read line by line, and it was built to be legible rather than to be parsed: a letter at the start of each line, a caret at the end of each record. It carries fields that a bank's CSV export often leaves out, such as the category and the check number. What it does not carry is a running balance or a currency. OFX came later, and it is what most banks export today. It is also a record stream rather than a grid, but its records are tagged with readable element names instead of single letters. So Excel opens a CSV directly and cannot open a .qif or an .ofx directly, because neither one has rows until something reads the records and lays them out. That laying out is the whole job here: a QIF to Excel conversion flattens records into rows, and invents nothing that was not already in the file. OFX is the one most banks hand out today. If that is what you actually have, OFX to Excel reads those files and writes the same kind of sheet.
QIF is the older of the two, and it is still in use. See the format's background, which notes that QIF predates OFX and remains widely used.
What the Sheet Lets You Do
Once a QIF to Excel conversion has run, the records are rows, and the things you would otherwise do by eye become column operations.
- Check the sheet against the balance your bank or Quicken shows for the same account
- Total a year of spending by category, which is the field a bank CSV usually leaves out
- Filter to a single payee across several years without reading through the text
- Sort by amount to find the largest transactions in a statement you have not looked at since it arrived
- Hand your accountant a spreadsheet instead of a file they might not be able to open
- Keep a copy that still opens after the Quicken file behind it is gone
What Does Not Make It Into the Sheet
A QIF file can hold things a transaction table cannot, and a converter that quietly invents a row for them is worse than one that says so. This one says so: an investment section is left out with a note in the result, and a date or an amount it cannot read is carried over as the text it was. It also only reads: there is no way here to produce a .qif file, so a spreadsheet cannot be turned back into one. That is a different tool, and CSV to QIF is where it lives.
Questions About QIF Files
Choose your .qif file, let the browser read it, then download the .xlsx. If you would rather have a plain text table, the same result downloads as .csv as well. There is no sign-up and nothing is uploaded.
No. A .qif is a series of records closed by carets, not a table, so Excel shows you the raw text instead of rows and columns. Converting it first is what gives Excel something it can read.
A CSV is a grid with a header line and comma-separated fields, and almost everything reads it. A QIF is a record format from Quicken: each field is marked by a letter at the start of a line, and each record ends at a caret. A QIF can carry categories and check numbers that a plain bank CSV usually leaves out.
Yes. Quicken still exports it, and its help pages still document how. The format is older than OFX, but it remains widely used. Old is not the same as gone.
Date, Amount, Name, Memo, Category and Transaction ID, in that order, because those are the fields the records carry, plus an Account column when the file names the account. That is the set of columns a QIF to Excel conversion here writes, whoever produced the file. QIF has no transaction-type field, so there is no Type column giving you a column full of nothing.
Not for reading it. The format is the same whoever wrote it, and every transaction section is converted: Bank, CCard, Cash, Oth A and Oth L. What does differ between files is how much they carry, since some send a category and a memo with each transaction and others send only the date and the amount.
Yes. Quicken writes .qif files when it exports a data file, so a QIF to Excel conversion is the way to get those transactions into a spreadsheet. The same converter also reads the .qif files that some banks and other programs produce.