Viewing survey results

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

Downloading the results

Results are available only from surveys that have ended. You can't view results from live surveys. 

Click the download icon in the survey listing table.

download survey results

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

You can format the results to your liking by importing the CSV files into an application like Excel or Google Sheets.

You can also use this Google Sheets template to format the results.

survey-reporting-template

We'll soon show the results directly in the Swarmia app. Stay tuned!

Frequently asked questions

Why are the ratings formatted as dates in my spreadsheet app?

Microsoft Excel or Google Sheets might automatically format values like 3.8 as dates, depending on your regional settings. To prevent this from happening, you can try the following:

Microsoft Excel:

  1. Change the file extension of your CSV file from .csv to .txt.
  2. Open the file in Excel. The Text Import Wizard will appear.
  3. Choose "Delimited" and select "Comma" as the delimiter.
  4. Select the numeric columns and change their format from "General" to "Text."

Google Sheets

  1. Upload the CSV file via File > Import.
  2. Select "Comma" as the Separator type.
  3. Turn off the checkbox "Convert text to numbers, dates, and formulas."