Welcome to Microsoft Forms Suggestion Box!
We love hearing from our customers. We have partnered with UserVoice, a third-party service, to hear your ideas and suggestions. We may also merge and rename suggestions for clarity.
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.
-
About export of Forms results
*English follows Japanese
■Title(件名):
Formsの結果出力について
About export of Forms results
■Description(内容):
Formsのアンケート結果画面で Excelで開くを選択するとローカルに保存される動作となっている。
利便性向上のため、結果ファイルをOneDriveへ直接出力できるよう機能の拡充を希望します。Selecting the option to open Forms survey results in Excel will save them locally.
In order to improve usefulness, please add a way to directly export result files to OneDrive.8 votes -
Forms function to change the responder’s “email” to the primary mail address instead of UPN when opening responses in Excel
*English follows Japanese
■Title(件名):
Microsoft Formsにて、応答内容を "Excel で開く" で開いた際に、応答者の "メール" の項目を UPN ではなく プライマリ メール アドレスに変更する機能の実装を希望
Forms function to change the responder’s “email” to the primary mail address instead of UPN when opening responses in Excel
■Description(内容):
応答内容を "Excel で開く" にて開いた際に、"メール" の項目を非表示にする機能を希望いたします。
背景としては、UPN にユーザー固有の番号が含まれており、この番号を個人情報と捉え、回答として希望しない場合があるためです。Please add a way to hide the “Email” item when you open a response using “Open in Excel”.
As background, user specific numbers are contained within the UPN, and these numbers may be classed as personally identifiable information which you do not want to be included in responses.12 votes -
Automatic entry of an Excel cell’s information in a form
*English follows Japanese
■Title(件名):
フォームに Excel のセルの情報を自動入力について
Automatic entry of an Excel cell’s information in a form
■Description(内容):
Excel シートにアンケート機能を埋め込んで、メールで返信いただく作業を検討しています。
・Excel ファイルには、別のデータもありますが、アンケート機能として埋め込んだ内容をみて回答をしてもらいます。
・その時、誤入力を避けるため、ファイルのセルの情報 (ファイル名を関数でとりだしたもの) を自動的にフォームに入力させたいと思います。以下について機能追加を要望します
・Excel シートにアンケートの機能を埋め込む機能
・ファイル名を関数でとりだしたセルの情報を、フォームに自動入力させる機能We are considering embedding a survey function in an Excel sheet and responding by mail.
・There is other data in the Excel file, but we only have the information embedded as a survey in responses
・At that time, to avoid mistakes in entry, we want the files cell information (file name extracted as a function) to be automatically entered in the formPlease add the following functions:
・Function to embed a…3 votes -
Add user information to automatically show when viewing Forms results as an Excel file
*English follows Japanese
■Title(件名):
Forms で回答結果を Excel ファイルで表示した際に、自動で表示されるユーザー情報を追加したい
Add user information to automatically show when viewing Forms results as an Excel file
■Description(内容):
現在、Forms でフォームの結果を Excel で表示した際に、既定で回答したユーザーの "名前" と "メール" 情報が表示される。
上記以外にも、電話番号等、Azure AD の情報を追加で指定し、Excel 上に反映させる機能の追加を希望します。Currently, when viewing results from a form in Excel, the “Name” and “E-mail” of the user is shown by default.
In addition to this, please add a way to select items to show, such as the user’s phone number and information from Azure AD.7 votes -
Allow the export of 50,000 items as an Excel file at once
*English follows Japanese
■Title(件名):
50,000 件の回答を一度に Excel ファイルに出力可能な機能の拡充を希望いたします
Allow the export of 50,000 items as an Excel file at once
■Description(内容):
Microsoft Forms の回答を Excel ファイルに出力可能ですが、現時点では 5,000 件ずつの出力となるため、回答上限である 50,000 件の回答を一度に Excel ファイルに出力可能な機能の拡充を希望いたします。While it is possible to export responses from Forms as an Excel file, at present they are exported in sets of 5,000 items, so please raise the upper limit to match the upper limit on the number of responses — 50,000.
9 votes -
to import questions in Excel into Microsoft Forms.
Is it possible to import questions in Excel into Microsoft Forms?
19 votes -
Be able to save the responses as numbers when they are restricted to contain numbers.
I have restricted a form entry to number format; however when I save the responses using excel the number saves as a character. Example: Form response of 7 saves in the excel document as '7. This is very inconvenient if you want to use these numbers in any kind of formula in excel. If this could be fixed I think it would improve forms greatly. Please consider doing this!
5 votes -
format the excel sheets we export AUTOMATICALLY
WHEN WE EXPORT THE excel sheet from forms the data fields are not automatically formatted to their correct data set. numbers are not numbers, time is not time etc.
I have to MANUALLY change EACH column in the excel sheet: I have 27 of these surveys with 25 students EACH, that means an enormous amount of work.
either format automatically or power up excel because right now I can only convert 1 single columns at the time to number.
selecting the whole sheet and choosing number as data set does not work at all.1 vote -
Data retrieval failure
Hi! I have some microsoft excel forms created with responses collected, but don't know why I couldn't retrieve the data. When I download the excel form, it is empty inside and said the file might be damaged. I couldn't even view the summarized result online. What can I do to obtain the data? Thank you!
1 vote -
Improved Data Extraction
The export to excel could be more sophisticated so the data can be 'played with' e.g. my wishlist for forms would be being able to pick how each question is opened in excel (a bit like qualtrics)...perhaps even the results opening in excel in tabular form would be good (as it does in the responses screen) which can then be 'played with' e.g. converted to different chart types.
1 vote -
Microsoft forms responses should go in online excel by default
currently the responses of microsoft forms open in excel application and separate file is formed every time you open the responses. why can this open in online excel like google forms open in google sheets?
case # 1015592421
1 vote -
Sarebbe utile nelle risposte multiple avere l'opzione di imporre un limite al numero delle risposte.
Sarebbe utile nelle risposte multiple avere l'opzione di imporre un limite al numero delle risposte.
2 votes -
make it an option that allow forms to show the submitters' email address instead of having it populate as anonymous in the responses
make it an option that allow forms to show the submitters' email address instead of having it populate as anonymous in the responses. Some forms do not require anonymity so it is cumbersome to have an extra column populate that says anonymous anyway. showing the submitters' email address is a good way to check that an email was entered correctly when asked for
3 votes -
إضافة ايميلات متعددة في نفس اللحظة
يرجى التعديل للمدارس لايوجد وقت للاضافة بالايميل
1 vote -
1 vote
-
1 vote
-
1 vote
-
Allow the ability to define custom column names rather than using the question
Currently all responses are stored in an Excel like table. That's great, but the headers are always the question. Not so great for two main reasons. 1) The question can sometimes be a very long sentence. 2) Changing the question (even slightly) changes the header. If you are using Flow/PowerAutomate, you need to get responses by referencing the column name, Things break easy in this scenario.
It would be awesome, if we can override the column header value for each defined question! This should be REALLY easy to implement.
1 vote -
When adding a 'number' restriction, have the data exported as 'number' instead of 'text'
Data from forms exporting to Excel converts numbers into text
17 votes -
ability to have a form similar to excel workout that can be filled out.
I'd like to use forms but have something similar to smartsheet or excel where cells in a workbook and be completed and submitted/
1 vote
- Don't see your idea?