Hi, I’d like to send/view the summary report of a typeform in Excel so that I’m seeing the total answers for each question displayed in columns and rows. I understand I can download “All responses” but this doesn’t calculate the percentage of people who answered a certain way for each question. Any ideas on how to do this? I basically want to see Q1 - 3 people clicked “not interested”, 10 people clicked “interest” etc etc.
Answered
Send Summary Report to Excel
Best answer by john.desborough
i do this sort of thing in my google sheets for data quality/governance assessments where i pull the input from a user into a master list and have the set of values for counts, average scores for category and industry, etc, updated all the time… ie if 10 people from aerospace respond today, the averages for that industry sector in my output reports will be slightly different in a version of the report you see from yesterday to just after the last respondent gets theirs today (might be small based on the number in that industry but… )
des
+5Hi again
+6- Certified Partner & Champion
- 5264 replies
- Answer
i do this sort of thing in my google sheets for data quality/governance assessments where i pull the input from a user into a master list and have the set of values for counts, average scores for category and industry, etc, updated all the time… ie if 10 people from aerospace respond today, the averages for that industry sector in my output reports will be slightly different in a version of the report you see from yesterday to just after the last respondent gets theirs today (might be small based on the number in that industry but… )
des
Thanks
1 person likes this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.