none
Modifying Excel-to-QIF Converter Add-in xl2qif to use all selected columns

    General discussion

  • I found a useful Excel-to-qif converter (freeware) here: http://xl2qif.chez-alice.fr/xl2qif_en.php which takes data from my Excel file and makes it importable into MSMoney. However, it ignores the MS Money 'Category' data, even when I have definitely selected those columns in the Excel file for the Add-in to work with. I don't know how to edit/modify the add-in myself and I can't ask the person who built it, because their contact details are out of date and their email bounces. Is there anyone out there that would be willing to take a look and see if they can suggest a way forward? Thanks in advance.  I'm using Office 2007 and Windows 7 Ultimate.  I have posted this question on the Microsoft Answers pages for Excel and another member has recommended I post here also.
    Wednesday, June 29, 2011 12:14 AM

All replies

  • Hi,

    See if this will help:

    How to export and import account information in Microsoft Money

    http://support.microsoft.com/kb/178830/en-us


    Sincerely,

    Max Meng
    Forum Support


    Come back and mark the replies as answers if they help and unmark them if they provide no help.
    Thursday, June 30, 2011 4:39 PM
  • Hi,

    See if this will help:

    How to export and import account information in Microsoft Money

    http://support.microsoft.com/kb/178830/en-us


    Sincerely,

    Max Meng
    Forum Support


    Come back and mark the replies as answers if they help and unmark them if they provide no help.

    No, unfortunately, it doesn't, Max  I'm trying to import xls data (from EBay invoices) into MSMoney.  If I am correct, there is no way to directly do this; that is why I was attempting to use the clever xl2qif freeware add-in, to go first from xls to QIF, and then import the QIF into Money (I know how to do the latter).  My problem is that the QIF file which results from using the Add-in does not appear to process 'Category' data. I have been unable to contact the developer and without a big learning exercise, for which I don't have time, I don't know how to edit the add-in to make it work.  If you know of another way to import xls data into MSMoney, please say.  The link you've provided does not reference this topic, as far as I can see; it only covers Money data INTO xls format or interchange of Money/QIF files.
    Friday, July 01, 2011 1:42 AM
  • Hi,

    Sorry for that.

    But I couldn't open the link you provide. And I have searched for it, seems it stoped being updated since 06/06/2006.

    Will you try this tool instead?

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

    It is claimed it will work with Excel 97 - 2010. Although you will need to pay for it.

     

    I think you'd better post your question to the forum for MS Money:

    http://social.microsoft.com/Forums/fi-FI/money/threads

    You may get help from these user have similar problem, and you can come back if you hava any question on Excel side.

     

    Links maybe useful:

    Java app(s) to update quotes

    http://microsoftmoneyoffline.wordpress.com/2010/02/12/java-app-to-update-quotes/

    Download Price Quotes to Microsoft Money After Microsoft Pulls the Plug

    http://thefinancebuff.com/security-quote-script-for-microsoft-money.html

    Reconnecting Microsoft Money

    http://sites.google.com/site/pocketsense/home/msmoneyfixp1

     

    Please Note: Since some web sites are not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

    Sincerely,

    Max Meng
    Forum Support


    Come back and mark the replies as answers if they help and unmark them if they provide no help.
    Friday, July 01, 2011 6:05 AM
  • Max - try the link again, it's still working fine for me and the download is still available.  In fact, when I went back to it, I noticed some more links and downloads, including a .txt to .mny converter which I will look at when I get time.

    I can't justify spending any money on a fix just now, so I already rejected purchasing bigred's solution...

    Also, the Sunset editions don't work for me, as I'm a Money UK 2004 user (the last version that was made)  and we were repeatedly warned (when they were cheaper) not to switch to an international/US version because they would be inapproporiate for UK tax reports etc. :-(  But I will post in the Money forum as well, in case there are other dinosaurs like me lurking there.

    Thanks for reading.

     

    Saturday, July 02, 2011 10:56 PM
  • Try Bank2CSV at http://www.propersoft.net/bank2csv no purchase required to open the file and free edition allows to save 50 transactions per file.
    Thursday, May 10, 2012 4:40 PM
  • Looking into this now, thanks for the suggestion.  Will post back here when I've tried it.
    Thursday, May 10, 2012 11:12 PM
  • Have looked into this now, although propersoft does offer a csv and xls-to-qif converter, that one only allows 3 transactions in the trial version, which is not much good. I think I'll have to give up my dinosaur tendencies and start using a financial package that's current, not a long-obsolete version of MS Money ;-)
    Monday, May 14, 2012 2:49 PM
  • iCreateOFX Basic will convert CSV and XLS to QIF or OFX, and will also read QIF and OFX files which you can save to CSV.

    The program is available on a fully functional 30 day trial period with NO limitation(s) to the number of transactions in a file. It supports bank and credit card files.

    Wednesday, January 02, 2013 11:42 AM