Skip to main content

How can I save Forms results in an excel spreadsheet?

Published: 3 February 2022 Last updated: 22 February 2022

IT Service

Back to FAQs homepage | Back to / / category


0
(0)

Forms for Excel

When you create a quiz, poll or survey using Microsoft Forms your results are stored in an Excel workbook. Within the results section of your Form you will see an ‘Open in Excel’ option. By default, this will download a copy of the results to your downloads folder. For easier long-term management of your results, you may wish to create a linked Excel workbook stored in your SharePoint site.


Create a linked Form

The easiest way to create a linked Form is to create it from your SharePoint site.

  1. Navigate to the SharePoint site you want to host the results on
  2. Select New
  3. Click on Forms for Excel from the menu
  4. Give the Form a name
  5. The Forms web app will open in a new tab, populate your Form with some questions

    As you create your Form, the excel spreadsheet will automatically populate each column with the question text. Once you’ve added all of your questions, share your Form with the desired recipients.

When end users complete your Form your results will be stored in the linked Excel workbook stored on your SharePoint site.

Sync to a new workbook

Within the results section of your Form, if you select the ellipsis … then choose ‘Sync responses to a new workbook’ this will break the link from the existing workbook and create a new one.


Further information:

https://support.microsoft.com/en-us/office/microsoft-forms-and-excel-workbooks-c61b5751-8128-4434-abb0-246f5e2a3b01

How useful was this FAQ?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this FAQ.

We are sorry that this FAQ was not useful for you.

Your feedback helps us improve our content.

Please let us know what was wrong.


Back to top