Viewing survey results

Survey results are available in CSV format for surveys that have ended

Downloading the results

Click the download icon in the survey listing table.

You'll get a ZIP archive with three comma-separated values (CSV) files:

Scores

One row for each team-question pair:

• question: The question the rating relates to
• questionGroup: The topic the question belongs to
• team: The team associated with this rating (selected as their primary team by the respondents)
• rating: The average rating the team gave for the question on a scale from 1 to 5 (excluding skips)
  • If everyone in the team skipped the question, the value null is shown
• numberOfSkips: The number of people in the team who skipped the question
• totalNumberOfRespondents: The number of people in the team who selected it as their primary team and responded to the survey (= rated or skipped the question)

Comments

One row for each comment:

• question: The question the comment relates to
• questionGroup: The topic the question belongs to
• team: The primary team the comment's author selected in the survey
• comment: The contents of the comment
• authorName: The name of the user who wrote the comment

Participation

One row for each team:

• totalNumberOfRespondents: The number of people in the team who responded to the survey
• totalNumberOfTeamMembers: The number of people in the team who had access to the survey

Formatting the results with our Google Sheets template

You can use this Google Sheets template to format the results in a more readable format.

To set it up, open the template and follow these steps:

1. Choose File > Make a copy to create your own spreadsheet based on the template.

2. Go to the 🗄️ CSV: Scores tab.

3. Choose File > Import.

4. Go to the Upload tab and upload the CSV file with the scores.

5. In the Import file dialog, choose Replace current sheet as the Import location, choose Detect automatically as the Separator type, and ensure that the Convert text to numbers, dates, and formulas checkbox is selected. Click Import data.

6. Go to the 🗄️ CSV: Comments tab and repeat steps 3–5 using the CSV file with the comments.

7. You can see the formatted results on the 🚦 Heatmap, 📝 Comments by team, 📝 Comments by question tabs.