How can I save Forms results in an excel spreadsheet?
Published: 3 February 2022 Last updated: 23 July 2024- FAQ Category:
- Microsoft 365
- Microsoft Forms
- SharePoint
Back to FAQs homepage | Back to Microsoft 365 / Microsoft Forms / SharePoint category
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.
- Navigate to the SharePoint site you want to host the results on
- Select New
- Click on Forms for Excel from the menu
- Give the Form a name
- 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.