Importing Quicken QFX files into Excel

D

David D.

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
 
R

Rowan Drummond

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
 
D

David D.

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
 
D

David D.

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
 
M

Myrna Larson

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.
 
D

David D.

Myrna Larson said:
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.
Click to expand...

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
 
Top