Blog Post

Microsoft Forms Blog
3 MIN READ

Microsoft Forms is Enterprise Ready now!

Kathy Liu's avatar
Kathy Liu
Icon for Microsoft rankMicrosoft
Apr 27, 2018
Today, we are excited to announce that Microsoft Forms, a simple app for creating surveys, quizzes, and polls, is generally available to all Office 365 commercial customers. Used by more than 3 milli...
Updated Apr 28, 2018
Version 4.0
FritzMeister's avatar
FritzMeister
Copper Contributor
Apr 18, 2019

The way the forms and quiz data is stored, is still quite confusing. I would like to work with the response data from quizzes without having to export it constantly. The way I currently see it, response data is stored in two ways:

 

  1. If I create a form from within OneDrive, an .XLSX file is created that stores the responses. I can directly reference that sheet if I want to analyze it and the data will be constantly refreshed. From within OneDrive, I can only create a form but not a quiz.
  2. If I create a form/quiz from within the Forms interface, the data is stored in Azure SQL, which is essentially a black box. There is no way that I have found that I can work with the data unless I export it to an Excel file. I would like to create a quiz and be able to analyze the scores in a way that the current response format does not provide.

If this is truly to be considered "enterprise-ready" there has to be a way for the users to get to the data. It is difficult enough for admins to control what's out there, e.g. finding other users' forms, but the fact that I can't even access my own data is very frustrating. I am hopeful someone from Microsoft can chime in and explain how to find the data in Azure, but I am afraid the answer will just be that we aren't allowed to touch it.