How to Convert QIF Files to Excel
Quicken allows you to create budgets and track income and expenses using an intuitive user interface and powerful transaction database. In most cases, Quicken offers all the tools and reports you need to monitor your home or small-business finances. However, if you want to export your Quicken entries and transactions so that you can integrate them into another application or share them with an accountant or bookkeeper, convert the Quicken QIF file to Excel format to make using the data in other programs easier. Quicken allows you to convert either your entire QIF database file to Excel, or only certain parts.
Things You'll Need
- USB flash drive or external hard drive (optional)
Launch Quicken, click "File," then "Open." Browse to the Quicken QIF file that contains the financial data you want to export to an Excel file. Note that some versions of Quicken automatically open the last file you used, so if you use only one database file in Quicken, the file should open as soon as you launch the program.
Click the "File" menu, then "Export" and "QIF file."
Enter a name for the export file in the "Save As" field. Navigate to the folder in which you want to save the converted QIF file. Alternatively, connect a USB hard drive or flash drive to the computer, then select the device in the browser window as the save location. Click the "OK" button after you enter a name for the new file and select a folder in which to save it.
Select the QIF file you want to convert and export to Excel. The backup utility should highlight the open database file by default. Change the selection only if you want to export a different database file than the one currently open. Click the "Next" button.
Use the calendar controls to select the beginning and ending dates for which you want to export transactions to Excel, then click "Next."
Click and select the types of information you want to export. Options for data you can export in the QIF file are as follows:Account List -- a list of all income and payment accounts set up in Quicken.Category List -- a list of the income and expense categories.Memorized Payees -- a listing of companies or vendors you often pay.Security Lists -- details about investment and stock accounts you track in Quicken.Business Lists -- invoice items and templates (for Quicken Home & Business version only).
Click "Next" after you select the data types to convert to Excel format.
Click "Export Data" on the toolbar and select "To Excel Compatible Format." Click "Export." Quicken saves the file in a ".CSV" or ".XLS" format in the folder you selected. The format for the conversions depends on which version of Quicken you are using. Nevertheless, Excel can open files in both formats without additional conversion filters.
Open Excel and click "File" on the menu bar. Click "Open" and browse to the folder where you saved the exported QIF file. Highlight the file and click "Open." Excel opens and displays the contents of the converted QIF file.