Welcome to Microsoft Forms Suggestion Box!
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
-
Allow updating record
As participants have more current information available, they reenter the questionnaire and complete the answers. this creates double loggings.
Please provide the option to allow participants to update their responses without creating a new record when they rerun the questionnaire?7 votes -
Response will allow in share drive... like google form .. google form is very good.. we can make graphs in google excel drive
Response will allow in share drive... like google form .. google form is very good.. we can make graphs in google excel drive
7 votes -
Reflect the deletion of responses in Microsoft Forms automatically to the “Forms for Excel” files.
*English follows Japanese
■Title(件名):
Microsoft Forms で回答を削除した場合、OneDrive for Business に反映させる方法についてReflect the deletion of responses in Microsoft Forms automatically to the “Forms for Excel” files.
■Description(内容):
現在、OneDrive for Business から [新規] - [Excel 用 Forms] でフォームを作成している。
Microsoft Forms から、[結果の表示] から回答を削除、もしくは [すべての結果を削除] とした場合、OneDrive for Business の Forms の Excel ファイルに反映されない。
OneDrive for Business から該当の Forms の Excel ファイルを開くと、削除したはずのデータもそのまま表示されている。
[すべての回答を新しいブックへ同期する] を行うと 削除が反映される動作になる。
しかしながら、現在、OneDrive for Business の Forms の Excel ファイルに関数を設定している為、[すべての回答を新しいブックへ同期する] を行うと新しいファイルが作成され、新たに関数を設定する必要がある。
関数を設定したファイルをそのまま利用する為、Microsoft Forms の結果を削除して、繰り返し同じフォームを利用したい。
Microsoft Form で削除した結果を OneDrive for Business の Forms の Excel ファイルに自動で同期されるように改善を希望します。Currently, we create forms by clicking [New] – [Forms for Excel] in OneDrive for Business.
However, even…7 votes -
allow creators of forms to alter the settings for excel export
It would be good to be able to choose what to export to excel. Currently it exports time start, time finished, email, name, total points, answers, points and feedback etc Would like the option to just export some of these. EG I just wanted to export name, total points, each question points.
7 votes -
Ability to choose Excel sheet destination
It would be great if we could choose what workbook (and sheets in that workbook) a specific form feeds into, so we can have multiple forms flowing into one workbook.
7 votes -
Me gustaría que cuando se exporta forms a excel aparecieran las calificaciones de los formularios
Me gustaría que cuando se exporta forms a excel aparecieran las calificaciones de los formularios
7 votes -
Export of Forms response results
*English follows Japanese
■Title(件名):
Forms の回答結果のエクスポートについて
Export of Forms response results
■Description(内容):
GUI 上ではアンケートの回答結果がグラフで表示されます。
しかしながら、回答結果を Excel にエクスポートした際には、グラフは作成されません。
回答結果のグラフもエクスポートできるようパフォーマンスの向上を希望します。Results from surveys show as graphs in the GUI.
However, if you export the results to Excel, the graphs don’t get created.
Please improve performance by allowing the export of the results graphs, too.6 votes -
Customization of “Response” Excel files
*English follows Japanese
■Title(件名):
回答の Excel ファイルのカスタマイズについて
Customization of “Response” Excel files
■Description(内容):
回答の Excel ファイルに事前に Azure Active Directory の属性 (部署など) と連携させて集計を行えるように、集計項目をカスタマイズできるように機能拡充を要望します。
I would request for a feature to customize summary items so that I will be able to carry out various measurements by linking “Response” Excel files to Azure Active Directory attributes (such as “department”) in advance.6 votes -
Export results without Excel's interpretation
There needs to be way to export the results without Excel interfering with them. This could be CSV export, or give us the option to run the results through Excel's very good import function before displaying.
When opening the results in Excel online, Excel tries to be helpful and automatically interprets some fields. The most destructive is where Excel decides that something is a date. Once it's decided my data is a date, I don't seem able to get the original text value back.
The results are inconsistent and seem to default to US date interpretation, for example:
"1 -…6 votes -
optie om de 'antwoorden' automatisch te laten verzamelen in een excell en waar de nieuwe antwoorden automatisch bijkomen
Optie om de 'antwoorden' automatisch te laten verzamelen in een excell en waar de nieuwe antwoorden automatisch bijkomen.
Momenteel kan je de antwoorden in een excell opslaan maar bij elk nieuw antwoord moet je en nieuwe tabel downloaden.
Met een excell die zichzelf update bij nieuwe antwoorden blijf je constant op de hoogte van alle antwoorden en is er veel minder werk!6 votes -
Add feature to save the responses of Forms in Excel files
*English follows Japanese
■Title(件名):
Forms で入力してもらった回答についてAdd feature to save the responses of Forms in Excel files
■Description(内容):
Forms で入力してもらった回答を自動的に自由なレイアウトで Excel に保存できるよう機能の実装を希望します。
例: 氏名・住所・電話番号を申込用紙のような形で PDF で出力する。I would you to implement a feature to save the collected responses of Forms in Excel files with any layout.
Ex) Export PDF as responders’ full name, address and phone number in like an application form.6 votes -
Don't Have Excel Desktop. Need Open in Excel Online Option
I don't Have Excel Desktop. In forms I need the "Open in Excel Online" option instead of "Open In Excel".
6 votes -
Have "input from excel" function
Have "input from excel" function
6 votes -
Excel en One Drive
Crear hoja de calculo en onedrive que se alimente en cada respuesta para evitar tener que descargar el libro de excel. Esto permitiría que hubiera un manejo de las respuestas del formulario como gestión de solicitudes
6 votes -
Option where to save the Excel linked result
Add and option where to save your Excel linked results. OneDrive could get messy if you're working with a number of MSForm survey/quizzes. ☺
6 votes -
Allow the import responses from Excel to Forms
I alredy have the responses of a form and I create the Form (with the same fields) using "Microsoft Forms", but I need to copy and past each response. So I suggest you to implement a button to import responses from Excel.
6 votes -
Refresh Excel question order when rearranging MS Forms questions
I have had to rearrange the question order in my Form when creating a survey, yet when I open the Form in Excel the columns are in completely the wrong order, and there are even blank column headers rather than questions.
I have tried to move the columns around on the Excel sheet, but keep receiving an error message. I have tried 'Refreshing all connections' to see if that rectified the issue, but have has no success.
There either needs to be a live refresh built into Forms for Excel, or there should be an option to be able to…
6 votes -
Create a prepopulated Form from excel
Allowing for the creation of a MS Form from a pre-specified Excel template for the use of Dropdowns and Authorisation data.
With the ability of creating a pre-generated list of responses, for those like Book vendors or staff members.6 votes -
Allow users to open Forms for Excel file in edit mode on OneDrive for Business
*English follows Japanese
■Title(件名):
OneDrive for Business からフォームのファイルを開くと、読み取り専用のコピーが表示されるAllow users to open Excel files in edit mode on OneDrive for Business
■Description(内容):
OneDrive for Business から Excel 用 Forms を作成した場合、ユーザーが回答を送信すると 5 分間 Forms の Excel ファイルを編集モードで開くことができない。
ユーザーがアンケートに回答後、 5 分間の間に該当のファイルを開くと
"このファイルは、SharePoint アプリによって編集がロックされています"
"読み取り専用のコピーを表示する"
"ファイルのコピーを保存して編集する"
と表示される。ユーザーが回答を送信した直後であっても、編集モードで Forms の Excel を編集モードで表示できるように改善を希望します。
Currently, users are unable to open Forms for Excel file in edit mode for 5 min after users send a response to a survey when we create Forms in Excel on OneDrive for Business where simultaneous editing is disabled.
User get error (see below) if they try to open applicable files…6 votes -
Provide the availability of the Collaborate editing in Microsoft Forms with the specific external users.
*English follows Japanese
■Title(件名):Microsoft Forms を特定の外部ユーザーと共同で編集する方法
Provide the availability of the Collaborate editing in Microsoft Forms with the specific external users.
■Description(内容):
Microsoft Forms は、現在、"リンクを持つすべてのユーザー" もしくは "組織内のユーザー" の 2 種類のみ選択可能な状態です。
特定のセキュリティグループを選択するなどして、一部の外部ユーザーのみ共有をし、フォームを作成、編集、URL を送信できるような機能の実装を希望します。Currently, we recognize the Microsoft Forms feature that we can select two types of user for "Anyone with a view link" or "People inside my organization" only.
In order to further improve usability, we hope the feature will be implemented that allows us to select specific security groups, select it to be shared for only to the specific external users, or create/ edit of forms freely as well…
6 votes
- Don't see your idea?