Xl2qif Excel 2010

AceMoney can import transaction from.CSV files that can be produced by all modern spreadsheet applications like Microsoft Excel or OpenOffice Calc. However the order of fields in the file should match AceMoney expectations. AceMoney expects the following columns in the CSV file: • A (1) - Transaction/check number • B (2) - Date • C (3) - Payee • D (4) - Category • E (5) - Status • F (6) - Withdrawal • G (7) - Deposit • H (8) - Total • I (9) - Comment There is another option.

There is a freeware utility to convert data from spreadsheet to QIF format. You can download it free of charge at this address:. Then create the same accounts in AceMoney and import QIF files.

Convert Excel spreadsheets into QIF files for import into Quicken and other applications that support QIF. Create QIF files for import into almost any Quicken account type including checking, credit card and investment accounts. Also, convert QuickBooks Accounts & Transactions to QIF files for import into Quicken. XL2QIF 1.1 will work with all the latest versions of Microsoft Excel, but users with Excel '97 will need to download 1.0 instead. Video of the Day Brought to you by Techwalla.

I found a useful Excel-to-qif converter (freeware) here: 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. Hi, See if this will help: How to export and import account information in Microsoft Money 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. 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. Will you try this tool instead?