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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Amazon Redshift Connector

    Creation of an Amazon Redshift Connector for Power Query that is similar to Power BI.

    https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-redshift/

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. Use Edge Browser For Get Data From Web

    Get data from web still uses Internet Explorer. This is insecure, gives out many errors, and doesn't look user-friendly.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Improve Text Import Wizard

    Some suggestions for the Text Import Wizard.

    When starting text import from a certain row, the previewer in steps 2 and 3 still show the preceding rows.

    Allow resizing the window.

    Allow more data formats (all actual data formats available in the main part of Excel).

    Add a function to save steps to be batch applied to files.

    4 votes
    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 →
  4. New Data Source -> Existing Get And Transform Query

    I find it common to create a singular Get and Transform query that performs a baseline set of commands that are then split off into various outputs. This creates a cascade of queries which is not particularly challenging via the Advanced Editor.
    "let
    Source = Query_Name
    in
    Source"

    As easy as that is, simply needing to access the Advanced Editor immediately many users away from the concept.

    Something simple like having the option under "New Query" to select an "Existing Query" would be immensely useful and, I would think, incredibly easy.

    The attached file demonstrates this in action. Making it…

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. ability to update source data through Power Query view

    The use cases comes up regularly when working with data sets joined from several sources, e.g. a database and an Excel table. In many useful cases one just needs to carefully bubble the change through a series of joins and filters to figure out which rows to update in the original database table, CSV file, etc.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. check the question "IP Address as a datatype." as more would love to have it (including me)

    Make a datatype format category for IPv 4 & 6 (12 position and 20 bit IP addresses). Opening csv imports of IP Address lists removes zeros and hence changes the sort order

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  7. import multiple txt files

    I have a folder with 15 tab delimited .txt files. I want to import and graph 7 of them. The only solutions online suggest merging all files into one .txt, or to plug in a VBA.
    This should be more user friendl, like an "import multiple" button, or simply the option to select multiple .txt files on import.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Power Query Sharepoint Dates Don't reflect regional settings

    When querying a SharePoint list, it brings dates back as American format and not regionalised. Even though in SharePoint the date settings are set correctly to New Zealand, dates are incorrect. This also happens in Power Query in Excel and PowerBI. They display correctly in SharePoint. The query brings them back as Text, which also fails when converting to dates because our regional format is dd/mm/yyyy so any date like 16/11/2016 fails and gives an error. This makes querying SharePoint not really usable in our region. It also doesn't bring back timezone information.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. change data source for all Pivot tables without VBA

    you cannot change the data source for 2 or more pivot tables (conneceted to the same data source) that "share" the same slicer.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  10. Color cell to sum number cell

    Post a number in a in a cell based on the color of the cell nest to it. IE sum cells c2-c5 if color of cell d2-d50 is red/green.

    7 votes
    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 →
  11. Enable user to specify default column breakout for inserted/pasted data such as from CSV instead of using the last Text to Columns setting

    When a user imports data, Excel uses the last Text to Columns setting. It would be nice to have this be a different default setting.

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  12. Enable excel online spreadsheet as data source

    I would like to be able to use an online excel spreadsheet as a linked data source. Simply paste the excel file url and it likes (similar to sharepoint list, but way easier)

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  13. During imports in Excel please bring in the table names from SQL Server!

    I'm doing data import and PowerBI and Excel have such different feels. It would be nice to have tables import with their table names like in PowerBI.

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

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  14. allow customization of dropdown button used on dropdown lists. Specifically make larger

    allow customization of dropdown button used on dropdown lists. Specifically make larger...but different colors would be nice too

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  15. Respect Columns when Copying and pasting a table from a table or web site

    When copying tables from a web site or other table, and pasting into an Excel Spreadsheet, the data is all put in one column. It should be pasted into separate columns. The workaround is to copy and paste one column at a time is quite cumbersome and sometimes does not work if there are blank cells.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Speed up queries against exchange folders with Power Query

    I have 10.000+ in calendar items and I use Power Query to have a report of hours spent by categories. Updating that query takes too long. It has to requery all the 10.000 items just to get the single one that has been added. Maybe query folding is not working against Exchange?

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. Stop loading PowerQuery queries from stealing focus

    When you load data via PowerQuery it renders Excel unusable because every few seconds the UI element of the query refreshes and takes focus. So if you open up a new instance of Excel you will be dashed back to the Excel spreadsheet with the running query despite starting a separate new Excel document. It makes multi-tasking difficult!

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow us to remove all connections instead of individually

    I need to be able to remove all connections not one at a time in the connections box related to 3D Maps.

    https://1drv.ms/i/s!AjApVpgq6WQ0h5czVah8SBvTv7zklw

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. Provide a tool to show, in detail, exactly what Excel thinks a cell contains.

    When I import data by copying/pasting tabular data or similar, I often wind up with what looks like valid Excel data, but for one reason or another Excel can't process it. It can be something simple, like a spurious trailing (or leading) blank, or more complicated. I have spent hours in the past trying to figure out why Excel can't use what looks like perfectly fine data, and figuring out how to massage that data to make is usable. Excel sorely needs a way to tell the user exactly what it thinks a cell is, with, perhaps, suggestion(s) of how…

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

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. Create a PowerQuery Folder function wizard

    PowerQuery would be great if it was provided with the capability (current capability fixed) to import bulk XML and excel files. Currently excel is achievable with workarounds of creating a function for the folder function(why?) as in this post http://www.excelguru.ca/blog/2015/02/25/combine-multiple-excel-workbooks-in-power-query/ however it becomes even more obtuse (though) it shouldn't if you have an xml file representing more than 1 table.

    Pressing import from Folder should expect that you are doing just that and ask what file type, then load the first file to edit as desired and then execute against all files in folder.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Feedback and Knowledge Base