Excel for Windows (Desktop Application)
Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more
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.
-
under data toolbar, data type is not there.
data type such as stock , option is not there, kindly add it.
1 voteThank you, we really appreciate you taking the time to write up this piece of feedback.
In order to access data types that link to external sources of data such as Bing, Wolfram Alpha, and more, you must meet these requirements:
- Have an active Microsoft 365 subscription
- Have the English editing language added to Office Language Preferences.Thank you,
The Excel Team -
'Film, TV and Music' 'Data Type'
I'm not sure if this would be a common use case but I keep a tracking list of the T.V series' and Movies I watch in excel.
I use it to track the seasons that have been released, which seasons I've watched, when the next season is due, etc.
A lot of the fields are taken directly from wikipedia or some other website if wikipedia doesn't contain it (rarely the case).
It would be amazing if I could select these titles as a data type and have all the fields available to me the same way the fields are available…
1 voteThank you for your feedback! Movie and Music are two new data types coming from the partnership with Wolfram Alpha (https://support.microsoft.com/en-us/office/what-linked-data-types-are-available-in-excel-6510ab58-52f6-4368-ba0f-6a76c0190772).
Please note that data types from Wolfram Alpha are gradually being rolled out to subscribers. If you want to use them now, you must be in the Beta channel on the Insiders Program. -
Default the Power Query formula bar as on
In the Power Query editor window the formula bar is defaulted as off. This is the first thing I tell people to turn on as it’s key to avoiding unintended errors and future proofing your code.
As Gil Raviv says in his book, “ Enabling the formula bar is fundamental to avoid the pitfalls”
64 votesHey,
Following your input, we have recently added this feature!
When you open the Power Query editor, you will see the formula bar by default.Thanks!
Jonathan Kahati
[MS Excel] -
Option to get old text data import wizard
The new data import editor has some major flaws:
First, it takes 100 times longer to import some simple 500 rows of data
Second, the date format selection for columns (e.g. I want to convert MM/DD/YYYY format to DD.MM.YYYY)I understand that the new import editor has some advantages but I do not need any of the new functions it has. The old text data import wizard could do everything I needed it do do.
38 votesThis is already supported. In order to restore the legacy Get External Data experience, please follow this article: https://support.microsoft.com/en-us/office/unified-get-transform-experience-ad78befd-eb1c-4ea7-a55d-79d1d67cf9b3#bkmk_restorelegacy
Hope that helps!
Inbar Privman
Excel Program Manager -
Be able to turn off auto-conversion of fractions and words into dates
When I import data in the format of a fraction #/#, excel automatically converts this into a date. This is unnecessary and should not be a default operation. At least, there should be a simple way to undo this.
I work with biological data, and there are gene names like "Oct1", and these get converted into dates, causing errors in data analysis.
1 voteHi,
You can do this already in Excel today – there are two ways:1. You can type an apostrophe before the data you enter → ’Oct1, and Excel will then not interpret that as a date (it will interpret it as Text).
2. If you format the cell as Text before typing the value in the cell, Excel will not interpret it as a date.
Hope that helps,
Dan [MS] -
SQL query tools integration
Ability to run SQL queries, being able to select / union select from multiple worksheets
Using the same SQL tool, updated / insert records in other worksheets ( tabs)
1 voteHi,
This is already supported using the ACE OLEDB driver.
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Cheers,
Dan [MS]
- Don't see your idea?