Forum Discussion
Seyed Ahmad Falasiri
Sep 29, 2016Copper Contributor
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
Sort By
- Linda MacaulayCopper ContributorYES! 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!