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 andselectMore form settings > Feedback.
By integrating Microsoft Forms with Excel, you can efficiently collect and manage data, making the process of gathering information streamlined and organized.
Open any existing form or quiz you are currently using to gather data. To automatically create an Excel worksheet and save it to OneDrive, select Responses > Open results in Excel.
A worksheet form is not the same thing as an Excel template. A template is a pre-formatted file that can get you started creating a workbook that looks the way you want. A form contains controls, such as boxes or dropdown lists, that can make it easier for people who use your worksheet to enter or edit data.
Can Microsoft Forms do calculations? Microsoft forms does not support the calculator feature; nevertheless, the good news is that automatic calculation is now easier than ever with Clappia.
Microsoft Excel can automatically generate a built-in data form for your range or table. The data form displays all column headers as labels in a single dialog box. Each label has an adjacent blank text box in which you can enter data for each column, up to a maximum of 32 columns.
Introduction: My name is Dr. Pierre Goyette, I am a enchanting, powerful, jolly, rich, graceful, colorful, zany person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.