Quicken
From wiki.vincentkong.com
Convert a CSV File to QIF
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."
Reference: http://www.ehow.com/how_5767870_convert-csv-file-qif.html
