Convert a QIF file to CSV/Excel format

Modified on Mon, Jul 5, 2021 at 2:33 PM

This tutorial shows how to convert QIF files to CSV/Excel format. We will use the QIF2CSV utility. IMPORTANT: QIF2CSV is now replaced with the Transactions app, which converts from more formats and converts to more formats.

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

You can review a QIF file before converting.

If your QIF file has dates in different formats, then your system from or your expected format will try to figure out for you. If there is no way to figure 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.

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

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.

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

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

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

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.