✦Template Printable Ideas Insights

How to Create a Survey in Microsoft Office

By

Creating a survey in Microsoft Office can help you gather critical insights and feedback. Whether you're a business looking to understand your customers better or an educator seeking student opinions, this step-by-step guide will walk you through the process using Microsoft Forms, a powerful tool for creating Surveys.

Microsoft Forms is a free online survey tool that allows you to create custom surveys, quizzes, and polls, and then collect responses in real-time. It's integrated with other Microsoft 365 services, making it an excellent choice for businesses and individuals alike. Now, let's dive in and see how you can create your first survey.

Setting Up Your Survey

Before you begin creating your survey, decide on the purpose, audience, and length of your survey. This will help you plan your questions and ensure your survey is as effective as possible.

How to Use Microsoft Forms to Create Professional Surveys
How to Use Microsoft Forms to Create Professional Surveys
Microsoft Support
Microsoft Support
How to Create a Survey Using Microsoft Forms
How to Create a Survey Using Microsoft Forms

Once you've planned, sign in to Microsoft Forms (part of your Microsoft 365 subscription), and click on '+ New Form' to start creating your survey.

Adding Questions

To start your survey, click on 'Untitled form' at the top of the page and type in a title. Then, begin adding questions using the 'Add new' button. Microsoft Forms offers various question types to suit your needs:

Office 365: Use Excel Survey to Gather Information - Teacher Tech with Alice Keeler
Office 365: Use Excel Survey to Gather Information - Teacher Tech with Alice Keeler
How to Close the Survey in Microsoft Forms
How to Close the Survey in Microsoft Forms
How to Create a Student Interest Survey in Microsoft Forms
How to Create a Student Interest Survey in Microsoft Forms
  • Multiple choice
  • Text (ideal for short answers)
  • Paragraph (for longer responses)
  • Rating (for scaled responses)
  • Date
  • Yes/No
  • Approval (for simpler decision-making)

Click on the question type, then add your question and any desired choices. You can also make questions mandatory using the required toggle.

Customizing the Look and Feel

To make your survey visually appealing and on-brand, consider customizing its appearance. Click on the three dots (...) at the top of the page, then select 'Theme.' Here, you can choose a pre-set theme or create your own by changing the font, colors, and background image.

You can also add a watermark, change the background color, and adjust the font size and style under the 'Customize' tab. Make sure your survey's design aligns with your brand or the purpose of your survey.

How to create a survey in Excel, Word, Google, Facebook, & SurveyMonkey
How to create a survey in Excel, Word, Google, Facebook, & SurveyMonkey
How To Create A Basic Form/Survey In Microsoft Word 2010
How To Create A Basic Form/Survey In Microsoft Word 2010
How to Create a Survey With Radio Buttons in Microsoft Word : Office Software Help
How to Create a Survey With Radio Buttons in Microsoft Word : Office Software Help
Surveys in Excel, hosted on the web
Surveys in Excel, hosted on the web
a man standing in front of a microsoft forms sign with his hand out to the camera
a man standing in front of a microsoft forms sign with his hand out to the camera
Client Satisfaction Survey Form Template | Download Sample
Client Satisfaction Survey Form Template | Download Sample

Testing and Distributing Your Survey

With your survey questions and design set, it's time to test and distribute it to your audience.

To test, click on the 'View' or 'Send' buttons at the top of the page. The 'View' button will open your survey in a new tab, allowing you to review your work. The 'Send' button brings up several sharing options, including an email draft, a link to share anywhere, or embedding the survey on a Microsoft Teams channel.

Adding Instructions or Welcome Message

Sometimes, respondents benefit from some context or instructions before starting the survey. To add a welcome message, click on the 'Add new' button and select 'Text.' This question type allows you to provide additional information about the survey, the purpose, or any instructions for completing it.

How to create a survey from SharePoint and OneDrive using Forms for Excel | SharePoint Maven
How to create a survey from SharePoint and OneDrive using Forms for Excel | SharePoint Maven
How to Create a Survey in Excel | Techwalla
How to Create a Survey in Excel | Techwalla
UX Surveys: a quick guide to get the most out of them
UX Surveys: a quick guide to get the most out of them

You can also place this question at the beginning of your survey or add multiple text questions for longer instructions. Remember to make this question non-required, so respondents can skip it and proceed with the survey.

Collecting and Analyzing Responses

Microsoft Forms allows you to view responses in real-time or export them for further analysis. To view responses, click on the 'Responses' tab at the top of the page. Here, you can see individual responses or use the 'Download' button to export them as an Excel file or PDF.

No matter how you analyze your results, Microsoft Forms provides essential insights to help you make informed decisions and improve your offerings, processes, or understanding of your audience.

Creating a survey in Microsoft Office is an effective way to gather valuable insights. Whether you're a seasoned survey creator or just starting, Microsoft Forms offers a user-friendly solution for crafting and distributing surveys. Now get out there and start collecting that data!