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.
-
'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. -
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?