Tip: Create a survey, quiz, or poll with Microsoft Forms. Want to create an advanced survey? Try Microsoft Forms Pro.
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. Create a form with Microsoft Forms. Sign in to Office 365 with your school or work credentials. Open the Excel workbook in which you want to insert a form. Click Insert Forms New Form to begin creating your form. Note: To enable the Forms button, make sure your Excel workbook is stored in. If you are looking for a free Microsoft Excel® templates, below you will find a comprehensive list of excel spreadsheet templates and calculators created by Spreadsheet123.com. Vast majority of spreadsheet templates on this page are created with purpose to become a solution for practically any occasion in your life, whether your are moving home or placing kids to college, getting ready for your retirement. Excel Get time-saving Excel spreadsheet templates for budgets, inventory, schedules, Gantt charts, timelines, and more. Hundreds of free online templates help you track what’s most important to you. Opt To Use Excel. Microsoft Excel is a spreadsheet software, that is part of Microsoft Office, you can use for storing, organizing, and manipulating data. Excel allows you to create graphical representations of your data and information. It can visualize data in the form of bar charts, column charts, and graphs.
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.
![Excel Excel](/uploads/1/2/4/9/124902563/423089584.png)
Where is my Excel workbook stored?
That depends. What was your starting point when you created the form?
Forms.office.com
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.
OneDrive for Business
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.
Microsoft Office Excel Form Templates
Excel for the web
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.
![Microsoft excel forms templates printable Microsoft excel forms templates printable](/uploads/1/2/4/9/124902563/630765955.jpg)
Got feedback on Microsoft Forms?
We'd love to hear from you! Please visit the Microsoft Forms UserVoice site to provide suggestions and vote on ideas others have already submitted.