I suggest you ...

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.

994 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ashleigh shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    thinking about it  ·  AdminZhongzhong Li (Admin, Microsoft Forms) responded  · 

    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.

    Regards,
    Microsoft Forms Team

    69 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Terry commented  ·   ·  Flag as inappropriate

        Google has this feature with their Forms - very convenient!!
        Nice to access the Spreadsheets from the online drive.
        Changes to Form data sheet layouts are maintained!

      • Sam Moffatt commented  ·   ·  Flag as inappropriate

        I really want a way of being able to take a form and link it to a new Excel document in O365. I just made a form and now I can't get to the data easily so I have to recreate the form, again, except now starting from the Excel sheet instead. This should really be two way.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I am not satisfied with this response. The main entry point for most users is via Forms, not Excel or One Drive Business, therefore the average user discovers their data isn't updated in real time until it's too late to fix.

        The excel workbook options should be streamlined across all ports of entry into Forms - doesn't make sense to have different data viewing options across the same service.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Microsoft Access would be another option. The forms are so much better in Access than in Excel.

      • Elizabeth commented  ·   ·  Flag as inappropriate

        I am not satisfied with this solution as my initial thought when creating a Form is to open Forms, not Excel. In addition, I do not want to be forced to download the data when our company is aiming at going digital.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This does not work as intended. I have used the excel survey option many times and short of rebuilding it in powerapps with excel as the data source in onedrive I end up with responses in the wrong columns if you open up the excel file in web excel it then modified three columns and placed the information in the next table. I cant reliably consider this excel based option over Microsoft forms. Google has this feature however with IT security restrictions I cannot use them. Thus I am stuck trying to work around limitations I did not have in a free alternative and now going the slower route to rebuilt an extensive form into a powerapp in order to complete the form we need. Please link MS forms to excel for onedrive business at least!

      • Anick commented  ·   ·  Flag as inappropriate

        Same here. I'd really like to be able to connect an existing form to an excel document in OneDrive for Business. The same way it is possible with Forms for Excel. Normal users will open Forms to create a form and will search afterwards to connect it to excel. Not the other way around. In google, a worksheet in google Drive is automaticaly created. It's much more user friendly.

      • James commented  ·   ·  Flag as inappropriate

        I have the same issue in my application of Forms. I need to have the results push through to a live Excel which also needs a column added to acknowledge that the Forms entry has been reviewed. Forms is great, and very powerful, but without a way to better work with the results without manually editing the data, alot of efficiency and value is lost.

      • Anonymous commented  ·   ·  Flag as inappropriate

        When you start the questionnaire by Forms, you allow access as it does SharePoint, without the need to download a spreadsheet with each new update or new response.

      • Judi Stewart commented  ·   ·  Flag as inappropriate

        Would be great if I could get the form responses to sync to the workbook reliably... When I create either an excel workbook in SharePoint Online, and use the create form tool, or create a forms for excel document, the form is created ok, but the workbook doesn't always check in properly and it never gets sync'd with the responses - but, then again, sometimes it's fine and I can't see what's different that might cause the different outcomes :(

      • S commented  ·   ·  Flag as inappropriate

        I have connected a mySQL data source to my excel, Can other users with no access to the mySQL db get updated data everytime they open the excel?

      • Anonymous commented  ·   ·  Flag as inappropriate

        It would be good if we could save the comments on the Excel form within the OneDRIVE and share it with others.
        Generating a dynamic file that is updated with each comment, instead of downloading an Excel file every time.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi,

        Can we generate the response in Excel automatically so that it should get integrated with different system as a source file.

        Regards,
        Madhu

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi,

        Can we generate the Responses in Excel automatically and integrate it to different system as source file.

        Thanks,
        Madhu

      • Beth commented  ·   ·  Flag as inappropriate

        This functionality already exists if you build the form within Excel online - but i can't find a way of moving existing forms over to this system. It would be really nice if there was an option by the download to excel button, to choose as a download or as part of Excel online in real time.
        Then you wouldn't have to re-make entire forms.

      • Anonymous commented  ·   ·  Flag as inappropriate

        回答を確認するたびにエクセルをダウンロードしているのですが、毎度ダウンロードせずともオンラインのエクセルフォームで確認することが出来たらとっても便利です。

      • Perry commented  ·   ·  Flag as inappropriate

        Save the Excel as on online doc in OneDrive For Business, so it can be edited and ... well, because of all the reasons to use OneDrive to begin with. Have a new Excel file each time the form is submitted is no good

      • Anonymous commented  ·   ·  Flag as inappropriate

        Can you link several forms to different spreadsheets. i.e., I want to have one form connect to multiple excel files.

      • Miguel Chumbo commented  ·   ·  Flag as inappropriate

        I created the form on the excel workbook. As I passed the 30MB threshold I cannot use the online excel. I can only use the excel from the PC. However, this excel isn´t getting the answers in real time and doesn´t have connections. Is there any solution?

      ← Previous 1 3 4

      How it works

      • Create a user account if you want to add a new suggestion or vote on existing suggestions.
      • Select one of the feedback forums listed.
      • Check out the ideas others have suggested and vote on your favorites.
      • Be sure to search for your suggestion but if you can’t find something similar enough, you can submit your own.
      • Keep suggestions focused on a single idea per post and limited to 25 words or less.
      • When you post an idea to our forum, others will be able to subscribe to it and make comments.

      Feedback and Knowledge Base

      Standard Disclaimer

      Please note that the Forms Suggestion Box is moderated and is a voluntary participation-based project. If your submission is not a product feature suggestion it may be removed. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos which you do not want to grant a license to Microsoft. Your submission is subject to the UserVoice License Terms.