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

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

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

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

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

"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