«

»

Create an online survey with Excel

Since it is possible to use Excel from a web browser, new special features are available with Excel Online. This is particularly the case for creating, posting and collecting the results of a questionnaire. And not only is it very easy to implement a surver but it is free.

Click on this link to see the online survey http://1drv.ms/1JA40AE

Connection to the cloud

To create your survey, you must connect to the cloud. Like that, you can create, send and administrate your survey on the same place.

From any web browser (Internet Explorer, Chrome, Firefox ...), log on at your OneDrive account with your Microsoft Account (hotmail, outlook or msn)

 

By connecting to the Office interface, you also view all the other free apps that are available such Word, OneNotes, Power Point for free (yay, it rocks!)

On the bottom-left of the page, you can select the language that you want and then you log in (upper right) with your Microsoft Account (hotmail, outlook or msn)

After identification, your name appears on the upper-right of page. Then you just have to click on the Excel icon to launch the application in your browser (pretty easy)

Then, your browser displays the start page of Excel 2013 ... as you can see, it's free

Create a survey

To create a poll in Excel Online, you simply open a new blank file and click the icon Survey.

Survey_5Survey_6Then you choose the option "New survey"

 

 

 

You will then display a new window where you enter a title for your questionnaire, a description, and of course a text box to create your questions.

When you select the "Question" box, a new window will appear allowing you to create any type of question for a questionnaire.

Survey_7Survey_8When you select the zone response type, a drop down list offers many choices. In a questionnaire, it is mainly the Yes / No and choice that are most frequently used.

 

 

 

 

 

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

Here is the result after adding 3 more questions

Survey_9

Share the survey

The advantage to an online survey is to be able to share it easily to your contacts.

Once you have completed your questionnaire, simply click on Share Survey and click on the button Get link, to display the link to copy into an email or insert into a site.

Survey_10a

You can also click on the Shorten link to get a shorter address.

If you want to see the result of the division of this questionnaire, simply click the link http://1drv.ms/1JA40AE

Please, answer these few questions and you will see the result in the next workbook.

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.

Survey_11

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 articles


Have a look at these other articles that could help you in your work

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. Required fields are marked *