QIF to CSV and Excel converter

Turn a QIF export from Quicken, Microsoft Money, GnuCash or an older bank download into a spreadsheet, with every account, category and split.

Choose your files

or drop one or more .qif files here

Up to 20 files at a time. Your files stay on this device.

View history

Your files stay on this device: the conversion runs in your browser and nothing is uploaded. Learn how your files are handled

How to convert QIF to CSV or Excel

  1. Choose one or more .qif files.
  2. Check the dates in the preview. The converter works out whether the day or the month comes first. If the file doesn’t make it clear, you’ll see a note, and you can set it yourself.
  3. Choose how to show split transactions, then download a CSV or Excel file.

What the converter reads

  • Bank, credit card, cash, other-asset and other-liability sections, with date, amount, payee, memo, category, check number and cleared status.
  • Several accounts in one export. Quicken’s full-file QIF export lists each account under an !Account heading, and the account name goes into its own column.
  • Split transactions, where one payment covers several categories. By default, the split is summed up in the Category column (“Split: Food -60.00; Household -40.00”). Tick “One row per split line” to get a row for each part.
  • Investment transactions: the action (such as buy or sell), the investment’s name, the quantity and the price go into the memo, and the cash amount goes into Amount.
  • Quicken’s short dates with an apostrophe (1/ 5'26 means 5 January 2026), amounts with thousands separators, and text saved by older programs in the Windows-1252 format.
  • Lists of categories, classes and memorised payees in the file are skipped. Only transactions are converted.

Moving away from Quicken or Microsoft Money

QIF is often the only way to get data out of an old copy of Quicken or Microsoft Money. Microsoft Money, including the free Money Plus Sunset edition, exports each account as a QIF file with File → Export. Convert it to a spreadsheet to keep a readable archive, or to tidy it up before importing it into a new app. Many apps that don’t read QIF accept CSV, and the CSV to OFX converter can make an OFX file from the tidied sheet.

Frequently asked questions

The dates look wrong. What should I do?

QIF files don’t say whether the day or the month comes first. If every date could be read either way, month first is assumed. Set “Dates in the file” to Day first and check the preview again.

How are split transactions shown?

Either as one row with all categories listed in the Category column, or, with “One row per split line” ticked, as one row per part, with that part’s category, memo and amount.

Can I open a QIF file in Excel directly?

Excel opens it as one column of coded lines (D, T, P, ^…), not as a table. Convert it here to get proper columns.

Accented letters come out wrong. Can that be fixed?

Older QIF files use an older text format called Windows-1252. The converter detects this and reads it correctly. The CSV it saves uses UTF-8, the modern standard, which Excel and other spreadsheets read properly.

What program opens QIF files?

QIF files are made to be imported by finance programs, such as Quicken, Microsoft Money, GnuCash, Moneydance, Banktivity, KMyMoney and HomeBank. Excel and text editors show only the coded lines. To read the transactions as a table, convert the file here and open the CSV or Excel file.

Microsoft Money is no longer sold. How do I move my data?

Microsoft stopped selling Money in 2009 and later released Money Plus Sunset, a free edition that still opens Money files but has no online banking. There is no direct replacement from Microsoft. To move your data, export each account from Money as a QIF file (File → Export). Convert those files here to keep a spreadsheet archive, or import them into another program that reads QIF, such as Moneydance or GnuCash.

How do I convert QIF to QBO?

In two steps. Convert the QIF file to CSV here, then choose that CSV in the CSV to OFX converter and pick QBO as the file type. Each transaction keeps its date, amount, payee and memo. Categories are left out, because QBO files have no field for them, and a split transaction becomes one transaction with its total amount. A QBO file holds one account. If the QIF has several, split the CSV by its Account column with the CSV splitter and convert each part.

Can I convert a QIF file to PDF?

Not directly. Convert it here to an Excel workbook, open that in Excel, Google Sheets or Numbers, and use Print to save it as a PDF.

Is my financial data uploaded?

No. The QIF file is read in your browser, and the spreadsheet is created on your device.