Does anyone know how to import a QIF file into Excel?

[marrayp]

Hey there,


First time poster long time reader of the blog.


Just found out a real niggle with my bank and wondered if you Excel geniuses could help?


The bank download to Excel now does not include a transaction description. Im getting nowhere fast with the Bank. They also offer a QIF download which does work.


Any tricks to import QIF into Excel?


Many thanks in advance,


Cheers,


PM.

 

[imgonna]

QIF - as in Quicken?


Never used it, but: http://lcbell4.tripod.com/softwareman4life/qif_to_csv_converter/qif_to_csv_converter.html


Seems easy enough.


Glen

 

[bobhc]

marrayp


After reading Glens post I realised I cannot tell my Gs from my Qs (I blame the fonts ).


This link may help you in your conversion.


http://www.propersoft.net/blog/how-to-open-a-qif-in-excel/


Glen you have better sight than this old man

 

[Hui]

Why not just Google "Convert QIF to Excel"

https://www.google.com/search?source=ig&rlz=&q=convert+qif+to+excel

 

[Hui]

Bobhc


I think Glen may also have better Pasting Skills...

 

[bobhc]

Hui dont know what you mean

 

[Hui]

Damn,


I forgot we gave you an Edit Button