Check and share your form results

Tip: Create a survey, quiz, or poll with Microsoft Forms. Want to capture and analyze enterprise customer feedback? 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 click the Responses tab.

Summary results for a survey

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.

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 results button on Responses tab of a form in Microsoft Forms

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

View specific results, such as name and time to complete, per responder

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

Open Excel button on the Reponses tab in a form in Microsoft Forms

Notes: 

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

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

  1. Select the Responses tab.

  2. Click More options More options button .

  3. Select Create a summary link.

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

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.

See Also

Troubleshoot exporting form data to Excel

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×