There is not way to import and map XML data to excel for mac,209 votes
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.
- Don't see your idea?