Check and Share Your Form Results

Export Microsoft Form results to Microsoft Excel for more in-depth analysis and delete or print a summary of responses.

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 View Responses.
   
    
2. 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.

Back to Top

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.

Back to Top

Check Response Data for Each Question

1. Select Check individual results to see 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.
   

Back to Top

View Form Results in an Excel Workbook

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

1. When viewing responses, select More options to capture a snapshot of your current response data in a workbook. Select either Open in Excel Desktop or download a copy.
   
    
   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 Check individual results on the View 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.

Back to Top

Share Results with Others

1. Select the View responses
2. Select More options ( ... )  > Share 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.

Back to Top