Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

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 Windows (Desktop Application)?

(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. Show Tables in Power Query when opening an xlsb file

    When using Power Query / Get Data to open .xlsx files and .xlsm files, the Tables present in those files are shown in a list.
    When opening a .xlsb file only Sheets are shown and not any of the Tables present within the file.

    If there is only one table on a sheet, AND it starts in cell A1, then it is relatively easy to still load the data, but where there are multiple tables per sheet, OR the tables don't start in A1, then there is a lot of unnecessary work deleting Rows and or Columns to obtain your…

    39 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

      10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    • Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

      It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

      This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

      It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

      185 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

        3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
      • Provide an Option for Column to Text

        It would be nice to have a Column to Text option inside Excel.
        Currently we can move from Text to Column but the other way round is not provided.
        Recently while working with a database, I faced this issue. I had to convert database from MM to INCH. I pasted the database inside excel and moved each value (Semicolon separated) to a separate column using Text to Column. I updated the values using formula.
        However, I needed it to be delimited by semicolon again to put it back into database. And I could not do it by any built in…

        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 →
        • Better link SSAS data types and sort by columns

          Currently when I build an SSAS (Tabular) model with a date column (date format) it comes across as a general (text) format and cannot be sorted chronologically. This occurs even when the set sort by column is integer. It appears that Excel is not reading the data types or sort by columns from the SSAS model. Other tools (ie Power BI) are able to handle this correctly.

          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 →
          • Add support for custom data connectors (Power Query M extensions)

            Custom Data Connectors mechanism is being developed by Power BI Desktop team:

            * https://github.com/Microsoft/DataConnectors
            * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md

            Excel's Get & Transform engine (Power Query) should have support for *.mez/*.pqx extensions too.

            7 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 →
            • Improve Queries and Connections Task Pane

              Having used the newfangled Queries and Connections pane for some time now I find it is time to add some suggestions

              My issues:

              1. The pane does not remember its size
              It opens really narrow on my system, displaying only a (very) small part of the connection and query names so my first action every friggin time is to drag it wider.

              2. No multi select
              in the old connections window you can control or shift-click multiple connections to delete them. For maintenance this is a very useful feature I miss regularly.

              3. It isn't application-centric
              If I open a…

              20 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

                2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
              • Power Query - Add option to retain all cells (nulls and errors) when using Unpivot Other Columns

                Using Power Query to Unpivot other columns is an amazing feature but it automatically removes nulls and errors.

                Add a drop down down (maybe an advanced option) to Unpivot Other to allow the keeping of all items

                18 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

                  3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                • full anti join (Power Query)

                  Do a Right and Left Anti Join in one sweep. So figure out the outliers in both tables in one go.

                  10 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

                    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                  • turn off automatic date conversion

                    Opening scientific data in excel for review or analysis purposes is a nightmare in Excel. Some values, gene names and other text automatically transforms into dates and then the data is corrupted. Changing cell format in this case corrupts the data even further and there's no way to return to the original value/text, since the data corrupts when opening the file. This is the worst functionality in Excel and I don't know anyone who benefits from the automatic transformation of dates. Please the date transformation optional setting for those who might need it!

                    23 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 →
                    • Incremental data load in PowerPivot through Power Query

                      Please,

                      We work with very large databases. Every time we update the information, it reloads all the data in the Power Pivot through Power Query, which takes a long time.

                      Undoubtedly we can make separate queries with the history and have the results added by DAX, but this forces us to duplicate all the metrics in DAX and parameterize everything.

                      Our request is whether there could be any way to update the data incrementally???? it would be fantastic.

                      Thank you.

                      PD.- Now we are using and we recommend our clients to use PowerUpdate that allows to program the update of…

                      2 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 →
                      • HEY FUCKFACES- DID YOU FIX THE ******* "HIT ESCAPE EVERY ******* TIME YOU CUT AND PASTE IN EXCEL 365" CRAPWARE UPDATE FROM JUNE 2017 TODAY?

                        HEY FUCKFACES- DID YOU FIX THE ******* "HIT ESCAPE EVERY ******* TIME YOU CUT AND PASTE IN EXCEL 365" CRAPWARE UPDATE FROM JUNE 2017 TODAY? THOUGHT I WOULD GIVE YOU FEEDBACK EVERY TIME I HAVE TO HIT ESCAPE WHILE WORKING FOR AWHILE. *********.

                        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

                          1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                        • visually indicate which power query steps have comments

                          When we add comments to Power Query steps it isn't obvious that the comments exist. A flag of some sort would be great

                          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

                            1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                          • Load Tables as separate queries into Power Query Editor in one step

                            When we have multiple Excel Tables in a workbook, and we want to load them as separate queries into Power Query, it is quite time consuming as we need to load the Excel Table one by one.
                            A quicker workaround is to use Excel.CurrentWorkbook() function to load Excel Tables in to PQ Editor, then right-click the Table and select "Add new query"... Although it is feasible, it requires a lot of clicks. Imagine we have 20 Tables to load...
                            So my suggestion is, to add one more option to "Expand"... as Separate Queries.

                            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 →
                            • It isrecommended that date data was extended to the beginning of 0 A. D.

                              It isrecommended that date data was extended to the beginning of 0 A. D. to facilitate the calculation of historical events and historical figures.

                              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 →
                              • speech to text

                                Why not allow speech to text in entering data in 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 →
                                • Web Query by Example (As per in Power BI)

                                  This suggestion regarding about the features used to pull external data from web sources. I've used excel to run external queries on other Sharepoint site excel sheets which has been very helpful and I am aware of the tools to make web queries - however as far as I've been able to tell this feature is strict about the web source's formatting, specifically that it seems the source must be in a table.

                                  The 'Power BI' application has unveiled this feature (https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example) last month where you can specify examples of the fields to collect from a web page…

                                  2 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 →
                                  • Power Query don't load sample file when combining files from folder

                                    When you use Power Query to get data from folder you hit an issue if you try and Load to Table, due to the Sample File being loaded also.

                                    Can this be fixed?

                                    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 →
                                    • Power Query Editor - Allow us to make the final right hand column wider

                                      Currently we are able to make every Power Query Editor column wider, except for the last one! Which when using the Add Column functionality is the one you really need to be able to expand.

                                      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 →
                                      • 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 →
                                        • Data is wrong when opening csv file

                                          When csv file contains values like 1-2;1-4;1-5 they are automatically convented into dates 01.02.2018 01.04.2018 01.05.2018 when file is opened. If you save file then date will be written insted of orginal data. It's serious bug.

                                          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 →
                                          ← Previous 1 3 4 5 11 12
                                          • Don't see your idea?

                                          Feedback and Knowledge Base