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
Daniel Mustoe commented
This would be really handy for collaboration and the spreadsheet to be 'live'.
I'd like to be able to add notes alongside responses e.g. done or needs more work etc.
Also I'd like others (in my team) to be able to access and add to the responses sheet.
Clint Hamada commented
This is similar to what already happens in Google Forms. In addition to the summary responses my team can get from the Forms interface, the ability to access realtime and shareable updates of the raw data would be great.
Julia Legg commented
This needs to be a live version instead of just uploading it to OneDrive, it needs to sync and be connected.
Jose Barzaga commented
Allow the spreadsheet of responses to open on an Excel Online spreadsheet so that collaborators on the form can add notes to the spreadsheet. Right now it only opens on the Excel desktop app and you cannot see the notes that are being added. It's like having multiple files all over the place. It would be great that the same spreadsheet opens for all to see and use.
Aaron Rosengarn commented
John King commented
Submit to SharePoint List also please!
The problem with OneDrive in a business is that it associates the data with a specific person.
As users move on, their OneDrive is usually blindly decommissioned. The user forgets they set up an ongoing form, which is usually associated with a process belonging to whatever department they were working for.
John Mathieson commented
Having the Excel file saved to one drive will foster greater usage of forms. That we have to copy and paste to a seperate file if we want to add any notes, corrections or document the progress is cumbersome. We know the data is stored in a file of up to 5000 entries. Would be good if we could access the master file and not just the downloaded file. This would allow us to filter on ones where we have already responded or made corrections (The filter)
Excel surveys is live...but misses the mark with fewer survey options.
Josh Nicholls commented
I definitely feel the "live data" is crucial. Especially for on going forms where users are entering data and you want an up to date view of responses.
Miguel Guhlin commented
NOT TRUE RIGHT NOW:
1) People fill out an MS Form to submit their trouble ticket.
2) Technicians view the Excel version of the spreadsheet, using the Edit link provided for the Excel sheet. They update each job as they finish it.
3) People who requested help use the View link to the Excel sheet to see the status of their request.
WHY IT IS NOT TRUE
The problem with Forms right now is the excel file isn't live, so you cant share with others or embed a live version (like is created in Google Drive). You can only download the results for snapshot-in-time viewing. So to make your situation true, I would think there would need to be an additional spreadsheet that is shared and embedded. That would require someone to manually download the Forms spreadsheet and add the info to the shared sheet. Lots of extra steps.
I am hoping that there will eventually be live results that live in a spreadsheet because that is the number one request I hear!
It would be really helpful to be able to save and work wtih the responses in a live OneDrive document rather than downloading a file. For example, I use this for tracking textbook requests. It would be great for me to have a life OneDrive file that all results feed into where I can add columns on the back end (such as "status" or "date request filled" and fill them in). Currently I have to download and then copy/paste data into a separate standalone spreadsheet to keep track of it.
When exporting the result in a Excel spreadsheet, it should be cloud base and not a downloaded file. I should be able to see in real time when someone submits the form. More than one person of my choosing should be able to see the Excel Spreadsheet in real time. Google Forms is a great example of what this should be as a minimum.
I'd like to be able to save forms in a folder structure within onedrive - with their associated spreadsheets
Also - I want to be able to share my form with a colleague - so they can rename and save their own copy and use..... giving them a link only allows them to answer my form - not to have a useful copy of it. E.g. one teacher writes a pretest - three teachers all want to use it with their classes - we don't want all 3 classes of results just being in a spreadsheet only the maker of the form accesses.....