As far as I'm led to believe Excel2011 for Mac is pretty much the same as Excel 2007 for Windoze. That being the case look in Data>>Get External Data>>From Other Sources>>From XML Data Import.
Did you ever find an answer for this? I'm looking for a way to import XML files into Excel 2011 for the Mac and can't find anything.
That is about opening the new OpenXML formats, not importing XML data into an Excel workbook. The two are quite different.
AFAIK, there is no support for importing XML in any version of Mac XL as there hasn't been the call for it.
The vast majority of Excel users don't use 80% of the program's functionality, yet it's all in there. Microsoft obviously thought XML import was of general enough interest that they included it in the Windows version of Excel, so they don't really agree with you. I don't agree with digitalformula that Excel for Mac is "almost useless" without XML import capabilities, but it's a big oversight on Microsoft's part, particularly because most of their enterprise applications speak XML. Also, Mac users tend to be more on the technical side (anecdotally; most of the people I know use Windows, but most of the developers I know use Macs), so you'd think the Mac version would be the one to have XML import.To you, yes. To the vast majority of people that use Excel, it is completely irrelevant.