Microsoft forms and excel workbooks

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 created a form with Forms on the Web, every time you click 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 click Open in Excel, you will 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 created a form in OneDrive for Business, 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 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.

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  > Feedback.

See Also

Create a form with Microsoft Forms

Create a quiz with Microsoft Forms

Check your form results

Check your quiz results