Versions Compared

Old Version 2

changes.mady.by.user Andy R. Andersen

Saved on

compared with

New Version Current

changes.mady.by.user Alexander Yeh [X]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Aura - Title
color#0073a4
textAlignleft
fontSize28
lineHeight28
cloudTextDemo Title
tagh1
fontWeightbold
Forms: Check Your Form Results

Aura - Divider
serializedStyles{"alignment":{"horizontal":"start"},"icon":{"name":"faPaperPlane","color":"#333","size":24},"text":{"color":"#333","fontSize":14,"textAlign":"left","fontWeight":"bold","text":"Aura Divider"},"border":{"top":false,"right":false,"bottom":true,"left":false,"color":"#0073a4","style":"solid","width":2},"size":{}}
typeregular

Info
iconfalse

Microsoft Forms includes rich, real-time analytics that provides 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 summary information for your form

UI Steps
sizesmall
UI Step

After you create your form, adjust its settings, and share your form with others, it’s time to view the results.

UI Step

In Microsoft Forms, open the form for which you want to review the results, and then click the Responses tab.

UI Step

Across the top, you’ll see summary information data about your form, such as number of responses, average time it took for responders to complete your form, and form’s current status.

Expand
titleScreenshot
Image Modified
UI Step

Next to each question, you’ll see the number of responses and a colorful chart of the breakdown of responses.

Check response data for each

...

question 

UI Steps
sizesmall
UI Step

Click View results to see individual details for each responder, such as time it took to complete your form and the option(s) selected. 

Expand
titleScreenshot
Image Modified
UI Step

Click the arrow next to the Respondent

...

name to jump to the results of another responder. You can also click the left and right arrows to toggle through the result details of the other responders.

UI Step

Click the ellipses button (...) to delete all responses for a particular individual or print all responses for a particular individual. 

Expand
titleScreenshot
Image Modified
UI Step

Learn more about printing forms. 

...

Export form results and open in

...

Excel 

UI Steps
sizesmall
UI Step

You can easily view all 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.

...

UI Step

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.

UI Step

If you've created your form in OneDrive for Business and click Open in Excel, your Excel workbook is automatically stored in OneDrive for Business and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

UI Step

If you've created your form in Excel Online and click Open in Excel, your Excel workbook is automatically stored in OneDrive for Business and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

UI Step

Troubleshoot data exporting

If you're experiencing a download error, please see how to troubleshoot exporting form data to Excel.

UI Step

Analyze form results in Excel

Each question in your form is a column and each response becomes a row in the Excel workbook. The first four columns display the start time and completion times for each response, and the name and email address for each responder. The subsequent columns display that responder's selections.

Expand
title

...

screenshot

 Image Modified

Notes: 

  • Any changes you make to the form data in Excel won’t modify the content of the response table.
  • Names and email addresses of anonymous students won’t be displayed if you allow your form to accept anonymous responses.

...

View details for each question

UI Steps
sizesmall
UI Step

Click the Details link to see more details for each question. On the details view, you can see the name of each responder and his or her answers for each question.

Tip:

...

Click the column headers to sort the response results. 

Expand
titleScreenshot
Image Modified
HTML
<style type="text/css">
#title-text { display: none;}
</style>