Quicken: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
Line 2: | Line 2: | ||
== data file extensions == | == data file extensions == | ||
* .qdf - | |||
* .qdt - Intuit Quicken v4 Data File | |||
* .qel - Quicken Electronic Library | |||
* .qsd - Intuit Quicken Data file | |||
* .qph - Quicken Price History | * .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 12: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