Importing data into Excel spreadsheet from Excel Survey Form Pro spreadsheet

Copper Contributor

I have an existing Excel spreadsheet where I can manually enter the users answers (0, 1, 2, 3) they are weighted and analyzed and made into a graph.  This part works fine except that I have to manually enter their answers and I want to automate this process!

I want to create a survey in Microsoft Forms pro (of more than 50 questions that the answers (0, 1, 2, 3) can be automatically Exported into their correct fields into my existing Excel spreadsheet.  Or I can move my Excel Spreadsheet over to the Excel Workbook that collects the Survey responses and Import that Data from the Survey into those Data Fields for individual User's Data analysis and generate the graph as a reply.

And, I want to be able to export their graph either as a .pdf to their email or have it pop up on their window after they are done answering the survey.

I created a survey form with the questions and the User's answers are populated into an Excel spreadsheet.  


0 Replies