Excel 2011 for Mac - Import XML?

digitalformula

New Member
Joined
Jul 28, 2010
Messages
10
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!
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,035
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
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

New Member
Joined
Jul 28, 2010
Messages
10
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

New Member
Joined
Nov 14, 2011
Messages
1
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

New Member
Joined
Jul 28, 2010
Messages
10

ADVERTISEMENT

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.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,973
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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

New Member
Joined
Jul 28, 2010
Messages
10
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,973
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

Skippyroo

New Member
Joined
Feb 22, 2012
Messages
2
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,195
Messages
5,857,877
Members
431,905
Latest member
RW11700

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top