With the cloud technology, you can create a survey with Excel OnLine and share it to your audience easily.
Survey made with Excel
Click on the following picture to visualize an exemple of survey made with Excel Online
Create a survey
There is 2 ways to create a survey. But, you must open your personal OneDrive or SharePoint account. Not your Excel application ⚠⚠⚠
Open Excel Online
Once you are on your OneDrive portal, click on New > Excel workbook
Then, click on the menu Insert > Survey > New Survey
Create your survey directly from the portal
Also, you can directly create a Survey from the Home page of your OneDrive
Start your survey
A new window shows you the 3 states of the survey
- Create a survey
- Share with your audience
- View the result of the answers
Here, you select Create and you click on Got it
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.
And also a description
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
The Microsoft survey cover all the type of questions (unique choice, multi-choice, yes/no, ...)
When you click on the Response Type, you can choice between
- Paragraph Text
- Yes / No
In function of your selection, the options for the question are different.
For the option "Choice", you write the different answers that people can select.
Then simply click on the "Add a new question" to add this question to your survey.
Reorder your questions
You can easily change the orders of your questions with a drag and drop action
View the result of your creation
Add more questions to your survey and click on Save an View to visualize how the survey will be display for your audience.
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:
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, reload this page to see your answer display in the next workbook.