QIF to Excel Converter
Turn a Quicken QIF export into an Excel workbook with real dates, summable amounts, categories and split lines. Free, no sign-in, and read entirely in your browser - nothing is uploaded.
Drop your files here or choose filesTap to choose files
Opened on your device - never uploaded · up to 50MB
Supports .qif · or paste a file from your clipboard
No file handy? · download it
How to Convert QIF to Excel
- Export the register as QIF - In Quicken for Windows, use File > File Export > QIF File and choose the account and date range. Other finance programs have a similar QIF export.
- Add the file - Drop the .qif file onto the page. It is read locally in your browser.
- Transactions become rows - Date, check number, payee, memo, amount, category, class and cleared status each get a column; split lines and investment transactions get their own sheets.
- Download the XLSX workbook - Total, filter or pivot the transactions in Excel or Google Sheets.
What Ends Up in the Workbook
A Transactions sheet with one row per transaction: date, check number, payee, memo, amount, category, cleared status and address. A category written as Category/Class is split into Category and Class columns, and a transfer keeps its account name in brackets, such as [Savings]. If any transaction is split, a Splits sheet lists every line; if the file has investment accounts, an Investments sheet lists action, security, price, quantity, amount and commission.
Why Excel Cannot Open a QIF File Directly
QIF is not a table. Each field is its own line, starting with a one-letter code - D for the date, T for the amount, P for the payee, L for the category - and a caret ends each transaction. A split adds S, E and $ lines inside the transaction. Excel shows those lines as they are, one per row; turning them back into transactions means reading every record the way Quicken wrote it.
Have an OFX, QFX or QBO File Instead?
Most banks offer one of those for download rather than QIF. Use OFX to Excel for any of the three. For a PDF statement, use Bank Statement to Excel.
Frequently Asked Questions
Bank, cash, credit card, other asset and other liability registers (!Type:Bank, Cash, CCard, Oth A, Oth L) and investment registers (!Type:Invst), from Quicken or any program that exports QIF. A file with several accounts gets Account and Account type columns. Category, class and memorised-transaction lists in the same file are skipped.
QIF dates have no marker for their order. Quicken in the US writes month first, with an apostrophe for years from 2000 (1/15'26); software from the UK, India and Europe often writes the day first. The whole file is read one way: day first if any date can only be day first, otherwise month first. When every date in the file could be read either way, the result says so, so you can check one you know.
The transaction keeps its total and shows --Split-- as its category, as Quicken does. Each split line goes onto a Splits sheet with its category, memo and amount, and the row number of its transaction, so the lines still add up to the total and can be pivoted by category.
Yes. Amounts are numbers, negative for money out, and dates are real Excel dates shown as yyyy-mm-dd, so you can SUM a column, filter by month or build a pivot table straight away.
No. The QIF file is read in your browser and never sent to a server.