Wednesday, 6 February 2013

Surveys in Excel with SharePoint 2013

Did you know, that you can create a survey in Excel right from SharePoint?
To be able to do this, you need to be able to create and edit Office documents in browser, so you either are using Office 365, or have Office Web Apps Server installed.

Go to document library, and when creating new document, choose Excel survey
Give it a name
Now, Excel Web App will open and display wizard.

When you add question, you have following answer types:
  • Text (one line)
  • Paragraph of text
  • Number
  • Date (unfortunately, no date picker, only textbox)
  • Time
  • Boolean value (yes/no)
  • Choice

You add as many questions you like, drag them around and arrange to your wish. When you're ready, click Share survey, and you will get a link that you can send to your frineds or collegues.

The same can be also done using consumer SkyDrive (skydrive.live.com).