Skip to main content

​
Overview

Excel export gives you raw data from a quiz session that you can:
  • Analyze in a spreadsheet
  • Create your own charts
  • Combine with other data
  • Process automatically

​
How to export to Excel?

1

Go to reports

Dashboard → Reports.
2

Select session

Click the session to export.
3

Click Export

“Export” button in top right corner.
4

Choose Excel

From format list, select “Excel (.xlsx)”.
5

Download

File will download automatically.

​
Excel file structure

​
Worksheets

The Excel file contains several sheets:
SheetContents
SummaryBasic session statistics
ParticipantsParticipant list with results
QuestionsPer-question statistics
AnswersDetails of each answer
TeamsTeam statistics (if applicable)

​
“Summary” sheet

ColumnDescription
Quiz nameQuiz title
Session dateDate and time
DurationIn minutes
Participant countTotal number
Average scoreMean points
MedianMiddle score
Scoring modeStandard/Accuracy/Streak

​
”Participants” sheet

ColumnDescription
PositionRanking place
NicknameParticipant name
PointsTotal points
CorrectNumber of correct answers
WrongNumber of wrong answers
No answerTimes didn’t answer
Correct %Accuracy %
Avg timeIn seconds
StatusActive/Eliminated (in Survival)
TeamTeam name (if applicable)

​
“Questions” sheet

ColumnDescription
Question #Order in quiz
ContentQuestion text
Typesingle/multiple/true_false/etc.
Correct answerRight answer
% correctHit percentage
Avg timeIn seconds
Fastest timeRecord

​
”Answers” sheet

ColumnDescription
Participant nicknameWho answered
Question #Which question
AnswerWhat they chose
Correct?YES/NO
PointsHow many earned
TimeIn seconds

​
Working with data

​
Sorting and filtering

In Excel you can easily:
  • Sort participants by results
  • Filter questions by difficulty
  • Extract specific groups

​
Custom charts

Create charts:
  • Score distribution (histogram)
  • Question comparison (bar chart)
  • Response time trends

​
Formulas and calculations

Example analyses: 
=AVERAGE(C2:C50)  // Average points
=STDEV(C2:C50)  // Standard deviation
=COUNTIF(E2:E50,">80%")  // How many >80%

​
Use cases

​
Detailed analysis

  • Comparing sessions over time
  • Trend analysis
  • Pattern identification

​
Integration with other systems

  • Import to LMS
  • Connection with employee database
  • Automatic reports

​
Aggregate reporting

  • Combining multiple sessions
  • Periodic reports
  • Dashboards in Power BI / Tableau

​
Compatibility

The .xlsx file works with:
  • Microsoft Excel 2007+
  • Google Sheets
  • LibreOffice Calc
  • Apple Numbers
  • WPS Office

​
Automation

​
Regular exports

For recurring reports you can:
  1. Export after each session
  2. Save in structured folders
  3. Create aggregate summaries

​
Macros and scripts

You can create macros for:
  • Automatic formatting
  • Chart generation
  • Additional metric calculations

​
Troubleshooting

  • Check if Excel/alternative is installed
  • Download file again
  • Try Google Sheets
  • Open as UTF-8
  • In Excel: Data → From Text → select UTF-8
  • Answer details expire after 30 days
  • Export earlier for full data

​
Next steps

PDF Export

Report for printing

Results analysis

How to interpret data