Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Importing Quicken QFX files into Excel
Is there a way to import a Quicken QFX file into Excel? An add-in perhaps?
Or maybe someone has already written a macro? - David |
#2
|
|||
|
|||
Export the data from quicken as a csv file which you can then import
directly into excel. I don't have quicken on this machine but If I remember correctly the csv format is under the print report options. Hope this helps Rowan David D. wrote: Is there a way to import a Quicken QFX file into Excel? An add-in perhaps? Or maybe someone has already written a macro? - David |
#3
|
|||
|
|||
Rowan,
Thanks for the reply. Unfortunately I do not have Quicken. Some financial institutions give you the option to download account data as either "Quicken" or "Money", but not as .CSV. That is why I wanted to be able to import .QFX directly into Excel. - David "Rowan Drummond" wrote in message ... Export the data from quicken as a csv file which you can then import directly into excel. I don't have quicken on this machine but If I remember correctly the csv format is under the print report options. Hope this helps Rowan David D. wrote: Is there a way to import a Quicken QFX file into Excel? An add-in perhaps? Or maybe someone has already written a macro? - David |
#4
|
|||
|
|||
Rowan,
Thanks for the reply. Unfortunately I do not have Quicken. Some financial institutions give you the option to download account data as either "Quicken" or "Money", but not as .CSV. That is why I wanted to be able to import .QFX directly into Excel. - David "Rowan Drummond" wrote in message ... Export the data from quicken as a csv file which you can then import directly into excel. I don't have quicken on this machine but If I remember correctly the csv format is under the print report options. Hope this helps Rowan David D. wrote: Is there a way to import a Quicken QFX file into Excel? An add-in perhaps? Or maybe someone has already written a macro? - David |
#5
|
|||
|
|||
If you see that data you want on the screen, you can always (from your browser
window) copy it an paste into an Excel sheet. It may need some "cleaning up", however. On Fri, 30 Sep 2005 11:05:10 -0400, "David D." wrote: Rowan, Thanks for the reply. Unfortunately I do not have Quicken. Some financial institutions give you the option to download account data as either "Quicken" or "Money", but not as .CSV. That is why I wanted to be able to import .QFX directly into Excel. - David "Rowan Drummond" wrote in message ... Export the data from quicken as a csv file which you can then import directly into excel. I don't have quicken on this machine but If I remember correctly the csv format is under the print report options. Hope this helps Rowan David D. wrote: Is there a way to import a Quicken QFX file into Excel? An add-in perhaps? Or maybe someone has already written a macro? - David |
#6
|
|||
|
|||
"Myrna Larson" wrote in message
... If you see that data you want on the screen, you can always (from your browser window) copy it an paste into an Excel sheet. It may need some "cleaning up", however. Thanks for the suggestion. That is what I usually do. Unfortunately, I need to page through a half dozen separate pages to get all of the account data, a little from each page. That is why I wanted to use the download facility instead. But copying the data one page at a time will be quicker than my writing and debugging a macro to do it for me. I wonder why a financial institution would go to the trouble to provide complex Quicken and Money data files, but not a simple .CSV file for a spreadsheet. - David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) | |||
Open excel files | Excel Discussion (Misc queries) | |||
Importing txt csv files into Excel greater than 65k lines | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |