Feedback by UserVoice

Excel for Mac

Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 209 votes
    Sign in
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    40 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    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 –

    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.

  • Don't see your idea?

Feedback and Knowledge Base