How to convert QIF to Excel
- Drop your QIF file on the box above, or paste its content into the text box.
- Choose how the dates in the file are written. The tool lists the orders that fit every date, but you make the choice.
- Press Convert. Every amount and date is checked; if any row cannot be read exactly, nothing is written and the rows are listed.
- Download the .xlsx file.
What is kept when you convert QIF to Excel
- A real .xlsx with a frozen header row; amounts are numeric cells, identifiers stay text.
- Dates are read in the order you choose and written as YYYY-MM-DD; the original QIF date text is kept in its own column for checking.
- Categories, splits, memos and cleared flags are all kept.
About QIF and Excel files
QIF (Quicken Interchange Format) is an older plain-text format: one field per line, a letter code at the start (D date, T amount, P payee, L category), and ^ to end each transaction. Its dates have no fixed order. It opens in older Quicken versions, GnuCash, Moneydance, Microsoft Money.
An .xlsx is an Excel workbook. Numbers written here are real numeric cells; identifiers with leading zeros or more than 15 digits stay text so Excel cannot round them. It opens in Excel, Google Sheets, LibreOffice Calc, Numbers.
Good to know
- Before converting, find one transaction whose date you know (a salary day, say) and check which date order reads it correctly.
- Excel shows at most 1,048,576 rows and 32,767 characters per cell; larger data still opens, but is cut off on screen.
Privacy and limits
The file is read and converted by this page in your browser; there is no upload and no account. Amounts are handled as exact decimal text, never as rounded numbers. Files up to 25 MB are accepted; a file of the wrong type or a damaged file is rejected with the reason.