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. 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…

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

    We’ll send you updates on this idea

    14 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. PDF Conversion for Microsoft 365 Subscribers -- Convert PDF within Word/Excel AND One Drive.

    I've seen a few comments on this, but it seems like something that would be an incredible addition to the Microsoft Office suite of applications. Especially for the Office 365 Subscribers --- This would be an incredible perk to build into 365.

    Additionally, an incredible benefit to Office 365 would be an extension in One Drive that allows for PDF export to Word, Excel, etc. That way you can do everything you need to do (as far as conversion) in one application, rather than having to go back and forth between 2/3 apps.

    Simplicity in design.

    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. Columns matching in queries append.

    In power query, append queries, I suggest having 2 methods of matching columns between queries, either by names or by order of the columns, based on user choice, to elaborate, if user choose the order, headers of the main query is used and data of the following queries are put in place by the position index of the columns, and if names are chosen, system will lookup based on the headers to place the data on right columns.

    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 →
  4. Allow user defined "text qualifier" when importing from csv file or text

    There are some cases where I export data from SQL server to a text file and want to open it with Excel. I do this because some of my columns have text that has newlines [ char(13) + char(10) ], which will not correctly import into Excel, when importing from SQL Server to Excel directly. There should be other cases where a user can't choose a pre-determined text qualifier from some proprietary software.

    This is where Excel should allow the user to choose the text qualifier instead of only having the pre-defined choices.

    LibreOffice Calc allows this functionality, and I…

    6 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. Mysql For Excel: No Connection Showing

    Earlier I used to load the data using Excel MySQL plugin. As of now am not able to see the connections which were added. Look like its a bug from recent ms off update. Please fix the same asap.

    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. Please update the stock ticker list. Several mutual fund tickers are not included in Excel's Stocks Data Type - including FZROX and FXILX

    Please update the stock and mutual fund ticker list. Several mutual fund tickers are not included in Excel's Stocks Data Type - including FZROX and FXILX

    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 →
  7. data clipboard

    Please add Clipboard as source to load data from (e.g. copied from a web page for example csv, text or json)

    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 →
  8. Stocks data of Shanghai Stock Exchange is needed

    According to the following article, Shanghai Stock Exchange is not supported, while other exchanges in China (Shenzhen, Hongkong, Taiwan) are available. Shanghai Stock Exchange makes up a large part of stock market in China. Suggest that the Shanghai Stock Exchange be covered.
    https://support.office.com/en-us/article/about-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6?ui=en-US&rs=en-US&ad=US

    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. keep visual basic for real world business

    Many businesses use programs like Peachtree, or even very large platforms like Meditech and Epic in Hospitals. They do not always have good implementations, and as a way to salvage poor operations we use data dumps into excel. The way the vast majority of power users have used this in the past is to use VISUAL BASIC to automate TONS of data manipulation. I have found, very clearly, that Office 2010 64 bit can be rolled out to several people and shared excel files with visual basic in them work fine. If one person has office 2013, or 2016 or…

    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. Please include KLSE(Malaysia) market data to Stock data type

    Please include KLSE(Malaysia) stock data to Stock data type

    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 →
  11. Please include other data in the new Data Types feature in Excel. The data for dividends is totally missing.

    For dividend/income investers, we really need dividend information if the data types for stocks is to be useful.

    11 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 →
  12. As the feature available on Android, I'm expecting that Handwritten Data Table should be converted in Spreadsheet Table !

    The Scanned or picture taken by Cell phone should be converted into Excel Sheet's Table ☺

    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. Improve stock data type search

    Some stocks are not easy to search, it would be easier if we could just enter the ticker and market, as there is just one ticker for stock and market.

    Other option could be integrating somehow all the predictive results that Morningstar offers when you start typing. Besides I find somehow difficult to pick the right stock, as sometimes you are not able to select from which market you want to get it.
    For example CVR Partners is not listed when searched and if you search by UAN, which is the NYSE ticker it just finds Yorbeau at German market,…

    6 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 →
  14. Cut and paste CSV and JSON right into cells rather than import.

    CSV and JSON formatted text is pretty obvious. It would be a lot easier to cut and paste CSV into cells such that each CSV delimited cell becomes one cell in excel.

    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. Please add tickers for S&P 500, Nasdaq and Russell 2000 markets.

    You have !DJI. Please add tickers for S&P 500, Nasdaq and Russell 2000 markets. (They are ^GSPC, ^IXIC & ^RUT at !Yahoo Finance)

    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 →
  16. Add the bid-ask spread to the stock data type

    Adding the bid-ask spread to the stock data type will inform the user of possible liquidity or sudden volatility issues with a fund.

    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. The new stocks data type should include ex-dividend date and earnings date. That is extremely useful information.

    The new stocks data type is great, but it would be even more useful if it were possible to get ex-dividend dates and earnings announcement dates. This is very important information, and it should not be too difficult to add,

    6 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 →
  18. Enhancment for Stock Data Type

    I really like the new data types, the stock data type is there a chance you pull Dividend pay dates and Dividend per share.

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

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. I need to delete duplicates but want to keep last one entry instead of first one entry. So, data -> remove duplicates is not working.

    I need to delete duplicates but want to keep last one entry instead of first one entry. So, data -> remove duplicates is not working.

    Also, note that my first column is key column to find unique entries and I don't have any column to apply filter or sort so that I can sort the data in reverse (i.e. date) and keep first one and then remove sort 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 →
  20. 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 →
  • Don't see your idea?

Feedback and Knowledge Base