Connect results to Excel as a data source rather than opening a new workbook each time
The form is great in terms of collecting responses. That said, if you need to view all the data at once, you need to open the form results in Excel. If you do that, it appears to open a separate result each time. There is no way to edit the results workbook. For example, I want to add a column to the results where I can keep track of whether or not I have contacted the person since they have filled out the form. If I add that column to the table, it will be gone when I next click "Open in Excel" to get the latest data. It would be great if it creates a connection to the workbook and is treated like a data source for the workbook.
Hi Forms users,
Thanks for using Microsoft Forms and providing feedback.
We just enabled a new feature “Forms for Excel” for all Microsoft Forms customers. When you create Forms for Excel in your OneDrive for Business / modern SharePoint team sites, you will get an Excel workbook at the same time. All the responses data will show up in your Excel workbook in real time.
You could get more detail from – https://aka.ms/formsforexcel
Please be free to leave comments if you have any question.
Microsoft Forms Team
This feature does not give you an option to create a quiz. Perhaps all forms created should have all the functionality so you don't have to change between a survey or quiz.
Quentin Poncelet commented
Hello the Community of Forms !
What a frustratin when I tried this cool 'Forms' feature in my O365 environment ...
My wish was to get an online Excel where I can find all the answers, linked to the Forms I have created and sent to all the people to whom I asked questions.
But ... When I click on "Open in Excel" button, it DOWLOAD AN EXCEL FILE ... :'(
After some searches, I found that to get this great feature, I need to FIRST create an Excel Online, AND THEN add a Forms.
So great ! When i click on "Open in Excel", it open the Online Excel file.
Frustration is coming...
I can't switch from the first mode 'download' to the second 'online' one ...
But the link is already sent to hundred of poeple ... :'(
And both Forms are really working exactly the same (even if I've created them in 2 different way), except this feature of collecting data, so that I can 'play' with them as I wish in Excel ...
Hope this can be solved in the meantime, within the configuration panel ?
PS1 : don't hesitate to ask questions if my explanations are not clear - sorry for my English, I am a Belgian guy ;-)
PS2 : I've attached a visual explanation ; because images are sometime better than words to explain ! :-)
Since it's now possible to have "Forms for Excel", could it be possible to add the file name and location (on one drive) to the settings in Forms so that "Forms for Excel" is just "Forms" with a specified saved location.
how do i change the value of the cells in my spreadsheet to number, rather than the default of a text value so i an total things in the spreadsheet
I have added my Excel forms to my TEAM in Microsoft Teams, however I would like to be able to add the LIVE spreadhseet (of the responses to the forms) to my management TEAM (within Microsoft Teams) as well and can not figure it out. If I upload the file the spreadsheet does not update automatically within Microsoft Teams. I need them to be able to view the worksheet and not the summary
Deb W commented
Option to send it to a list...so I can add a column and manage my results (actions etc)
Joel Myers commented
It seems pretty obvious that people would need this. Any updated
Any reason "Forms for Excel" is only available on individual level and not group level? I'd like to be able to make forms and their excel workbooks available for several people in my team. However, when I create a group form, the excel workbook is automatically created in the main "Documents" folder in sharepoint, with no apparent fix to sort this into a specificly chosen folder within our structure.
It's causing major clutter.
As soon as we try and move the workbook to a different folder, the link with the form is lost and Forms automatically creates a new workbook for new responses.
I have built and published a number of eLearning content for my organization that includes links to quizzes. I was hoping I could link any quiz I made to the same Excel file, but there doesn't appear to be an option for this.
I can create an Excel file and create a form for it, but it doesn't give you the option to create a quiz. Even if the option was there, I would not be able to link multiple Quizzes to the same Excel file.
So if I wanted to create a dashboard of all the quiz results using data from all the quizzes from separate sheets in one Excel file, I can't.
Google does this....(YOU NEED TO PROVIDE AN OPTION TO LINK MULTIPLE QUIZZES OR FORMS TO THE SAME EXCEL FILE) that way data from multiple places/forms/quizzes can be compiled and reviewed.
If there is already a solution for this, where is it???
In the results, can we choose only to see results from specific question(s) from the form? Also, can we have results from multiple forms combined in one spreadsheet.
Rick Hyne commented
I am in Teams.
I create an employment application form.
The excel book is stored on SharePoint under the Teams channel.
I don't want to destroy the data in that book, so I create another book and pull from the first book.
All is good as I can refresh the second book. I can pull subset data and put it in a separate sheet.
On the first book the questions were part of the header row. Now they are gone and the header is named column 1, column 2.
When reviewing the entries from the form and selecting delete entry, it does not delete from the excel book. .
Dan Taylor commented
How do I save the excel file without the data source features attached to it? I'm importing the excel file into Cognos for reporting purposes and it appears that Cognos doesn't like the form feature within the excel file. Please help? Hope that made sense.
Why not SaveAs a Master the first downloaded workbook, then just transfer new information into it manually when you download new information. Added columns remain.
Rick Kane commented
The new feature is really not useful for existing forms. There should be an option, regardless of where the starting point for the form was, to choose a location for responses to be output to excel. This is basic basic stuff here and REALLY limits the usefulness of Forms.
and what about new feature "Quiz for Excel" ? "Forms for Excel" doesn't include note and feedback because it generates a survey only. we can't choose between survey and quiz. I would like to get en Excel workbook with all the responses data of a quizz in real time + 1 vote for me
There s NO solution today to host Quiz for excel directly into Sharepoint as far as i searched for
Natalie Crosby commented
Forms for Excel WAS a feature and now seems to have disappeared. Can we expect an update to Forms?
Is there a way to have two forms feeding into one excel file?
Raul Eduardo Cabra commented
Please return the function, this seems to me to be gross, I don't want to have to go to google forms to do the work I've been doing with excel survey.
This is a critical feature. If you really want us to move to the cloud, you have to give us the tools in a cloud way. Downloading an new copy of a Excel sheet each time we want to look at the data completely defeats the point of cloud-based collaboration. There is a work around for normal Forms, but teachers creating quizzes have no option to do this.
Piyush Soni commented
I mean, who would have thought MS would do such a STUPID implementation! So, turns out you create a form and get the data, and a SINGLE change you make to the Excel sheet, the form looses its connection to the sheet and stores data at SOME UNKNOWN LOCATION that you can't find! Man, you have the data table right in front of you ! Why don't you just use that as your single data source? Secondly, if I just want to add a single column (Status - Resolved/WONTFIX etc.) to the excel sheet for my own reference, it still loses the form<->excel connection. Don't know how Google just gets it right the first time every time.