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!

 

[dave3009]

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.

 

[digitalformula]

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.

Hi Dave,

Thanks for the quick response. I wish that were the case, though. Excel for Mac 2011 doesn't have that option (although it does have the Data menu containing Get External Data).

Nothing under there mentions XML ...

 

[JTexcel]

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.

 

[digitalformula]

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.

No, I didn't find an answer, unfortunately. I asked Microsoft through their twitter feed (they have responded to other questions in the past) but received nothing about this.

I'm assuming at this point that it can't be done - to me that makes Excel for Mac pretty much useless.

 

[Scott33]

I know this is an old post, but I didn't see any responses to indicate a solution. This is what I found from Microsoft on this issue.

http://www.microsoft.com/mac/downloads?pid=&fid=6B9238E1-CF69-48C4-BF2D-C4A8ACEEE520

 

[RoryA]

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.

 

[digitalformula]

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.

Which, to me, is the stupidest reason ever to leave out a function that pretty much forms the whole basis of an application designed for data analysis and manipulation.

Excel has tools like 'Solver' etc and yet we can't import data from what is probably the most commonly used export format? Microsoft majorly missed the mark on that one. In my opinion it makes Excel for Mac almost useless.

 

[RoryA]

In my opinion it makes Excel for Mac almost
useless.

To you, yes. To the vast majority of people that use Excel, it is completely irrelevant.

 

[Skippyroo]

To you, yes. To the vast majority of people that use Excel, it is completely irrelevant.

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.