Need a QIF to CSV/XLS converter! Is there any??

[John Hallgren]

Have found via this forum the XL2QIF add-in, but that does
not handle investment info fields...I need to do a simple
convert of a QIF file to CSV so I can import it to
Excel...I found some shareware but it's limited to 20 rcds
for trial, it appears, and I have more than that to verify
if it would work properly...anyone know of any thing that
will do what I need? Thanks! PS. I DON'T need to create
a QIF..just READ it!

 

[Ken Wright]

http://www.bigredconsulting.com/AboutQIFConverter.htm

You can try the full product for 30 days.

 

[David McRitchie]

Hi John,
You may have already seen these links but there may well be more than
one XL2QIF addin around. I guess it goes to and from QIF. There
are a couple of other links as well. In any case these are free not shareware.
The XL2QIF that I have the link for indicates
Converts bank statement or credit card statement information.

Quicken Interchange File used by Quicken and MS Money (#QIF)
Stocks, Quotes and keeping track of
http://www.mvps.org/dmcritchie/excel/stocks.htm

Habeeb's (McGyver) does stocks but the link is dead,
I found that his free software
is on a members only payfor free software site -- I expect that
he would not be very happy about someone else making personal gain
on what he provided for free. I would avoid such pay for sites on
general principle, but it probably not updated and it was a bit of a
hassle to have to have Quicken up when the addin was active.

 

[seletit]

Have found via this forum the XL2QIF add-in, but that does
not handle investment info fields...I need to do a simple
convert of a QIF file to CSV so I can import it to
Excel...I found some shareware but it's limited to 20 rcds
for trial, it appears, and I have more than that to verify
if it would work properly...anyone know of any thing that
will do what I need? Thanks! PS. I DON'T need to create
a QIF..just READ it!

Propersoft QIF2CSV at http://www.propersoft.net/qif2csv/

 

[GS]

Propersoft QIF2CSV at http://www.propersoft.net/qif2csv/

I can appreciate the developers getting paid for their efforts, but...

Given that a QIF (or OFX) file is plain text then it can be read (and
parsed) via standard VB[A] I/O methods/functions and so negates any
point in paying for an app to do this, IMO.

Using VB[A] I/O permits reading the QIF/OFX directly into an Excel
worksheet, and allows one to customize the way the data displays in the
process.

If a CSV is required/desired then the Excel file can be saved as such
at any time. It just seems a bit counter-productive (IMO) to buy an
app, convert the QIF/OFX file so you can then import that CSV into
Excel when it can be done in Excel in a single step, thus bypassing all
that other nonsense!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

Here's a free addin that goes both ways...

http://xl2qif.chez-alice.fr/xl2qif_en.php

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion