Tip:  Learn more about Microsoft Forms or get started right away and create a survey, quiz, or poll. Want more advanced branding, question types, and data analysis? Try Dynamics 365 Customer Voice.

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 select the Responses tab.

View responses to your Forms

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: If there are intelligence-based data insights determined for a question, you'll see the Insights icon next to it. 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.

MS_Forms_FormResults_Details-generic

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.

View Individual responses to your Forms

Use the left and right arrows to toggle through the result details of other responses.

Navigate individual responses with the arrows

You can also use the drop down list to jump to the results of a specific respondent.

View a drop down list of respondents in Microsoft Forms

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.

Enter a specific number in the respondent search box to see the details of that individual's response in Microsoft Forms

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 More options button 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.

Print response option in Microsoft Forms

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. Select Open in Excel on the Responses tab to capture a snapshot of your current response data in a workbook.

Open your Form results in Excel

Notes: 

  • If you've created your form in Microsoft Forms and select 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 and select 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 for the web and select 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.

Excel workbook displaying survey results

Notes: 

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

  • 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

  1. Select the Responses tab.

  2. Select More options More options button  > 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.

Notes: 

  • 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 More options button > 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.

Feedback for Microsoft Forms

We want to hear from you! To send feedback about Microsoft Forms, go to the upper right corner of your form and select More form settings  More options button > Feedback.

See Also

Gain more insights about your survey data

How to ensure your form and workbook are in sync

Troubleshoot exporting form data to Excel

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×