Office
Sign in

Microsoft Forms and Excel workbooks

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

Got feedback on Microsoft Forms?

We'd love to hear from you! Please visit the Microsoft Forms User Voice site to provide suggestions and vote on ideas others have already submitted.

See Also

Create a form with Microsoft Forms

Create a quiz with Microsoft Forms

Check your form results

Check your quiz results

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×