This article is for faculty, staff, and students who want to create a form, quiz, or survey on the web.
With Microsoft Forms, anyone can create surveys, quizzes, and polls, invite others to respond to it using almost any web browser or mobile device, see real-time results as they're submitted, use built-in analytics to evaluate responses, and export results to Excel for additional analysis or grading.
Combining Forms with Excel
If you would like to view the results in real-time inside an Excel spreadsheet:
Visit s.uconn.edu/onedrive and sign in with your email address and NetID password.
Click on My Files in the left-hand menu and find the folder that you would like the spreadsheet to reside in.
Click on Add new in the top-left corner to add a Forms for Excel.
Continue down this page to the “Question types” section.
Create Form in existing Excel spreadsheet
To add a Form to an existing spreadsheet, you must open the spreadsheet in the webapp version of Excel (website).
Visit s.uconn.edu/onedrive and sign in with your email address and NetID password.
Click on My files in the left-hand menu, then locate and open the spreadsheet.
In the top ribbon, click on Insert and choose Forms then New Form.
Creating a Form without Excel
A Form can be created without the real-time updates to an excel spreadsheet. Without this connection, the results of the Form may still be downloaded into a new spreadsheet each time you wish to view the results in Excel.
Go to forms.office.com and sign in with your email address and NetID password.
Click New Form to begin.
Click Untitled Form and enter a name for the form. If desired, a description can be added as well.
Creating a Form in OneNote
A Form can be added to an existing page in OneNote.
Visit onenote.office.com and open the Notebook/note you would like to add the Form to.
Click on Insert and then Forms.
Continue to Create a Form with OneNote Online to learn how to add questions to this form.