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'm having the same problem as Kevin below. Why am I unable to link my Form to an online Excel sheet?
Is this available for government customers yet? This isn't an option for me.
There needs to be a way that you can sync Quiz results in Excel like your able to with a normal form. I am looking to track results using an Excel File.
David C commented
The live excel feature of "Forms for Excel" is awesome. However, I have a few gripes with it:
1) Most of my users in the org create a new Form, and then want to point it to a live excel form (I have the unfortunate task of telling them they have to scrap the work they have already done and start new if they want a live excel, rather than using the default 'export to excel' to get results). It would be great if you could convert the way Form data is stored from the default where you have to export the excel, and change it to a live excel form AFTER the form is actually created.
2) I can't create a "Forms for Excel" in a private channel. A lot of times I want the submissions of the form to be secured (e.g. stored in a private channel), but I still want the form and discussion about it associated with a public team. Right now private channels don't support "Forms for Excel" as far as I can tell.
Thanks, and keep up the great work in improving the product.
I mirror this sentiment. The "Forms for Excel" still is a bit clunky. It also tends to break as soon as users add an additional column, delete rows, etc. MS forms feels overengineered and doesn't give us the flexibility needed. Google forms is much simpler and allows you to use whatever spreadsheet you want and you can make changes to the spreadsheet afterwards.
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.