How to use spreadsheet reports

To gain insights into your audience’s performance and target instruction, you can download reports with all your game data. They can be downloaded to your computer in XLSX format, or saved directly to Google Drive. This article covers how to navigate all the data made available in spreadsheet form.

A basic spreadsheet report consists of five types of sheets:

1. Overview
2. Final Scores
3. Kahoot! Summary
4. Question sheets
5. Raw data

Overview

Here you’ll find stats about the overall session, like when it was played, who hosted the session, how many players joined, and how many questions were played through before the session ended. The Overview sheet also has “Overall Performance” and “Feedback” sections.

Overall Performance

Here you can get a general idea of how challenging the game was. You’ll see percentages of correct and incorrect answers, as well as the average score. You can compare these numbers to reports for the same game with different groups to, for example, see if there’s a trend and adjust the complexity of questions or training accordingly.

Feedback

At the end of a live game is a podium. If you click “Get results” in the top right of the screen, players will be given a short feedback form to fill out. This section of the Overview sheet shows you those results. We do not store individual player feedback. But you can tell if the game was  well-received by your audience overall.

Final Scores

This sheet shows a full leaderboard that includes nicknames, total score, correct answers, and incorrect answers.

Kahoot! Summary

This sheet shows a full leaderboard that includes nicknames and total score, followed by each question along with each players’ points awarded answer chosen.

Question sheets

For each question is a sheet with detailed stats. Question sheets also have “Answer Summary” and “Answer Details” sections.

Answer Summary

For each answer option, you can see how many answers were received and the average time taken to answer.

Answer Details

For each player, you can see what answer they chose, their score earned, their total score, and their time taken to answer.

Raw data

This sheet is formatted to be pivot-table friendly so that you can create your own tables and charts. Each row contains all data for a player’s response to a question.

Here are short descriptions of what data is collected in each column:

• A - Question Number: This is the numerical order a question was presented, regardless if question order is or isn’t randomized. The number is also followed by the type of question asked.
• B - Question: This is the question text players submitted an answer for.
• C, D, E, F - Answer 1, 2, 3, 4: These are the answer options players could choose from.
• G - Correct Answers: These are the correct answer options that award points if chosen.
• H - Time Allotted to Answer (seconds): This is the time players were given to respond.
• I - Players: This is the responding player’s nickname.
• J - Answer: This is the responding player’s submitted answer.
• K - Correct / Incorrect: This text value identifies if the player’s answer is “Correct” or “Incorrect”
• L - Correct: This numerical value identifies if the player’s answer is correct (1) or not (0)
• M - Incorrect: This numerical value identifies if the player’s answer is incorrect (1) or not (0)
• N - Score (points): This is the points earned for the answer submitted, including excluding Answer Streak Bonus.
• O - Score without Answer Streak Bonus (points): This is the points earned for the answer submitted, excluding Answer Streak Bonus.
• P - Current Total Score (points): This is the total points a player had earned after answering the question.
• Q - Answer Time (%): This is the percentage of allotted time passed before the answer was submitted.
• R - Answer Time (seconds): This is the seconds that passed before the answer was submitted.