Get started

Yes, you can.

Create a survey or quiz with multiple people

You can create and share a link to allow others to collaborate on a survey or quiz with you. See share a form to collaborate to learn more.

Make templates from an existing survey or quiz so others can reuse it

You can create and share a link to allow others to reuse surveys or quizzes you have created. See share a form or quiz as a template to learn more.

See create a quiz to learn how to use the math feature in Microsoft Forms.

See add sections to my survey or questionnaire to learn how to organize your questions into multiple pages—or sections—which you can easily rearrange and reorder.

For the question you want to remove, select Delete question (trash can icon). Your question, all of its translated versions, and any response data you've collected for that question will be permanently deleted.

Note: If you create your form in Excel for the web or create your form in OneDrive for work or school, and then delete a question, the question and all of its translated versions will be permanently deleted. If your form and Excel workbook data are in sync, however, any previously collected response data for that question will remain in the workbook.

Depending on your account, you can send out your form and collect responses from everyone, people only within your organization, or specific people or groups within your organization. Learn more about collecting responses.

In Microsoft Forms on the Responses tab, select Open in Excel. Your form responses will open in an Excel workbook. From Excel, you can export or save your form responses as a PDF file. Learn more about how to save or convert your Excel file to PDF.

If you have issues with exporting form responses, learn how to troubleshoot exporting form data to Excel.

When you create a form in OneDrive for work or school, SharePoint Online, Excel for the web, Microsoft Teams, or using the Microsoft Forms web part, you can select Open in Excel to get an Excel workbook (automatically stored on OneDrive for work or school or SharePoint Online) that contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

On occasion, the workbook may not contain the latest data for a number of reasons, such as the accidental deletion of a workbook or file corruption. If this is the case, Forms will provide you with an alert and ask if you want to create a new workbook in order to sync your most recent responses to a new workbook. This new workbook will be stored next to your original workbook on OneDrive for work or school or SharePoint Online. This will ensure your data is up to date. Learn more about how to get missing data.

Note: Workbook sync issues will occur if you require content approval for items in SharePoint. To learn more, go to Require approval of items in a site list or library, and then select the section, Specify that items in a library require approval. Review step #4. If you select Yes for the Require content approval for submitted items? option, your workbooks will not sync.

Yes, you don't have to access your form on https://forms.office.com in order to get live updates.

OneDrive for work or school, SharePoint Online, Excel for the web, Microsoft Teams, or Microsoft Forms web part

When you create a form in OneDrive for work or school, SharePoint Online, Excel for the web, Microsoft Teams, or using the Microsoft Forms web part, you can select Open in Excel to get an Excel workbook (automatically stored on OneDrive for work or school or SharePoint Online) that contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

Microsoft 365 group

When you create a form within your Microsoft 365 group or transfer ownership of a form you create to your Microsoft 365 group, you can directly open the workbook to see real-time, updated responses.

Workflow built with Power Automate

When you create an automated workflow for your form using Power Automate, you can also directly open your workbook to see real-time, updated responses.

If your form sits idle for too long, your real time connection can break. This means you won't see the most recent updates to your form.

Here are a few scenarios you may run into if you don't have real time connection for your form. In most cases, you can refresh your page to get the latest updates.

Co-authoring

When you're collaborating on a form with co-authors, you may get an error, for example, if you try to edit a question that a co-author has already deleted.

Real time response updates

Without real time connection, you won't see response numbers, charts, graphs, and other details update on the Responses tab of your form. Learn more about checking and sharing form results.

Anti-phishing

If you add a question that is detected as phishing, Forms will notify you with an alert. Without real time connection, you won't see alert notifications and may end up sending out a form that throws errors for your respondents. Learn more about Microsoft Forms and proactive phishing prevention.

If you've created a survey, quiz, or poll, you can easily move it to a group so everyone in your group becomes owners of that forms. Learn more.

After you've moved your form to a group, you'll need to change a setting in Outlook so everyone in the group will receive email notifications when form responses come in. Learn more.

Need more help?

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.

×