Xl2qif Excel 2010

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.

Click Excel Options. Click Add-Ins. Note the Add-in Type in the list displayed. Select the Add-in Type in the manage box and click Go. Select [clear] the check box for the Add-in that you want enable [disable] and then click OK.

It is “Bank” by default, but options like “Credit Card” and “Liabilities” exist. Windows system drivers download. 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.”.