Difference between revisions of "Quicken"
From Free Knowledge Base- The DUCK Project: information for everyone
(→data file extensions) |
|||
| Line 3: | Line 3: | ||
== data file extensions == | == data file extensions == | ||
| − | * . | + | * .qdf - |
| + | * .qdt - Intuit Quicken v4 Data File | ||
* .qel - Quicken Electronic Library | * .qel - Quicken Electronic Library | ||
| + | * .qsd - Intuit Quicken Data file | ||
| + | |||
| + | * .qph - Quicken Price History | ||
* .cat - Quicken IntelliCharge Categorization | * .cat - Quicken IntelliCharge Categorization | ||
* .zix - Quicken Data | * .zix - Quicken Data | ||
| Line 13: | Line 17: | ||
* .qfx - Quicken Financial Exchange Data | * .qfx - Quicken Financial Exchange Data | ||
* .qif - Quicken Interchange Format Data | * .qif - Quicken Interchange Format Data | ||
| + | |||
| + | == convert Quicken data to Excel format == | ||
| + | #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. | ||
| + | #Copy the data using the "Copy" button at the top of the report. | ||
| + | #Open MS Excel. Create a new spreadsheet by choosing "New" under the "File" menu. | ||
| + | #Go to the "Edit" menu and choose "Paste." The data you copied from your Quicken report should appear on the spreadsheet. | ||
| + | #Save the spreadsheet using the file name of your choice by clicking "Save" under the "File" menu. | ||
| + | |||
| + | Another Method: | ||
| + | #In Quicken, display the report you want to export. | ||
| + | #On the toolbar, click Export Data. | ||
| + | #Choose To Excel Compatible Format. | ||
| + | #In the File name field, enter a name for the file. | ||
| + | #Switch to Excel. | ||
| + | #Use Excel's Open command, and navigate to the file containing your report data | ||
Revision as of 13:12, 31 March 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
convert Quicken data to Excel format
- 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.
- Copy the data using the "Copy" button at the top of the report.
- Open MS Excel. Create a new spreadsheet by choosing "New" under the "File" menu.
- Go to the "Edit" menu and choose "Paste." The data you copied from your Quicken report should appear on the spreadsheet.
- Save the spreadsheet using the file name of your choice by clicking "Save" under the "File" menu.
Another Method:
- In Quicken, display the report you want to export.
- On the toolbar, click Export Data.
- Choose To Excel Compatible Format.
- In the File name field, enter a name for the file.
- Switch to Excel.
- Use Excel's Open command, and navigate to the file containing your report data
