Check and Share Your Form Results

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
• View Details for Each Question
• Check Response Data for Each Question
• View Form Results in an Excel Workbook
• Share Results with Others

View Response Summary Information for your Form

1. In Microsoft Forms, open the form for which you want to review the results, and then select the Responses tab.
   
2. Across the top (or on the bottom if you're using the mobile site), 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.

View Details for Each Question

1. Select the More Details link under individual questions on the Responses tab to see more details for that question.
   
2.  Select the column headers to sort the response results.

Check Response Data for Each Question

1. Select View results to see individual details for each respondent.
   
    
2. Use the left and right arrows to toggle through the result details of other responses.
   
    
3. You can also use the drop-down list to jump to the results of a specific respondent.
   
   1. If you have more than 50 respondents, scroll down to the bottom of the drop-down list and select Show more respondents to see the remaining responses.
       
4. 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.
   
   1. 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.
       
5. 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.
   

View Form Results in an Excel Workbook

You can easily view all of the response data for your form in Microsoft Excel.

1. Select Open in Excel on the Responses tab to capture a snapshot of your current response data in a workbook.
    
   1. an offline Excel workbook will open that has no relationship or connection to your form.
       
2. In your Excel workbook, the 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 the respondent's selections.
   
    
3. Please note:
   1. The respondent ID is exclusive for each response in your form. You can find individual responses and their corresponding respondent IDs by selecting View results on the Responses tab of your form.
   2. Any changes you make to your workbook won’t modify the content of your form.
   3. Names and email addresses won’t be displayed if you allow your form to accept anonymous responses.

Check out Microsoft's How to ensure your form and workbook are in sync support page for more information.

Share Results with Others

1. Select the Responses tab.
2. Select More options   > Create a summary link.
3. Select Copy.

When you paste this link, anyone that has the link will be able to view a summary of responses for your form.