Generating a report of the Feedback from participants
This blog post explains how to generate a summary report of the feedback collected through Google Forms.
- Download the Google sheet containing the responses (one response per row format)
- Download the Blank Excel file containing the macro from here. Enable macros by ticking "unblock" in the "Properties" of the downloaded Excel file
- Go to the Excel file containing the feedback responses and press Ctrl+Shift+F
- The report will be generated!! It should look like this.