How to Convert a CSV File to QIF

by Ray Padgett ; Updated September 28, 2017

Items you will need

  • Microsoft Excel

  • XL2QIF

Many banks only export account information and history in a comma-separated values (CSV) database format. If you want to manage the data from the popular Quicken financial management software, you’ll need to convert the CSV file to Quicken Interchange Format (QIF). You can do this with a free Microsoft Excel add-in that provides enough customizable options to ensure smooth data transition to Quicken.

Installation

Download and unzip the XL2QIF application from the link in Resources.

Double-click the “Install” icon in the folder that downloads to open the installation window in Microsoft Excel.

Click the “Install” button in Excel. Choose your language (English or French) and restart Excel.

Conversion

Open your CSV data file in Excel and highlight all the data you wish to convert.

Click the “Add-Ins” tab at the top of the Excel window. Click the XL2QIF button and select “Save to QIF.”

Select the appropriate “Account Type” under “Options” in the window that pops up. It is “Bank” by default, but options like “Credit Card” and “Liabilities” exist.

Find the “Standard Field” box and check the fields in your CVS file in the order that they appear. For instance, a bank account might have the date, then the amount, then the category, etc.

Click the “Browse” button and select where you would like to save your QIF file. Click “Save” and then, back in the main window, “Convert.”

Tip

  • XL2QIF 1.1 will work with all the latest versions of Microsoft Excel, but users with Excel '97 will need to download 1.0 instead.

Video of the Day

Brought to you by Techwalla
Brought to you by Techwalla

About the Author

Based in New York City, Ray Padgett has been writing about music and technology since his 2009 graduation from Dartmouth College. He has a degree in religion, with a minor in English. He has been published in SPIN.com and in "The Celebrity Café," "The Noise" and an upcoming Bob Dylan anthology.

More Articles

Photo Credits