Creating surveys with the Excel Web App in Office 365 for education


The free version of Office 365 for education includes web versions of the main Office software – Word, Excel and PowerPoint – in addition to the email, collaboration and communication capabilities included within the online Exchange, SharePoint and Lync services. Of course, that’s great for editing and working on documents, spreadsheets and presentations, and the beauty of the web service is that we can keep updating them for you as we add new features – you don’t have to take on the responsibility for updating software across a pile of machines.

You can see the new features being added in the future to Office 365 through the preview versions. And we’ve just released the preview for Office 365 Enterprise (which is the version that Office 365 for education is based on).

Here’s an idea that you can use them for, that might save you bucket-loads of time.

Using the Excel Web App for surveys and questionnaires

Thanks to  my colleague James Marshall in the UK, there’s a good explanation of how you can easily create online surveys and questionnaires, and get the answers into a neat Excel spreadsheet. It’s great for a range of scenarios, like:

  • A lecturer wanting to get opinion and feedback about a lecture immediately after it finishes.
  • A group of students doing a data collection exercise with their classmates.
  • A senior leader wanting to get feedback from parents about a school event (i.e. sports day, school theatre production)
  • A teacher running a competition.

The beauty of forms in the new Excel Web App is that they can be shared in a few clicks, and accessed on a variety of devices, making it easy for users with laptops, tablet devices, smart phones or pretty much any device with a browser to contribute. And you can make them public, so you can use them for parental surveys etc

Here’s a screenshot from a survey that James published as an example (you can try it out on this link: https://aka.ms/vumdyw)

Excel Web App Survey

 

Learn MoreYou can read James’ post on how to create a survey in the Excel Web App over on his excellent UK Education Cloud Blog (plus loads of other useful Office 365 for education information)

Comments (8)

  1. Fiona Stroud says:

    I've been playing with surveys in the Excel Web App for a little while now but cannot seem to get the spreadsheet data to update when I modify the questions.  Any clues?  Am I doing something wrong or is this a known issue?

  2. Asif says:

    I want my users to send only one unique response to my survey and not fill it again and again. How can I do that?

  3. Jason Matias says:

    I can I set up the form so that it forces the timestamp in another column when I few the spreadsheet? I need to know that time and date that submission came in.

  4. f says:

    hi. is there an option to create dependencies? Let's say I'd like my second question to show only if the answer to question one is "yes"?

  5. Ines says:

    Please can I add an image in the Excel survey?

  6. Dani says:

    How do I edit my questions if I already finished creating the survey?

  7. Miles says:

    Is there anyway to have the student select multiple answers for one question?

    Also, I am trying to save and it says an error has occurred. Any idea why?

  8. Jacque says:

    Hi, I am trying to figure out a way to put my survey on my Microsoft 365 page. Would any one know how to do it? I want the person to input the survey on webpage that I host the information