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. Add PDF Connector to Excel PowerQuery

    Connectors available for PowerBI POwerQuery might be available for Excel PowerQuery too

    One example with missing support is PDF Connector

    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 →
  2. Add Data type by Date for excel


    1. Add World Days by Date


    2. Gold and dollar exchange rates by date


    3. Corporate Income and cost by date


    4. ...


    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 →
  3. prasanth

    prasanth

    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 →
  4. When inputting data on expiry dates for training, include a feature where the spreadsheet notifies you when the expiry date is coming up.

    When inputting data on expiry dates for training, include a feature where the spreadsheet notifies you when the expiry date is coming up.

    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 →
  5. 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 →
  6. In "Data > Get Data > From Web" there should be an option to authenticate using cookies.

    On the Data ribbon, there is option to Import data tables from web pages. But the authentication options for web-sites is pretty limited.
    I am unable to import "private" data in excel from the following URL:

    https://ca.pcpartpicker.com/user/hammadrauf/saved/Gb7tpg/by_merchant/

    I believe that my authentication data is stored in cookies, it is not a form based authentication.

    Thanks.

    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 →
  7. Add Split Rows into n groups to Power Query

    In Power Query you can easily split a column into multiple columns. Recently I have had several examples where I needed to split a data set into equal groups of 4 (not bins or frequency). I had to count the total number of rows in the data set. Then insert a blank row evenly between each quarter of the data set. Yes there's probably VBA to do it, but I'd rather have it as part of a PQ solution.

    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 →
  8. Override default data type classifications

    I work with long numeric IDs in excel every day. Opening a .csv with these long numbers, Excel's default behavior is to convert the values to scientific notation, in the process rounding the value so when you redefine the cell to eg, a number, the value it returns is no longer accurate. This is catastrophic in the context of a large number serving as an ID.

    The way to work around this is opening every .csv by using the Data -> Get Data -> From File flow correcting data type of the long number columns before opening the file, which…

    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 →
  9. An easy way to add CSV columns to an existing Power Query

    Whether you previously deleted columns and like to bring them back or new versions of the source data have new columns, it's very non user friendly to add such columns (having to go through previous Applied Steps). In the latter case, it might even be impossible.

    Please consider making it easy and straightforward like in Text Import where all you have to do is click Edit on the query and run the wizard again.

    Sources:
    1) https://superuser.com/questions/1496163/how-to-add-previously-deleted-csv-columns-in-power-query/1496624
    2) https://superuser.com/questions/1497174/how-to-add-new-csv-columns-in-power-query/1497727

    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 →
  10. Date picker directly through Data Validation date criteria "is valid date"

    I have tried data validation for Date in Google Sheet. Where we are able to get calendar in a cell directly through data validation.

    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 →
  11. when input data from txt etc...

    when I insert data from other text etc..., the first row has been column and filtered, when I uncheck the related boxes, the first row's format cannot disappear.
    why special set the first row to that automatically, it is not useful design and cause distribute to users.
    i think this design likes taking coals to Newcastle.

    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. Data types - Please add an option for hiding/unhiding the icon

    Hi there,
    I would like to suggest to have an option, working on a workbook level, to hide/unhide the icons for cells having data types.
    When, for example, printing a report, there may be no need to print out the icons, as only the information is relevant.
    May be it would be possible to have a such option in the page layout tab, like for the gridlines?
    Best,
    Mourad

    2 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 →
  13. Data types - Please add an option for the icon position

    Hi there,
    I would like to suggest to have an option where to place the icon shown in cells having a data type.
    Additionally, I would like to suggest for left-to-right reading languages to have the default position of this icon on the right side of the cell.
    This would for example allow text to be placed vertically at the same position compared to titles and therefore give a more uniform visualization in e.g. reports.
    Best,
    Mourad

    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 →
  14. Feature for the Stock data type: include annual divided.

    Feature request for the Stock data type: include annual divided.

    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 →
  15. Link workbook to an Access database to use Excel as front-end GUI.

    Let's be up front...
    MS Excel's database functionality is lacking. MS Access' reporting/GUI functionality is severely lacking. Why not create the ability to unite the two?

    Excel's worksheet grid UI rocks for data presentation, especially for ease of use. The closest thing in Access to Excel's grid is the data sheet. Well... the data sheet stinks, like a dead carcus. Let's not even get into Access' poor and sorry reporting features - or lack thereof. Because we can create awesome user forms in Excel, how about the ability to create a table in an excel worksheet and link that table…

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

    We’ll send you updates on this idea

    4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Intelligent data import and create a database in Azure

    For small organizations or groups in large organizations, there should be a way for someone to provide historic spreadsheets with similar columns. Machine learning or AI can be used to identify similar columns with slightly different names. Then the data should be imported with simple clicks to create a database in the backend. This new database is like the old Access database in cloud. That way, a lot of historic data or even ongoing data from different teams can be easily consumed. I was involved in at least two projects where I need to write or run a program to…

    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 →
  17. enter data from picture app

    enter data from picture app use Ai to work out and insert formulas not just enter numbers

    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. Align MS Project and Excel import and export formats

    Importing and exporting between msp and excel is a formatting horrorshow (starting with msp export including timestamps by default). Cleaning the export for updates and comments, let alone aligning the formatting for msp import (no formulas allowed, file must be closed,...) takes too much time. Finally, wizard column IDs should be exactly the same than what user sees in msp columns (ie. Customised longer name). Takes ages to check and/or test that right setup has been configured and stored

    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. LEAVE IT ALONE!!! WHY DO I HAVE TO WORK AROUND ALL YOUR IMPROVEMENTS THAT DO NOT WORK???

    QUIT FIXING IT - IT WORKS, I SPEND MORE TIME TRYING TO GET YOUR IMPROVED VERSION TO WORK THAN I DO WORKING PRODUCTIVELY. STOP CHANGING THINGS. THERE IS NO VALUE IN TRYING TO FIND WHERE YOU MOVED A FEATURE OR TRYING TO DEBUG A GOOD FEATURE YOU BROKE.

    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 →
  20. Why some stocks aren`t available at Office365? Ex. KNRI11, MXRF11, BCRI11

    I am using Excel Office365 (Data - Stock) and some stocks available at B3 are not available for Excel Office365 (MXRF11, BCRI11, KNRI11) - a support person from Microsoft told me it is because Excel Database is not updated. Okay, but it doesn`t make sense, how a Stock Listed in Market is not available? Can you guys include/update 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 →
← Previous 1 3 4 5 12 13
  • Don't see your idea?

Feedback and Knowledge Base