Microsoft Forms includes rich, real-time analytics that provide response summary information and individual results for surveys and other types of forms. You can export the results to Microsoft Excel for more in-depth analysis, as well as delete or print a summary of responses.
View response summary information for your form
In Microsoft Forms, open the form for which you want to review the results, and then click the Responses tab.
Across the top, you’ll see summary information data about your form, such as number of responses and average time it took for respondents to complete your form. Next to each question, you’ll see the number of responses and a chart that shows a breakdown of responses.
Note: You'll see the Ideas icon if there are insights generated for your form. Learn more.
View details for each question
Select the More Details link under individual questions on the Responses tab to see more details for that question.
Tip: Select the column headers to sort the response results.
Check response data for each question
Select View results to see individual details for each respondent.
Use the left and right arrows to toggle through the result details of other responses.
You can also use the drop down list to jump to the results of a specific respondent.
Note: If you have more than 50 respondents, scroll down to the bottom of the drop down list and select Show more respondents to see remaining responses.
You can also search for an individual response by entering the number (e.g. 25) in the Respondent field that's associated with that response.
Tip: Searching for an individual response by the identification (ID) number associated with it is especially helpful when responses are collected anonymously. The respondent ID is exclusive for each response, which can be found in the first column of your workbook if you export your responses and open them in Excel.
Select More options to delete all responses, print a summary of responses, create a summary link to share with others, or sync all responses to a new workbook.
Tip: Learn more about printing forms.
View form results in an Excel workbook
You can easily view all of the response data for your form in Microsoft Excel. Click Open in Excel on the Responses tab to capture a snapshot of your current response data in a workbook.
If you've created your form in Forms on the Web (https://forms.office.com) and click Open in Excel, an offline Excel workbook will open that has no relationship or connection to your form.
If you've created your form in OneDrive for Business and click Open in Excel, your Excel workbook is automatically stored in OneDrive for work or school and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.
If you've created your form in Excel Online and click Open in Excel, your Excel workbook is automatically stored in OneDrive for work or school and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.
Troubleshoot exporting data
If you're experiencing a download error, learn how to troubleshoot exporting form data to Excel.
Analyze form results in Excel
In your Excel workbook, details of each question in your form are represented in columns and each response is shown in a row. The first five columns display respondent ID, start and completion times for each response, and the name and email address of each respondent. The subsequent columns display that respondent's selections.
The respondent ID is exclusive for each response in your form. You can find individual responses and their corresponding respondent IDs by clicking View results on the Responses tab of your form.
Any changes you make to your workbook won’t modify the content of your form.
Names and email addresses won’t be displayed if you allow your form to accept anonymous responses.
Share results with others
Select the Responses tab.
Click More options .
Select Create a summary link.
When you paste this link, anyone that has the link will be able to view a summary of responses for your form.
If you're collaborating on a form with specific people in your organization, only you, as the form owner, can create a summary link for your form if one doesn’t yet exist. Co-authors can still copy and share your summary link, but can't create one, themselves. In other collaboration modes not set for specific people in your organization, co-authors can create new summary links.
Also note that if you share your form responses with anyone in your organization, and then decide to share with only specific people in your organization, any summary sharing link that already exists can still be accessed by anyone inside or outside of your organization. You can delete an existing summary link to disable it, which will reduce access to the response data. You can do this by going to the Responses tab > More options > Get a summary link > Remove link (trash can icon). Optional: You can then create a new summary link if you want to share it with a new audience, but this new summary link will still be accessible by anyone who gets a hold of it.
Note: We are gradually rolling out the ability for you to collaborate on a form with specific people in your organization. This feature will be available soon.
Got feedback on Microsoft Forms?
We'd love to hear from you! Please visit the Microsoft Forms UserVoice site to provide suggestions and vote on ideas others have already submitted.