Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

EXCEL For Mac needs a XML import data

There is not way to import and map XML data to excel for mac,

209 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

LUIS shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

Good news. In the November 2019 monthly update of Excel for Mac, when you open an XML file, it will be opened as a table. If you try to use the Data menu > Get External Data > Import from Text file, it will not treat it as structured XML.

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 ability to open XML files as a table is included in Excel for Mac version 16.31 (191022) or greater. To update the latest version, go to Help > Check for Updates.

42 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Trond commented  ·   ·  Flag as inappropriate

    I have 16.43 and well... it sort of work if you choose HTML as data source, but it does not render it correctly.

    I'd like to see XML support in Excel at a much higher level than it is at the moment on mac.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Nope. Not completed. I have Excel for Mac v.16.31. When I open an XML file all I get is a row of nonsense column headers and no data. I'm paying the same subscription fee as an Excel for Windows user; I should get the same functionality.

    I don't have access to a PC, so don't tell me to create a Power Query in Excel for Windows and then open it on my Mac.

  • Anonymous commented  ·   ·  Flag as inappropriate

    after much googling and effort i find this page telling me i cannot import XML into excel for mac?! WTF!! Fix it!!

  • Andy commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    "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.

← Previous 1 3

Excel for Mac: Data Import

Categories

Feedback and Knowledge Base

(thinking…)