> ## Documentation Index
> Fetch the complete documentation index at: https://docs.heyquiz.pro/llms.txt
> Use this file to discover all available pages before exploring further.

# Excel Export

> Downloading raw data to a spreadsheet

## 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?

<Steps>
  <Step title="Go to reports">
    Dashboard → Reports.
  </Step>

  <Step title="Select session">
    Click the session to export.
  </Step>

  <Step title="Click Export">
    **"Export"** button in top right corner.
  </Step>

  <Step title="Choose Excel">
    From format list, select **"Excel (.xlsx)"**.
  </Step>

  <Step title="Download">
    File will download automatically.
  </Step>
</Steps>

## Excel file structure

### Worksheets

The Excel file contains several sheets:

| Sheet            | Contents                        |
| ---------------- | ------------------------------- |
| **Summary**      | Basic session statistics        |
| **Participants** | Participant list with results   |
| **Questions**    | Per-question statistics         |
| **Answers**      | Details of each answer          |
| **Teams**        | Team statistics (if applicable) |

### "Summary" sheet

| Column            | Description              |
| ----------------- | ------------------------ |
| Quiz name         | Quiz title               |
| Session date      | Date and time            |
| Duration          | In minutes               |
| Participant count | Total number             |
| Average score     | Mean points              |
| Median            | Middle score             |
| Scoring mode      | Standard/Accuracy/Streak |

### "Participants" sheet

| Column    | Description                     |
| --------- | ------------------------------- |
| Position  | Ranking place                   |
| Nickname  | Participant name                |
| Points    | Total points                    |
| Correct   | Number of correct answers       |
| Wrong     | Number of wrong answers         |
| No answer | Times didn't answer             |
| Correct % | Accuracy %                      |
| Avg time  | In seconds                      |
| Status    | Active/Eliminated (in Survival) |
| Team      | Team name (if applicable)       |

### "Questions" sheet

| Column         | Description                      |
| -------------- | -------------------------------- |
| Question #     | Order in quiz                    |
| Content        | Question text                    |
| Type           | single/multiple/true\_false/etc. |
| Correct answer | Right answer                     |
| % correct      | Hit percentage                   |
| Avg time       | In seconds                       |
| Fastest time   | Record                           |

### "Answers" sheet

| Column               | Description     |
| -------------------- | --------------- |
| Participant nickname | Who answered    |
| Question #           | Which question  |
| Answer               | What they chose |
| Correct?             | YES/NO          |
| Points               | How many earned |
| Time                 | In 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:

```excel theme={null}
=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

<AccordionGroup>
  <Accordion title="File won't open">
    * Check if Excel/alternative is installed
    * Download file again
    * Try Google Sheets
  </Accordion>

  <Accordion title="Special characters are garbled">
    * Open as UTF-8
    * In Excel: Data → From Text → select UTF-8
  </Accordion>

  <Accordion title="Answers sheet is missing">
    * Answer details expire after 30 days
    * Export earlier for full data
  </Accordion>
</AccordionGroup>

## Next steps

<CardGroup cols={2}>
  <Card title="PDF Export" icon="file-pdf" href="/en/reports/pdf-export">
    Report for printing
  </Card>

  <Card title="Results analysis" icon="chart-line" href="/en/reports/analysis">
    How to interpret data
  </Card>
</CardGroup>