Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a QIF to CSV/XLS converter! Is there any??
On Saturday, February 14, 2004 6:12:17 PM UTC-5, John Hallgren wrote:
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/ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a QIF to CSV/XLS converter! Is there any??
On Saturday, February 14, 2004 6:12:17 PM UTC-5, John Hallgren wrote:
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/ 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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a QIF to CSV/XLS converter! Is there any??
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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Converter ADD in | Excel Discussion (Misc queries) | |||
VBA Converter | Excel Programming | |||
converter | New Users to Excel | |||
PDF Converter | Excel Discussion (Misc queries) | |||
PDF converter to xls | Excel Programming |