QIF to CSV Converter
Turn a Quicken QIF file into a CSV spreadsheet you can open in Excel, Numbers or Google Sheets, or import into another program.
or click to choose one
No file handy? Try it with the sample QIF.
How to convert a QIF file to CSV
- Export a QIF file from Quicken or another finance program (see below).
- Drop the file into the box above.
- Choose a date style and whether you want one amount column or separate withdrawal and deposit columns.
- Check the preview, then download the .csv file and open it in your spreadsheet.
What is a QIF file?
QIF (Quicken Interchange Format) is a plain text format Intuit created for Quicken in the early 1990s. Each transaction is a short block of lines, one field per line, ending with a caret. Programs still use it to move data between finance apps, and Quicken can export a whole data file to QIF, which makes it a common way to get years of history out of Quicken.
Exporting a QIF file from Quicken
Quicken for Windows
Choose File > Export > QIF File. Pick one account or all accounts, set the date range, and tick Transactions.
Quicken 2007 for Mac
Choose File > Export and pick the QIF format. Newer Quicken for Mac versions export to CSV directly, so check the File menu first.
Other programs
GnuCash, Banktivity, Moneydance and many older finance programs can also write QIF files, usually under File > Export.
What ends up in the CSV
| CSV column | QIF line | Notes |
|---|---|---|
| Date | D | Quicken's short dates like 10/15'26 are expanded to 2026 |
| Account | !Account N | Only when the file contains named accounts |
| Check Number | N | |
| Payee | P | |
| Memo | M | Split memos (E) when using one row per split |
| Category | L or S | Transfers keep Quicken's [Account Name] brackets |
| Amount | T or U | Negative is money out |
| Cleared | C | * or c is Cleared, X or R is Reconciled |
Things to know
- Category and class. Quicken writes a class after a slash, like
Travel/Business. It is kept as written so you can split it in your spreadsheet if needed. - Lists are skipped. QIF exports often start with category, class and memorized payee lists. Only transactions go into the CSV.
- Excel and long numbers. If Excel shows check numbers or amounts oddly, use Data > From Text/CSV to import the file instead of double-clicking it.
Sample file
The sample QIF is a small Quicken-style export with a checking account and a credit card, a split paycheck, a transfer and an accented payee name. Drop it in the box above to try the converter.
Frequently asked questions
- Is my QIF file uploaded anywhere?
- No. The conversion runs in your web browser. Your file is never sent to ConvertDepot or anyone else, and the page keeps working if you disconnect from the internet after it loads.
- My QIF file has several accounts. What happens?
- Quicken's "export all" files include every account in one file. The CSV gets an Account column so you can sort or filter by account in your spreadsheet.
- How are split transactions handled?
- By default each transaction is one row, with the split categories listed together in the Category column. Tick "One row per split line" to get a separate row for each part of the split, with its own category and amount.
- Does it convert investment accounts?
- No. Investment transactions use a different layout, with securities, shares and prices. They are counted and skipped, and the converter tells you how many.
- Why do accented letters look right in Excel?
- Quicken usually saves QIF files in an older Windows text encoding. The converter detects that and writes the CSV as UTF-8 with a marker Excel recognizes, so names like "Café" come through intact.
- The dates look wrong.
- QIF files don't say whether dates are month first or day first. The converter guesses from your data, but if every day in the file is 12 or under it can't tell. Change "Dates in the QIF file are" in step 2.