Forum Discussion

Suzanne_01's avatar
Suzanne_01
Copper Contributor
Jul 25, 2019

Real time Microsoft Forms results in Excel Worksheet

Hi,   I want to use Microsoft forms for an invoice in excel. I have made the invoice, which automatically collects data from the Excel table opened with Microsoft Forms, but when a new response has...
BI & Data Analysis
excel
nabilmourad's avatar
nabilmourad
MVP
Jul 25, 2019

Suzanne_01 

Hi

When you open the the Form in Microsoft Forms, you have 2 tabs at the top >> Click on the Responses Tab.

in the Upper right side there is an option saying: Open in Excel

If your excel file is saved in the clouds (oneDrive) then it updates to include new responses.

If you click on the elipses, there is an option to print the responses or delete them.

Hope that helps

Nabil Mourad

 

  • Suzanne_01's avatar
    Suzanne_01
    Copper Contributor
    Jul 25, 2019
    Hi,
    I saved it on OneDrive, but when I fill in a new response, it isn't added to the existing Excel..
    Do you know what the problem might be?

    Thanks already for the help
    • nabilmourad's avatar
      nabilmourad
      MVP
      Jul 25, 2019

      Suzanne_01 

      Hi Suzanne

      I assume you started creating your survey in Microsoft Forms and you try to view responses in Excel.

      try to initially create your survey by using Forms in Excel Online: Insert Tab of the Ribbon >> Survey (or Form) and go from There.
      Save the File in the clouds
      Test responses

      Hope that helps
      Nabil Mourad

      • Fumin5's avatar
        Fumin5
        Copper Contributor
        May 30, 2023

        Hmm... why is this the case?

        So you are saying Real Time update only works if Forms is created initially from Web Excel, but it will not work if I created the form first then "open in Excel"? This is so rigged... it supposed to be vice versal.

        This is so annoying, I already created my forms and conditions, i have over 70 questions and now i have to redo everything again because Excel Web doesnt sync the data in real time at all =.= I tried your method, but I can't even import a template (will be REALLY nice they enable this option so i could just duplicate my form than to Recreate the whole form again).

        My current solution is to keep doing "Sync all new responses to a new Workbook" which will just create multiple duplicates in my sharedrive........ This is so inefficient in the long run, to view live/new data, I have to manually create a new excel workbook and delete the old ones to prevent duplicates and wasting of space.

Resources