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
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.
This is not an option for educators who want to create a Quiz
"Is there a way that Forms can add data to an existing Excel spreadsheet? Like the way Google Forms does?"
No, we are waiting 2,5 years for it. But you posted in the correct idea.
And you are correct, save data to an data sheet like google do it would be nice. And don't forget to mention that google do it for years in the correct way. The connection between of excel online and forms of MS is simply a design issue. I hope they fix in in the next 5 years. :-)
Simply save forms data to editable excel sheets. Save forms data to a sheet, let the use edit all data and also all columns beside the forms data as the user want. To be able to add custom columns and save custom data beside the form data. Everything... simply as google does it. ;-)
Google must have great developer to achieve all the things years ago. The idea forums of "excel" and "forms" is full of important features google has for a long time.
And all idea forums for "forms", "excel" and "ms flow" have a lot of great suggestions/ideas which are top voted for years. It's a pity.
Is there a way that Forms can add data to an existing Excel spreadsheet? Like the way Google Forms does?
Amy Hill commented
Is there no way to make this work for forms that were created through Forms and not forms for excel? I am REALLY trying to use Office 365 for work instead of my personal google account but at every turn it is just so damn hard and inefficient.
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
"NEED this. Having to open a new file each time is awful. You can't capture new data once you download your responses, nor live edit the data. Google forms does this really well. You can edit the data (add columns, rows, etc.) without messing up the live form responses. It's perfect."
That's right! Please check how it is working in google forms and sheets and do it like this. In Google you can edit the spreadsheet which is connected to the form without problems. And the sheet is still connected to the form.
The idea is from "May 24, 2017". SO WHAT YOU ARE WAITING FOR?!
NEED this. Having to open a new file each time is awful. You can't capture new data once you download your responses, nor live edit the data. Google forms does this really well. You can edit the data (add columns, rows, etc.) without messing up the live form responses. It's perfect.
Does anyone else think this should be just "how it should work"?
Malissa Thomas commented
How about for non-business users? I don't use SharePoint for my small business and having this data in a format I can manipulate is essential. My goal is to have the data linked to power query for reports, graphs and charts. Thank you
I have created several forms using the app that need an excel sheet that is linked to the cloud/onedrive. is there a way to change a regular form to a form for excel without having to rebuild each form? We have created over 4000 forms and a way to do this would be a great help. Perhaps a button to convert to forms for excel.
While using Forms for Excel has "solved" this issue, why can't forms created from forms.microsoft.com through a business account just be created as a Forms for Excel? Have the Excel document live in the OneDrive folder of the person creating the file that then gets shared with anyone who gets the share link that includes collaborating. That would be ideal.
Samuel Mueller commented
This does not work for the survey. You should be able to do this from the Forms App, not the onedrive app?
as of today 2019-04-22, it seems the "Open in Excel" button will open the ONLINE sheet, that allows for customization and additional work, while still maintaning the link with the originating form. From there, you can edit the results workbook or download it to a local excel file if needed.
This works on a form created with the menu "Forms for Excel" inside any OneDrive folder.
This is really some great advancement and maybe even be considered to resolve the request of this topic.
(create a connection between the workbook and the form, and the form to be treated like a data source for the workbook).