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. Stock Data for new stocks not working since nov 2020

    Need a fix for new stocks not showing as a valid company under stock data. Looks like issue started in November.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    We’ve updated our Stocks data to include the latest IPOs as of Dec 17th 2020. We apologize for the inconvenience of not having these available sooner. We are working on a process to provide access in a more timely manner. Thanks for your patience.

  2. 209 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    42 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 – 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.

  • Don't see your idea?

Feedback and Knowledge Base