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:“Summary” sheet
”Participants” sheet
“Questions” sheet
”Answers” sheet
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: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:- Export after each session
- Save in structured folders
- Create aggregate summaries
Macros and scripts
You can create macros for:- Automatic formatting
- Chart generation
- Additional metric calculations
Troubleshooting
File won't open
File won't open
- Check if Excel/alternative is installed
- Download file again
- Try Google Sheets
Special characters are garbled
Special characters are garbled
- Open as UTF-8
- In Excel: Data → From Text → select UTF-8
Answers sheet is missing
Answers sheet is missing
- Answer details expire after 30 days
- Export earlier for full data
Next steps
PDF Export
Report for printing
Results analysis
How to interpret data