EXCEL For Mac needs a XML import data
There is not way to import and map XML data to excel for mac,
LUIS
shared this idea
Good news. In the next monthly update of Excel for Mac, when you open an XML file, it will be imported as a table. In addition to that, if you have more complex needs and you have access to Excel on Windows, you can set up a query using Power Query, and you can refresh the query in Excel for Mac. You can find more about Power Query in Excel for Mac here – https://techcommunity.microsoft.com/t5/Excel-Blog/Get-amp-Transform-Power-Query-in-Excel-for-Mac-Phase-1/ba-p/876840
The XML import capability is included in Excel for Mac version 16.31 (191022) or greater. If you want to get version 16.31 sooner than waiting for the next monthly release, you can opt into the Insiders Program by going to Help > Check for Updates. Choose the Fast updates to get the update faster. You can opt out of the Insiders Program if you want to go back to the next regular monthly update cycle.
37 comments
-
George Stafford
commented
Thank you. Just updated and bingo it works!!!!
-
Andy
commented
Just tried it on 16.31 and....
Is no option to import XML in the ribbon, or under get external data in the menu. Yet.
I can use open-with on an XML file and select Excel, but it doesn't handle variation as well as the Windows version - e.g. if you throw federation metadata at it. Seems to work for the simple things though, but it is not like-for-like. -
sergio
commented
i need to fix my laptop
-
Anonymous
commented
I agree. You used to be able to import XML files into Excel for Mac, and after paying for an "upgrade", you cannot. Please restore this functionality.
-
Anonymous
commented
While I agree it's possible to script a solution (and a hat-tip to you for taking the time to do that) - however - since I'm paying for Office365, I expect feature parity regardless of the OS I'm using locally.
-
Andy
commented
On the plus side, I've learnt the basics of xpath and shell scripts to do what I needed. I'm not going to say it was trivial, but hobby-level coding will get you there.
-
GeorgeS
commented
Since the Anonymous Poster thinks Begging for it will get this feature added let me try....
"Someone, please anyone, I beg you, please add the XML import into your Mac Version of Excel"
We will see if that helps....
-
Anonymous
commented
Ridiculous that this is not part of Excel without our begging for it.
-
Anonymous
commented
"It would be great if you can provide more detail about the scenarios that you’re trying to solve with XML in Excel, so that we have a better understanding of this suggestion."
The exact same ones that Excel for Windows users try to solve. I expect that even members of the Excel Team have imported XML data into a spreadsheet from time to time. Unless they use Macs, of course.
I pay the same for my Office 365 subscription that a Windows user does. I expect feature parity.
-
Anonymous
commented
How is this not already part of Excel? We need this!
-
Anonymous
commented
EXCEL For Mac needs a XML import data
-
Văn Dũng Nguyễn
commented
EXCEL For Mac needs a XML import data
-
Anonymous
commented
I was amazed this is not available in Excel for Mac..
-
Anonymous
commented
Urgent! I need import gmaps information!
-
GeorgeS
commented
Dilly Dilly!!!!!
-
Cristina Torres
commented
Agreed on the previous comment there are so many features missing. Including Macro runs needed.
Please at least this one -
Michal
commented
Joining Jim's suggestion here. This is definitely a required fix. Currently using 16.21
-
Jim Millet
commented
Up until Dec 2018 I was able to open an XML file directly in Mac Excel. Last week in Dec and still now I get this message: The file you are trying to open is not a valid Excel XML Spreadsheet.
I am currently at Mac Excel version 16.20 (181208) -
Scott Bowman
commented
One of so many features in Excel that is not available to Mac users. Please finish the Mac version of Excel.
-
Anonymous
commented
Fatturazione elettronica. Il foglio di calcolo più recente di Excel di Office 365 è 2004?