Feedback by UserVoice

 

Excel for Mac

← Welcome to Excel’s Suggestion Box!

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.

How can we improve Excel for Mac?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

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

    39 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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?

Excel for Mac

Categories

Feedback and Knowledge Base

(thinking…)