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
I have created quite a few of my forms already (which have responses), is there a way that i can change my datasource (which MS-Form excel is looking at) to my current form? I dont want to create a new form and lose all my data.
Is this only a option for business users? Like other comments I use google forms for no other reason than it links straight into google sheets. I would love to use forms in my work but without proving the concept and learning the system it can't be done. It seems counter intuitive to limit and push customers to an alternative system when your system is better and cleaner in every way except integration.
I want to vote for this 1000 times!!!! I am a heavy form users and have used both microsoft and google forms. Google forms allows you to have an attached cloud-based spreadsheet (and even allow you to have the data from two separate forms feeding into one spreadsheet) which for me is a huge advantage over microsoft forms. It means that for long duration forms I can go straight to the spreadsheet to view results rather than having to go to the form and download a separate spreadsheet each time. It also means that I can add additional sheet to the spreadsheet in order to process/manipulate the data and this can be done whilst I am still collating results all in one single spreadsheet.
Michael Hawker commented
Would be cool to see connection to Power BI
Jeff Koertzen commented
Please see my suggestion to integrate with the new Microsoft Lists product. This would solve a LOT of the problems noted here.
Brian Connelly commented
This could be handled with Power Automate. I have created surveys and feed the responses back to Excel Online which I use as a datasource for Power BI.
Dion V commented
Somehow MS managed to break the Forms functionality. I've been showing staff how to use Forms, and one of the key features was that the Excel file *was* being created even when using FORMS to create the form.
Suddenly, this week, creating a form from within Forms itself does not do this anymore.
Then I read that the Excel file is only created if the form is created from within OneDrive or Excel Online. SERIOUSLY???
Any method of creating a form should do that same thing: Create the Excel storage file. Period.
We need to read this file into PowerBI for reporting and can not be downloading the Excel file every time we need new data in PowerBI.
Omar Ghannam commented
Can we get an option to link previously created forms to excel sheets the way it works when you click "Forms for Excel" in OneDrive as suggested by Zhongzhong Li above?
"Forms to Excel" should be also available for a Personal/Home subscription of O365. It would be very helpfull to collaborate with friends and family
Patrick O'Toole commented
As far as I can tell, editing the workbook (e.g. adding responses from another system or older version of the form) does not cause the results dashboard to update. This means that responses are only copied into an Excel workbook as rows, right?
Peter Brink commented
I found out just testing this was an issue.
WORKAROUND, go to onedrive, create a new excel file (or an existing one), insert -> forms -> new form.
If you go to forms.microsoft.com, create a form and get responses you can only download.
If you go to excel online, then create a form the responses will show there.
WHAT I WANT:
If you linked a form to excel online when you initially created the form you can open in excel. Right above that you can click the 3 dots and can click "Sync all responses to new workbook". If you did not create the form via excel initially you do not have this option.
All I want is to have that option on a form that was created initially in forms. Let me select where to save the file in my onedrive. This would also be good for the current option so i can move it to somewhere else.
A created file available in OneDrive and dynamically updated with results should be a basic feature, not some worked on extra and accessed via a different route!
This functionality is a major omission in this offering.
Loads of functionality missing that could be added and still way off G forms so some work yet to do.
A better implementation of long existing html forms elements would be a good place to start.
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.