xlsRowvert
File converters · QIF → Excel

QIF to Excel converter

Turn a QIF file into an Excel workbook with real dates, numbers, categories and totals — the quickest way to read old Quicken or Microsoft Money data today.

  • ✓ Free, no account, no email
  • ✓ Converted in memory and never stored
  • ✓ Reads files from any bank or finance app
Convert .qif fileFree · no account
Drop your .qif file hereor click to browse · up to 5 MB · processed in memory, never stored
Reads QBO, OFX, QFX, QIF, CSV and IIF files. Writes CSV, Excel, QBO, QFX, OFX, QIF and PDF.

When you need to convert QIF to Excel

  • You're recovering history from old Quicken or Microsoft Money exports.
  • You want to analyse spending by the categories stored in the QIF.
  • Your bank still offers QIF downloads and you work in Excel.

How to convert QIF to Excel

  1. Drop your .qif file on the converter (up to 5 MB).
  2. Check that "Convert to" says Excel, and pick the date order if your dates are ambiguous.
  3. Click Convert: the Excel file downloads straight away. Nothing is stored.
  4. Open or import it: Excel, Google Sheets, Numbers, LibreOffice — Open the .xlsx. The Transactions sheet has a frozen header and filters; the File info sheet lists the account, period, totals and ending balance.

What happens to your data

  • Transactions sheet: Date, Description, Amount, Debit, Credit, Memo, Check number and Category, with totals.
  • Quicken's date styles (1/5'24, 01/05/24, 01/05/2024) are normalised to real Excel dates.
  • A File info sheet with the period, number of transactions, money in and money out.

Importing the Excel file

Excel, Google Sheets, Numbers, LibreOffice
Open the .xlsx. The Transactions sheet has a frozen header and filters; the File info sheet lists the account, period, totals and ending balance.

What is a QIF file?

QIF is a plain-text format from the early days of Quicken. Each transaction is a short block of lines: D for the date, T for the amount, P for the payee, M for the memo, L for the category and N for the check number, ending with a ^. It has no transaction IDs, so importing the same file twice creates duplicates.

What is an Excel export?

An Excel workbook with typed columns: real date cells, numbers with two decimals, separate Debit and Credit columns and a totals row, so SUM, filters and pivot tables work straight away.

QIF to Excel: questions

Can I pivot by category?

Yes. The QIF category (L field) becomes a Category column you can use in a pivot table.

Does it support Microsoft Money QIF exports?

Yes. Money writes standard !Type:Bank and !Type:CCard sections.

Is the QIF to Excel converter free?

Yes. Format-to-format conversions are free and need no account. Files are converted in memory and never stored. Converting PDF bank statements is a separate tool with a free daily allowance.

Only have a PDF statement? Convert a PDF bank statement to Excel — digital or scanned, any bank.

Other converters: QBO to Excel · OFX to Excel · QFX to Excel · QIF to CSV · QIF to QBO · IIF to Excel · All file converters