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.

652 votes
Sign in
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    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  ·  Zhongzhong Li 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.

    Microsoft Forms Team


    Sign in
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      • Alison Trinidad commented  ·   ·  Flag as inappropriate

        I've created a "Form for Excel" on a Sharepoint drive, but now am unable to connect the form as a trigger on Microsoft Flow. Only Forms created in Forms (not Excel) are showing up in the Flow drop-down. I would like to create an email notification and approval workflow for every response submitted through the Form. Possible?

      • Anonymous commented  ·   ·  Flag as inappropriate

        I have the same issue as @Erik Olsson, I've published the form and advertised it, down want to retract it, can we link form back to onedrive "form for excel"?>?

      • Amber commented  ·   ·  Flag as inappropriate

        I have a form created in my OneDrive for Business account and it's linked to an ective Excel spreadsheet in the same OneDrive account. But to your comment, "All the responses data will show up in your Excel workbook in real time." I have a very important question. What happens to those responses which are received WHILE I'm actively working in that Excel workbook.

        To test this, I left my Excel workbook open and then went and submitted a test form. That survey result shows in my forms responses, but even after closing and reopening the Excel spreadsheet, it is NOT found in my Excel workbook. Do I lose the data from those responses submitted while I'm working my workbook? This could be very problematic.

      • Roberto Cuenca commented  ·   ·  Flag as inappropriate


        I have the same issue @Erik Olsson. I made a form in Microsoft Form but I need move or duplicate in "Forms for excel" becuase i want to have the file excel in Onedrive Business/Sharepoint, is that possible ??

        Thanks in advance for you help or any information.


      • Joana Villas-Boas commented  ·   ·  Flag as inappropriate

        I have the same issue as @Erick Olsson. I worked a hole day in bulding a form with Microsoft Forms and I just learned it's not sotred anywhere that can be reached. I nedd it to be in some place where data can be edited or worked on. OneDrive for business for excemple. How can I move an existing form made in Forms to OneDrive for business?

      • Erik Olsson commented  ·   ·  Flag as inappropriate

        Great. is it possible to link a previously made form to a "Forms for excel" or does the above solution only apply to new forms you create?

        Meaning: If you want to have an excel file connected to a form you have to setup a "Forms for excel" before you create a form?


      • Thomas Sweeney commented  ·   ·  Flag as inappropriate

        I need the edits to the excel sheet to be reflected in the from review UI. This would allow me to add results of users who could not access the web when they were filling out the form.

      • Nylor commented  ·   ·  Flag as inappropriate

        How do I link an existing form to excel? I am a teacher trying to create a digital reading log.

      • MKD commented  ·   ·  Flag as inappropriate

        How can i link an existing form to Excel?. I can see how i can create new form in Excel Online, but i have already set up a form and have responses in it so would like to create an automatic link

      • Kesava Velugubantla commented  ·   ·  Flag as inappropriate

        its good to have it linked to a sharepoint list because when the person leaves the company then you cant really manage the his/her one drive and you will be loosing all that data and form.

      • HTurner commented  ·   ·  Flag as inappropriate

        Just to clarify, one way a team (i.e. department or group) can be alerted when a form is submitted is by Using Forms for Excel to create the survey and then have the members of the SharePoint Team site create an alert for the Excel document when it is updated?

        If this is true can there be cells in each record that do not appear on the survey that team members can use to indicate followup?

      • Jose commented  ·   ·  Flag as inappropriate

        Is it possible to have this feature as an option in the New Forms wizard that allows the user to check a box or something in a drop down that will enable the "Forms for excel" feature? The new feature seems to be hidden or hard to access because you have to go to OneDrive then choose the new option then the Forms for Excel option.

      • Anonymous commented  ·   ·  Flag as inappropriate

        PLEASE can we get this enabled for quizzes in Office 265 for Education. It's possible to do it in a limited way with flows but only the responses appear to be available not the automarking data which would be immensely more useful.

        The power of this to produce tailored feedback to students would be immense. If I've missed an option to do this, please let me know but I only seem to be able to create forms not quizzes from inside excel online at the moment.

      • Ajay commented  ·   ·  Flag as inappropriate


        I followed all the steps (the "Open in Excel" button even has a cloud symbol), but the data is not being updated in the sheet at all.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Does this work with Quiz? I tried the "Forms for Excel" but it is only for forms but not quizzes.

      • amanda commented  ·   ·  Flag as inappropriate

        I'm not sure if this a new function but I've been playing with forms and figured out if you create your form from inside Excel (online version - Home tab) it will link the form and excel automatically and update almost instantly, no need for Flow. The Excel sheet will be where ever you created it in OneDrive; can be shared with whoever you choose; can be opened online and viewed by whoever has access and you can add extra columns that don't appear on the form (and yes, they remain after the sheet is closed).

      • Johan commented  ·   ·  Flag as inappropriate

        Needed function as a admin and admin-team to:
        1) edit an answer is needed. During the life time of the current form eg errors needs to be able to be edited by the admin, so that future excelreports will be more correct.
        2) as an admin being able to edit and adjust which columns should be included in the report.

      • Reuben commented  ·   ·  Flag as inappropriate

        Yes, please link it to Excel 365 and Power BI (although I know we can connect Excel 365 to Power BI). Thanks.

      • Claudia commented  ·   ·  Flag as inappropriate

        I also agree with commenters on this thread who suggested that you should be able to view results in Excel online in OneDrive.

      • Laurie Boon commented  ·   ·  Flag as inappropriate

        You should be able to view entries in excel online by multiple people at the same time with the option to downloaded to an offline version. Working in the same way that Google Form responses do.

      ← Previous 1 3

      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.