Forum Discussion

Seyed Ahmad Falasiri's avatar
Seyed Ahmad Falasiri
Copper Contributor
Sep 29, 2016

Dynamically Importing Forms Data into Master Excel Spreadsheet - Need Help/Please Advise

Hello,

 

I understand how to export the excel format from the microsoft form; however, it would be more useful if my master excel spreadsheet on my computer could dynamically update its data based on the microsoft form without the need for me to download the form every time.

 

Is there a method for an excel sheet to access and import the form's data on a dynamic basis? I haven't seen any option for doing so.

 

Forms is impractical for me to use as long as I have to manually download the form as an excel sheet to then import it into my master workbook. Pleas let me know if you have any solutions.


Best,

 

Shayan Falasiri

1 Reply

  • Linda Macaulay's avatar
    Linda Macaulay
    Copper Contributor
    YES! I want to own the form, but I need others to be able to see/edit the response data as it comes in. Google sheets/forms does this, so MS should too!

Resources