Convert Quicken files to Excel

[Patric]

Hello friends:

How would I convert Quicken files to Excel?

My bank provides information in .qfx files. I do not own a Quicken program and I cannot locate a conversion tool.

There must be thousands of people with the same dilemma...can someone please give me some advice and direction?

Thanks in advance.

[BrianExcel]

You can try either of these:

http://shamikshah.com/code/qif2csv/Converter.html
http://www.macgyver.org/software/quickaccess.html

[Patric]

Thanks Brian, for your quick response. Unfortunately, both of those links are dead.

[xenou]

It's seems possibly that qfx is an xml-based format. What does it look like in notepad? I saw one reference that an ofx reader might work - not sure though.

If you post sample data enclose it in noparse tags:
[NOPARSE]your file data without sample data (not actual)[/NOPARSE]

[xenou]

It's seems possibly that qfx is an xml-based format. What does it look like in notepad? I saw one reference that an ofx reader might work - not sure though.

If you post sample data enclose it in noparse tags:
[NOPARSE]your file with sample data[/NOPARSE]

dummy up actual financial figures.

[Patric]

It's seems possibly that qfx is an xml-based format. What does it look like in notepad? I saw one reference that an ofx reader might work - not sure though.

If you post sample data enclose it in noparse tags:
[NOPARSE]your file with sample data[/NOPARSE]

dummy up actual financial figures.

Here is a tad of the stuff from .qfx to Notepad:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE





0
INFO

20111104025820
ENG


[xenou]

That appears to be a header of some kind. This is interesting:

DATA:OFXSGML

Do you see the data? It appears it may be be a form of ofx (ofxsgml) so there still hope an OFX reader would work, or we can parse the sgml markup.

[Patric]

Hi X...and thanks.

I downloaded BRC OFX Reader. The final product looks like the notepad version...here's a sample:

	SRSV1>
0
	INFO
	2.01E+10
	ENG

[xenou]

Afraid you have to use the no parse tags to display the data in html (see my first post), or it comes out as garbage in a browser window.

[Patric]

Well, I do not understand how to use parse tags, so I have a couple of choices...

1) a time-consuming work-around.

or

2) ask for advice and direction on parse tags.

If you have the time and inclination, I would certainly follow up.