Tip: Learn more about Microsoft Forms or get started right away and create a survey, quiz, or poll. Want more advanced branding, question types, and data analysis? Try Dynamics 365 Customer Voice.
In Microsoft Forms, you can easily view all of the response data for your form or quiz in Microsoft Excel. An Excel workbook with your response data will be stored in OneDrive or SharePoint Online, depending on the starting point of your form or quiz.
Where is my Excel workbook stored?
That depends. What was your starting point when you created the form?
If you create a form with Forms on the Web as a personal form and select Open in Excel (in the Responses tab), Excel for the web will open with a workbook automatically saved to OneDrive for work or school if it is a personal form, or in SharePoint Online if it is a group form. Response data - such as annotations, formulas, and functions - syncs with your workbook and you'll see the latest updates each time you click Open in Excel or re-open the workbook.
If you create a form in OneDrive for work or school and select Open in Excel (in the Responses tab), Excel for the web will open with a workbook automatically saved to OneDrive for work or school. Response data - such as annotations, formulas, and functions - syncs with your workbook and you'll see the latest updates each time you click Open in Excel or re-open the workbook.
If you created a form in Excel Online, every time you click Open in Excel (in the Responses tab), Excel for the web will open with a workbook automatically saved to OneDrive for work or school or in SharePoint Online, depending on where you created the workbook. Response data - such as annotations, formulas, and functions - syncs with your workbook and you'll see the latest updates each time you click Open in Excel or re-open the workbook.
Feedback for Microsoft Forms
We want to hear from you! To send feedback about Microsoft Forms, go to the upper right corner of your form and select More form settings
See Also
Create a form with Microsoft Forms
