Create Pivot Table from Exported Survey Results Using Google Sheets

Pivot tables can be created from survey results using Google Sheets as well as Microsoft Excel. 

  • You can create a pivot table by exporting all the survey results first.

Navigation: Admin>surveys>responses

  • Click Grid view and then export the results by clicking the overflow menu.image__1_.png
  • Open the exported file in Google Sheets to start creating the pivot table. Now select the entire result and then go to insert and click pivot table.
  • Click New Sheet to create a new pivot table and then click the Create option.PIVOT_H1.png
  • Go to the rows sections in the pivot table editor and click the add to insert questions into the pivot table.
  • You can also add response, respondent, type, follow-up question response, and submitted on data to the pivot table under the rows section.PIVOTH2.png
  • To insert the related responses to the table, click add in the rows section and then select response.PIVOTH3.png
  • To insert the total number of respondents for each response into the table, add response to the pivot table from the value section.PIVOTH4.png
  • You can add the response percentage for particular response by adding response again from value section and then change response show as from default to % of grand total.pivot04.png


You can also filter the question type to be inserted into the pivot table from the filter settings.