Excel 2011 for Mac - Import XML?

[digitalformula]

Hi all,

Can Excel 2011 for *Mac* import an XML file? I know the Windows versions have been able to do it since Excel 2000 and earlier but the Mac versions seem to have this functionality removed.

Can it be done? If so, how?

Thanks!

 

[calhobbes]

It works for me in 2008 mac excel, but my buddy on 2011 mac excel says he cant get it to work.

For me, I did the following and it works as expected:
File>>Import>> (pop-up window with four options csv,fmp,html,txt) choose HTML File>enable all office documents>choose your xml file.

This worked for me on 2011 Mac Excel. Thanks so much!

 

[LeonFish]

If you can post an example XML file on DropBox or other shared service I can try some experiments on it.

Thanks for offering to help, Jim. As luck would have it the cms system we're using released an update and it now generates xls files. problem solved.

 

[macuser99]

Any update to this question.
I have Excel 2011 version 14.6.5.
I am trying to read an xml file generated by someone else.
I can read the xml file on a pc by opening it and xlm file generates a excel spreadsheet.
When I use the procedure above on a mac, excel opens the xml file as text.
I need to open the xml file in a spreadsheet.
Is there anyway to do this?