Earlier we had seen how OneDrive had introduced the Recycle Bin feature and how Microsoft had then said that the Excel Survey Feature would soon be made available too. And today, Microsoft announced the availability of Excel Surveys on OneDrive. The Excel survey feature lets you create online surveys and analyze results using the free Excel Web App or Excel on your desktop. This feature was one of the top requests for the SkyDrive team.
Create Excel Survey
It is very easy to create Excel Surveys. Just click on Create button and you'll be provided with the new Excel Survey option:
After naming the Survey, you can start adding the Questions.
Once you finish adding the questions, you can Share it or Save it. After creating the survey, you can decide on its properties like, sharing, viewing, and editing.
The recipient who receives the Survey will be seeing it like this. He can then fill the survey and click on Submit.
On your OneDrive, you can see the Survey along with your other files. Here's how it looks in the list view:
You can shorten the URL and send the Survey to anyone that you want to collect information from.
As the creator of the survey, you can view all the results in Excel and you can even embed the results in a webpage, or create and share a chart or pivot table of the results. This is one of the very useful features added, and which can be used in many scenarios.