Checking your Microsoft Form results

Summary

Microsoft Forms includes rich, real-time analytics that provide 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.

Body

What is this article about?

Microsoft Forms includes rich, real-time analytics that provide 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.

How do I use this technology?

After you create your form, adjust its settings, and share your form with others, it’s time to view the results. There are many ways to access the data you've collected. Below are some of the most common.

 

Viewing results through a web browser

  1. Login to Office 365 (see Getting Started with Microsoft Forms)
  2. From the App Launcher select Forms.

    Office 365 App Launcher with Forms highlighted
     
  3. Under My Forms click the desired form.

    Microsoft Forms My forms landing page
     
  4. Click the Responses button.

    Microsoft Forms form responses button highlighted
     
  5. 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 the from's current status. Next to each question, you'll see the number of responses, and either a list of the most recent responses, or a a chart of the response breakdown, depending upon question type selected.

    Microsoft Forms from responses summary
     
  6. Click View Results.

    Microsoft Forms form responses view individual results
     
  7. You will see individual details for each responder, such as time it took to compelte the form, and the responses made.

    Microsoft Forms form response individual respondent
     
  8. You can access responses by other participants by using any of the following options:
    • Click the down arrow next to the Responder name to jump to the results of another responder.

      Microsoft Forms from responses quick select respondent button
       
    • Click the left or right arrows to toggle through the result details of other participants.

      Microsoft Forms form responses toggle through individual results
       
  9. Additionally, you can view details for each question by clicking the More details link.

    Microsoft Forms form responses question more details button highlighted
     
  10. On the Details page you will see more details for each question such as the name of each responder, if enabled, and their answer for each question.

    Microsoft Forms response individual question more details view

    Tip: You can click the colunn headers to sort the response results.
     
  11. To view the next question click the Next Question button.

    Microsoft Forms response question more details view next question button highlighted

 

Exporting results into Excel

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

  1. Follow steps 1 - 4 above in Viewing results through a web browser to access your form.
  2. Click Open in Excel button on the Responses tab to capture a snapshot of your current response data.

    Microsoft Forms form responses Open in Excel button highlighted

 

Notes:

  • If you've created your form in Forms on the web (as documented in this tutorial), and click Open in Excel, an offline Excel workbook will open that has no relationship, or connection to your form. This means if you get additional responses you'll need to download a new copy.
  • If you've created your from in your 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.
  • 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.

 

 

Print a summary of all responses

You can easily print out a summary of your form questions, number of responses, and colorful charts for responses, where appropriate, that shows a breakdown of that response.

  1. Follow steps 1 - 4 above in Viewing results through a web browser to access your form.
  2. Click the More options (...) button.

    Microsoft Forms form responses More options button highlighted
     
  3. From the drop-down menu click the Print summary button.

    Microsoft Forms from print summary button highlighted
     
  4. Your web browser's print dialog box will appear. Complete printing as normal for your system.

 

Print a summary for an individual responder

 

  1. Follow steps 1 - 6 above in Viewing results through a web browser to access your form.
  2. Find the desired result to print by either clicking the down arrow next to the respondent name, or clicking the right, or left arrow to toggle through the responses.
  3. Click the More options (...) button.

    Microsoft Forms form results individual response more options button highlighted
     
  4. From the drop-down menu click Print response.

    Microsoft Forms form results print response button highlighted
     
  5. Your web browser's print dialog box will appear. Complete printing as normal for your system.

 

Is there any additional information I should know about?

For additional assistance contact the IT Services Technical Support Center via phone at (907) 786-4646, toll-free at (877) 633-3888, email us at uaa.techsupport@alaska.edu, or visit the Services section to open a support ticket.

Details

Details

Article ID: 78
Created
Fri 4/3/20 11:03 AM
Modified
Mon 8/15/22 6:36 PM

Related Articles

Related Articles (11)

Add sections to your Microsoft Form
If you're creating a lengthy form, it's helpful to organize your questions into multiple pages—or sections—which you can easily rearrange and reorder. Sections also help orient your responders consume a long form that has been organized into smaller parts.
Adjusting your Microsoft Form settings
Learn how to customize settings regarding who can fill out the form, when the form is available and not available, options for question randomization, among others.
Conduct a quick poll within Microsoft Teams
With Microsoft Forms quick poll, you can create an instant, real time poll in seconds by using the Forms bot within Microsoft Teams.
Create, edit, and collaborate on a Microsoft Form in Microsoft Teams
In Microsoft Teams, you can add a Forms tab so you can create a new form, or add an existing one, that your entire team can collaborate on.
Creating your first Microsoft Form
This article will walk you through the basics of creating a simple registration form. The techniques you learn here will help you to create more complex forms.
Get Started with Microsoft Forms
With Microsoft Forms, you can create surveys, quizzes, and polls, and easily see results as they come in. When you create a quiz or form, you can invite others to respond to it using any web browser, even on mobile devices. As results are submitted, you can use built-in analytics to evaluate responses. Form data, such as quiz results, can be easily exported to Excel for additional analysis or grading.
Send a Microsoft Form to your audience
With Microsoft Forms, you can send your form or quiz to students, and colleagues in a few different ways, depending upon your needs.
Share a Microsoft Form with others to collaborate
In Microsoft Forms, you can have multiple co-authors help design a form and analyze responses. All co-authors can also view, edit, and delete responses, plus share the form with others by sending them the collaboration link.
Stop sharing a Microsoft Form
In Microsoft Forms, you can have multiple co-authors help design a form and analyze responses. However, in some cases it might be necessary to remove access for others to edit the form, or see the responses. This is simply accomplished by stop sharing the form.
Transfer Ownership of a Microsoft Form
If you've created a survey, quiz, or poll, you can easily move it to a group so everyone in your group becomes owners of that form.
Use Branching in Microsoft Forms
Information about adding branching logic to a Microsoft form so that it changes according to responses to specific questions.