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.

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,

    77 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    • Provide data get and tranform including JSON to Excel transformation

      This feature is provided with Windows Excel 2016 but not with Mac. Isn't it time to make the Mac software a first-class citizen with Microsoft. It seems like forever that Microsoft started supporting Mac Office, yet it still does not have all the features. Why not? I am paying you every month. Yet you still don't provide many advanced features. I will consider Pages then.

      12 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
      • Support Internet Query Connection (.iqy files)

        It would be helpful for Excel to Mac to support internet query connections.

        When exporting a list from Sharepoint, the .iqy file is downloaded, which I subsequently can't open in Excel for Mac.

        13 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
        • it will be more convenient if Excel for Mac has the same import xml function as Windows version.

          it will be more convenient if Excel for Mac has the same import xml function as Windows version.

          6 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
          • Import XML into excel

            I need to import a structured xml file into excel. The xml file contains elements which contain other elements. I'd be happy to define a mapping which would excel allow to know, which elements/attributes to put into which column. The File I'd like to import is attached. However, this is jus one example.

            8 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
            • I would like a stable service - not to be treated as a paying guide pig for Microsoft to try out new ideas, like deleting Forms.

              I would like a stable service - not to be treated as a paying guide pig for Microsoft to try out new ideas, like deleting Forms. If Microsoft want to trail stuff and take away functionality they shouldn't be doing it to the people who pay them each year via 365

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
              • Create a button to import data from WEB just like in the Windows version

                Just insert the button "From Web" as the same way in Excel for Windows

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                • ssas

                  Allow Excel for Mac to connect to MS SSAS cubes.

                  3 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                  • When opening a CSV file, make Excel recognise it as a CSV file!

                    Currently when I import data from a CSV file, Excel doesn't recognise that it is CSV even though the file name ends in ".csv"! I have to tell the program that the data file has delimited fields and define the separator as comma for it to import the data correctly. Surely this is basic stuff for a program like Excel?

                    3 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                    • Copying cells from 1spreadsheet to another

                      On iPad in excel when I copy cells ( some with data, some without ) form one spreadsheet and pasting to another spreadsheet the cells with data are compressed together, without regard to blank cells

                      1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add "query from Web" for Mac version

                        Add "query from Web" for Mac version

                        8 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                        • Stock Quotes

                          Add formula to add stock quotes in realtime, like google sheets has the ability to do. I don't want to run a excel add-on to find these quotes. This would be very helpful.

                          5 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                          • 3 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                            • Excel for Mac 2016 (v16.9) bug importing data into Excel sheet

                              In the most recent update of Excel for Mac 2016 (v16.9), when you import data into Excel you only get to view a small selection of columns in the data preview window (Preview of Selected Data). You cannot scroll the right to view/manipulate the rest of the columns, which is essential during the importing of the data. This behavior is unaffected by the System Preferences>General>Scrolling behavior selections.

                              3 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                              • stock quotes

                                Pull Stock Quotes real time from MS Finance.

                                As Microsoft has data already for MS Finance, a simple formula like =GOOGFINANCE can make Excel amazing. Now I switch between Excel and Google Sheets.

                                6 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                • Import CSV with multi-line text cells

                                  Importing of CSV files which contain multi-line values (line breaks in the text cells) is not possible using the "File" - "Import" wizard. It is however possible if all options (field delimiter and text qualifier) match the system's defaults to import such files by double clicking the CSV. Please fix the Import wizard to allow multi-line text while customising the delimiters.

                                  19 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Allow exporting of Sharepoint lists

                                    It would be great if you could export a Sharepoint list to Excel for Mac. At present you have to use Excel on a PC - as I believe this requires some kind of ActiveX component.

                                    101 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

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

                                      Thanks for the suggestion and the votes. We will continue to monitor the votes to help prioritize this along with other data connection requests. You may want to add a comment about connecting to SharePoint in the thread discussing PowerQuery.

                                      Steve K [MS Excel]

                                    • Mac numeric keyboard changing from dot to comma

                                      Dear sir or madam,
                                      As soon as I upgraded to office 365 on my MAC, I have this really irritated problem:
                                      When I input numbers as accounting or currency in the sheet, I usually use the numeric keyboard (which is on the right side of the keyboard). Beforehand I use the dot (.) as the comma (,) in this numeric keyboard in the oud version excel (2011). But with the new excel 2016, the dot (.) appears to be the dot (.). So I have to use the comma key on the other side of the keyboard, which is near…

                                      3 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Fixed Width Data Import Wizard Needs Scroll Bars Like Windows Version

                                        The fixed width data import wizard does not allow horizontal or vertical scrolling in the data preview like it does in the Windows version. This makes it impossible to create or edit Connections for complex text data files. I see at least one other person here with the same request and the issue is far from a new one to me.

                                        5 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Text import Wizard

                                          The font used in the text import wizard really needs to be changed. 1. The preview window is to small and the font used in the preview window is to small and should be like Helvetica or something so the text is much easier to read. The zero's wth slashes is awful. please fix this so it is as nice as the windows version. Thank you.

                                          4 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          Feedback and Knowledge Base