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

Copper Contributor

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
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!