# QIF to CSV and Excel

Upload a .qif file and download a CSV — or an Excel workbook — with one row per transaction: date, description and signed amount in their own columns. A QIF is a list of tagged lines rather than a table, so this is the quick way to read it in a spreadsheet, check it before an import, or hand the transactions to someone without Quicken.

## What the CSV contains

- A header row, then one row per transaction in the QIF
- Date as YYYY-MM-DD, whatever order the QIF wrote it in
- Payee and memo joined into one Description cell
- A signed amount: money out negative, money in positive, as the QIF has it
- Plain UTF-8 text, readable without Quicken installed

## QIF to Excel

Choose Excel instead of CSV in the format menu above and the same rows come out as an .xlsx workbook, amounts stored as numbers you can sum and filter. Opening a .qif in Excel directly gives you one tag per row — D03/04/2026, T-38.40 — not a table.

Going the other way, a spreadsheet into QIF, is the [CSV to QIF converter](https://statementconverterai.com/csv-to-qif).

## How QIF lines become columns

A bank or card QIF holds one block per transaction, ended by a caret:

| QIF line | CSV column | Notes |
|---|---|---|
| `D` | Date | As YYYY-MM-DD. Day-first or month-first is decided for the whole file from the dates that can only be read one way. |
| `P`, then `M` | Description | Joined into one cell, for example “Corner Grocer — Card payment”. |
| `T` | Amount | Signed as the file writes it. |
| `N`, `L` and split lines | — | Check numbers, categories and splits are Quicken bookkeeping rather than statement data, and are left out. |
| `!Type:CCard` | — | The file is read as a credit card account; the amounts keep their signs. |

```
!Type:Bank
D03/04/2026
T-38.40
PCorner Grocer
MCard payment
^
```

One transaction in a QIF file. Quicken’s shorthand dates, such as 3/4'26, are read too.

Investment QIFs (`!Type:Invst`) hold trades rather than transactions and are refused with a message. Each QIF file counts as one page, so the first 3 files of your first upload convert free.

## How to convert

1. **Upload the QIF file** — Drop in the .qif from your bank, Quicken, Microsoft Money or another finance app. Several files can go in at once.
2. **Pick CSV or Excel** — CSV is selected on this page; switch to Excel for an .xlsx workbook.
3. **Open the spreadsheet** — Check the rows in Excel, Numbers or Google Sheets.

## Frequently asked questions

### How do I convert a QIF file to CSV?

Upload the .qif above, keep CSV selected and download the file. Every transaction becomes one row with date, description and amount.

### Can I convert a QIF file to Excel?

Yes. Choose Excel in the format menu before converting and you get an .xlsx workbook with the same rows, amounts stored as numbers.

### How do I open a QIF file?

Finance apps such as GnuCash, Moneydance and Quicken import it. To read it anywhere else, convert it to CSV or Excel — in a text editor or straight in Excel you see the tagged lines, not a table.

### What does it leave out?

Categories, check numbers and split lines. They are Quicken bookkeeping rather than statement data; the date, payee, memo and amount of every transaction are kept.

### Is it free?

Each QIF file counts as one page, and the first 3 pages of your first upload are free. After that it is $0.20 a file with a $3.90 minimum per batch.

### Is my file kept after conversion?

No. The file is deleted when the conversion finishes; only the converted copy stays at your private link.

## Related

- [CSV to QIF](https://statementconverterai.com/csv-to-qif)
- [QIF to QBO](https://statementconverterai.com/qif-to-qbo)
- [QBO to CSV](https://statementconverterai.com/qbo-to-csv)
- [What is a QIF file?](https://statementconverterai.com/guides/what-is-a-qif-file)
- [All bank statement converters](https://statementconverterai.com/)