How to convert QIF to Excel
- 1
Drop the QIF file
QIF files are read as they are: dates, payees, memos, amounts and IDs.
- 2
Review the transactions
Edit a date, a payee or an amount, flip a sign or delete a line before converting.
- 3
Download Excel
Pick the date format you need in Export settings. Any other format is one click away too.
The formats
- QIF
- Quicken Interchange Format, an older plain-text format with one field per line (D date, T amount, P payee, M memo). GnuCash, Moneydance and many smaller apps still import it; current Quicken for Windows only takes QIF into some account types.
- Excel
- An Excel workbook (.xlsx) with real dates and numbers, so sorting, filters, SUM and pivot tables work straight away. It also opens in Google Sheets, Numbers and LibreOffice.