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

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

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

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

Is it possible to import questions in Excel into Microsoft Forms?

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!

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.

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!

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.

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

Sarebbe utile nelle risposte multiple avere l'opzione di imporre un limite al numero delle risposte.

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

يرجى التعديل للمدارس لايوجد وقت للاضافة بالايميل

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.

Data from forms exporting to Excel converts numbers into text

I'd like to use forms but have something similar to smartsheet or excel where cells in a workbook and be completed and submitted/