Create an online survey with Excel

With the cloud technology, you can create a survey with Excel OnLine and share it to your audience.

Survey made with Excel

Click on the following picture to visualize an exemple of survey made with Excel Online

 

 

 

 

 

 

Open Excel Online

To create a survey, you must open a new workbook with Excel Online. To do that, you must be connected to your personal OneDrive or SharePoint.

Then you click on New > Excel workbook

Create a survey

To create your survey, activate the menu Insert > Insert > New Survey

A new window shows you the 3 states of the survey

  • Create
  • Share with your audience
  • View the result of the answers

You click on Got it and you will insert your question

Insert your questions

First your have to enter a title to your survey and give a description. It's not compulsory but it's better.

Then you select the box "Enter your first question here" and click on the gear. A new dialog box appears with many options for the questions.

Type of questions

When you click on the Response Type, you can choice between

  • Text
  • Paragraph Text
  • Number
  • Date
  • Time
  • Yes / No
  • Choice

In function of your selection, the options for the question are different. Here, for the option "Choice" we have filled the different answer for the question.

Then simply click on the "Add a new question" to enrich your questionnaire

Reorder your questions

You can easily change the orders of your questions with a drag and drop

View the result of your creation

Now, click on Save an View to visualize how the survey will be distribute

And you see this screen

Share the survey

Now, once you click on Share Survey, you have a dialog box with a link

In this example, the link is:

https://1drv.ms/xs/s!AiJROV_khZNKhooa5dH4lXtELGkZXA?wdFormId=%7B719138AA%2D602C%2D404D%2DA715%2D2C3A9B9D751E%7D

 

View the results

Of course, for you at the end, what you want is to see the answers.

Return to your OneDrive and open the Documents folder. There you will find among your files, an Excel workbook with the attribute Survey.

 

Just open the file to see the answers to your questions or embedded it in a webpage. If you have answer to the survey, relaod this page to see your answer display in the next workbook.

Related posts


Permanent link to this article: https://www.excel-exercise.com/create-an-online-survey-with-excel/


Leave a Reply

Your email address will not be published.