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. Export all mailboxes to PST Exchange 2010

    Exchange EDB to PST Converter that has the power to extract EDB databases like emails, contacts, chats, tasks, notes, journals, and appointments to a new PST file. With this EDB to PST software, the user can easily retrieve all the database from any corrupt EDB file without using any difficult technical skill. It supports all version of Exchange Server and MS Outlook (including 2016, 2013, 2010, 2007, 2003, 2000, and below version) to easily make the conversion of EDB file to PST.

    Get more info:- https://www.esofttools.com/exchange-server-database-recovery.html

    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. 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 →
  3. 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 →
  4. Which is the best EDB to PST Converter Software?

    If you are Searching the best EDB to PST Converter Software that can easily Convert your EDB file to PST file then here is a best Software Regain EDB to PST Converter that can easily Convert your EDB file to PST file in just simple and easy process. this Software has simple and easy GUI Interface where you can easily Operate this Software. Both technical and Non technical user easily access this Software.

    You can try this Software free trial version from here: https://www.regainsoftware.com/edb-to-pst-converter.html

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

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

    We’ll send you updates on this idea

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

    44 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. select date for open/close stock

    You should be able to pick dates when selecting stock info.

    E.g set the date as 06/11/2019 to get XNAS:MSFT open price on that day.

    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 →
  13. Give the option to show metadata above tables that are loaded from queries.

    It would be nice to be able to show meta-data above tables that are loaded from queries. An example of this would be displaying the notes that are in the properties of the query two rows above the loaded table. Here are a few more examples: source data name or file location; last refresh time; errors; code-based message, hyperlink to the query, etc.

    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 →
  14. Stocks data - UK OEIF Funds

    J P Morgan Natural Resources Inclusive Class A Accumulation Fund (This is a UK fund) cannot be found under the Stocks Data listing. Please include. have tried looking for various different spellings etc.

    JPM Natural Resources Fund A - Net Accumulation (0P00000RC8.L)
    LSE in GBp

    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. 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 →
  16. Error in Table.AggregateTableColumn of Power Query M

    Table.AggregateTableColumn of Power Query M doesn't allow usage of type as 4-th parameter of an aggregation for last aggregation. I.e if you do this:
    Table.AggregateTableColumn(aTable, {"F1", List.Max, "NF1", type number}, {"F2", List.Max, "NF2", type number}) - no any column will be added, but if you do the same without type in the last aggregation - all works properly:

    Table.AggregateTableColumn(aTable, {"F1", List.Max, "NF1", type number}, {"F2", List.Max, "NF2"})

    1 vote
    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 →
  17. 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…

    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 →
  18. Syntax Highlighting in Power Query (Get Data)

    I would love for "Get Data" query editor to use syntax highlighting like the query editor in PowerBI Desktop does.

    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 →
  19. stocks data

    The stocks data is not finding Proton Partners International Ltd (XLON:PPI). I have checked and it shows on Morningstar, which the various posts here would seem to indicate is where the data comes from, but I have also seen a reply saying the data comes from Refinitiv. Whilst I think the stock data is a great addition it is certainly not up to par. There are so many stocks that it can't find or returns from the wrong exchange that it becomes so frustrating to use. Even when you look up the ticker elsewhere and include the exchange and ticker…

    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 →
  20. stock data

    There only appears to be a Buy price available via the Stockdata icon. Please add the selling price as well, as it is the selling price that is used to value stocks.

    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 →
  • Don't see your idea?

Feedback and Knowledge Base