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 files

Opened on your device - never uploaded · up to 50MB

Choose files

Supports .qif · or paste a file from your clipboard

No file handy? · download it

How to Convert QIF to Excel

  1. 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.
  2. Add the file - Drop the .qif file onto the page. It is read locally in your browser.
  3. 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.
  4. 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

Related Tools