The Excel workbook generated in Microsoft Forms can be downloaded to your desktop or stored in One. Drive, depending on where you began creating the form.
Navigate to the folder where you want to store your form results ➜ click on New ➜ select Forms for Excel. You will then be asked to name the workbook associated with your form. This workbook will be saved in your chosen folder and will be where all the form submissions will be saved.
Can I use Microsoft forms directly to an existing Excel file?
We know about Microsoft Forms, the Office 365 quiz and polls tool. We know this can be easily exported to Excel. However, if you have an existing Excel file, you can use Forms to import directly into your existing Excel file! I find this as a big deal.
How to create a form from an Excel file?
First create an excel file in sharepoint/one drive, now from within the file, click insert and choose form: Create your form from here, now when you receive responses they will be stored in the same excel file in sharepoint/onedrive: Mar 29 2021 02:54 PM.
How do I edit a form and save it in Excel?
While editing your form, go to the Responses tab, click Open in Excel on your form to download the Excel file. Save it, naming it anything you’d like. I suggest removing the (1-XX) portion of the file name. Save the Excel file somewhere in Share, and point online.
Wherein we can utilize the Microsoft forms to search for a particular set of data from an excel document and present it. Loading I don’t believe that’s possible (havent looked in a couple of months). Forms is purely intake, for surveys, etc.
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 One. Drive for Business.
Where can I Find my response data in Microsoft forms?
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 One. Drive, depending on the starting point of your form or quiz. Where is my Excel workbook stored?, and that depends.