We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Convert Xls to Qif

Updated March 23, 2017

A "QIF" (Quicken Interchange Format) file is used by Quicken financial programs that transfer data between different files or between a bank and Quicken. This file type, which has also been used by programs such as Microsoft Money, can be converted to a more universally accessible "XLS" (Excel Spreadsheet) file using several conversion programs. Since the conversion is a bit obscure, two of the conversions require an additional step or two to complete the process.

Loading ...
  1. Visit the XL2QIF website (see Resources) and download the XL2QIF Excel Add-In Version 1.1. Unzip the files using an unzipping program and install the program. The program acts as an add-in to Microsoft Excel and it will create a new menu item labelled "XL2QIF." Open Microsoft Excel and click on the menu. Scroll down to "Save to QIF" to save your current file as a QIF file. Select an output folder and an output file name and click "Convert."

  2. Open Microsoft Excel. Click "File" and "Save As." Choose CSV (Comma-Separated Values) as the file type and click "Save."

  3. Visit the CSV to QIF Free Online Converter page (see Reources). Click on the "Choose..." button under CSV Import to choose your recently converted CSV file. Click on the button marked "Save as QIF." Choose a name for your QIF file and click "Ok." A download box will open up and you can click "Save" to download the QIF file.

  4. Repeat step 2 to change your XLS document into a CSV file. Visit the LC Bell site (see Resources) and download the QIF to CSV converter. Use the unzipping program to unzip the file and double-click on "QIF-CSV Converter" to install the program. Once installed open the CSV file by clicking "File" and then "Open." Click "File" and then "Save As." Click on the drop-down menu and change the file type to "QIF" and click "Save." Your file will then be converted to a QIF document.

Loading ...

Things You'll Need

  • XL2QIF converter
  • Unzip program
  • Microsoft Excel
  • CSF to QIF converter
  • QIF to CSV converter

About the Author

Bryan Cohen

Bryan Cohen has been a writer since 2001 and is a graduate of the University of North Carolina at Chapel Hill with a double degree in English and dramatic art. His writing has appeared on various online publications including his personal website Build Creative Writing Ideas.

Loading ...
Loading ...