Difference between revisions of "Quicken"

Revision as of 11:39, 1 April 2016

Quicken is a personal finance management tool by the company Intuit.

data file extensions

• .qdf -
• .qdt - Intuit Quicken v4 Data File
• .qel - Quicken Electronic Library
• .qsd - Intuit Quicken Data file

• .qph - Quicken Price History
• .cat - Quicken IntelliCharge Categorization
• .zix - Quicken Data
• .hif - Quicken Online Data
• .kmy - Money Data
• .ofx - Open Financial Exchange Document
• .ofc - Open Financial Connectivity Document
• .qfx - Quicken Financial Exchange Data
• .qif - Quicken Interchange Format Data

legacy version support

New versions of Quicken will not directly open data from older Quicken versions.

convert Quicken data to Excel format

1. Go to the "Reports" menu in Quicken and run the report you wish to export to Excel. If needed, change the date range of the displayed data using the drop-down menu to access the information you need.
2. Copy the data using the "Copy" button at the top of the report.
3. Open MS Excel. Create a new spreadsheet by choosing "New" under the "File" menu.
4. Go to the "Edit" menu and choose "Paste." The data you copied from your Quicken report should appear on the spreadsheet.
5. Save the spreadsheet using the file name of your choice by clicking "Save" under the "File" menu.

Another Method:

1. In Quicken, display the report you want to export.
2. On the toolbar, click Export Data.
3. Choose To Excel Compatible Format.
4. In the File name field, enter a name for the file.
5. Switch to Excel.
6. Use Excel's Open command, and navigate to the file containing your report data