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 downloaded to your desktop or stored in OneDrive, 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 and select Open in Excel (in the Responses tab), an offline, standalone workbook will be downloaded to Excel desktop. You can save this workbook to any location. Each time you select Open in Excel, you'll get a new workbook, which contains the latest data.
Note: Any changes - such as annotations, formulas, and functions - made to a workbook stay only in that 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 webwill open with a workbook automatically saved to OneDrive for Business. 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
