Open/Convert a QIF file in Excel

Quicken is a personal finance management tool that offers an easy-to-use interface and powerful transaction database for creating budgets, tracking income and expenses, and monitoring your home or small business finances. It also allows you to export your data in the form of a QIF file, which can then be converted to Excel format for use in other applications or shared with an accountant or bookkeeper. You have the option to convert the entire QIF database file or just select parts of it to Excel.

When you need to export transactions from Quicken, you would have file in QIF or QMTF formats. These files can be opened in a text editor or even in Excel as a text file, but are not easy to work with. It would be better to convert such files to CSV or Excel format first.

Use the ProperConvert app to convert your transaction files to CSV/Excel formats.

Quicken Interchange Format (QIF)

QIF files are Quicken Interchange Format files containing details about transactions:

How to view or open a QIF file

Supported Account types

Convert a QIF file to CSV/Excel format

In this example, we will use a sample QIF file.

Convert a QIF file to CSV/Excel format Step 1: sample qif file

You can review a QIF file before converting.

Convert a QIF file to CSV/Excel format Step 2: review a QIF file before converting

If your QIF file has dates in different formats, then your system will try to figure out for you from or your expected format. If there is no way to figure it out, you can tell it by specifying how Input dates are coming on your QIF file. For example, if dates are coming as month/day/year, then you would specify. If it is slash or dash, or dot, or apostrophe, it doesn't matter ' this is just order specified, how Dates are coming. In some QIF files, they are coming without year. And if you need to specify the year, you can start that which year those transactions belong to.

Convert a QIF file to CSV/Excel format Step 3: source

You can review all those QIF details, all those transactions details. Each transaction takes one line.

Convert a QIF file to CSV/Excel format Step 4: review transactions details

Then, on the right side, you can specify how you would like your CSV file to be created. It may be a CSV file, it may be an Excel file, it may be limited fields - Quickbooks Online file or Xero file, or CSV Mint file. Choose a Target.

Convert a QIF file to CSV/Excel format Step 5: target

Then you would specify which Date format you would like to be, depending on how you need it to be on the CSV file.

Convert a QIF file to CSV/Excel format Step 6: date format

Then click the 'Convert' button to create a file.

Convert a QIF file to CSV/Excel format Step 7: convert

Confirm output CSV file name or change it. Then click 'Save'.

Convert a QIF file to CSV/Excel format Step 8: confirm name

If you specify to open a file after a conversion, you can use the software associated with the CSV file. It could be Excel or Notepad for you to review created CSV file.

Convert a QIF file to CSV/Excel format Step 9: open after conversion

Related articles