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

# Export Student Responses

> Export Text, Multiple Choice, and Number responses from a Pear Deck session to a Google Sheet for grading

After a GoGuardian Pear Deck session ends, you can export Text, Multiple Choice, and Number responses to a Google Sheet along with each student's identifying information. You must sign in to Pear Deck with a Google account to use this feature. To see students' names in the spreadsheet, require email sign-in before you present.

## Export Responses from the Dashboard or Projector View

1. Open the **More Actions** menu in the Projector View or [Teacher Dashboard View](/products/pear-deck/the-teacher-dashboard).
2. Click **End This Session**. You will have the option to name the session and will then be brought to the Reflect & Review menu, which you can exit.

<img src="https://mintcdn.com/goguardian/s7oOcyDCDvZb2ExZ/images/screenshots/export-student-responses/step-01.png?fit=max&auto=format&n=s7oOcyDCDvZb2ExZ&q=85&s=63b4a137e603534043d1c626a6e142fd" alt="Projector view, more actions menu, unnamed session circled" width="852" height="990" data-path="images/screenshots/export-student-responses/step-01.png" />

3. Open the **More Actions** menu again and click **Export to Spreadsheet**.

<img src="https://mintcdn.com/goguardian/s7oOcyDCDvZb2ExZ/images/screenshots/export-student-responses/step-02.png?fit=max&auto=format&n=s7oOcyDCDvZb2ExZ&q=85&s=bc72d3eac33c635d3e81290b8ab02402" alt="Projector view, closed session, export to spredsheet" width="842" height="1200" data-path="images/screenshots/export-student-responses/step-02.png" />

<img src="https://mintcdn.com/goguardian/s7oOcyDCDvZb2ExZ/images/screenshots/export-student-responses/step-04.png?fit=max&auto=format&n=s7oOcyDCDvZb2ExZ&q=85&s=bb25df746d1d4fc367c5c280247db6b5" alt="Spreadsheet export, reponse types labled" width="687" height="276" data-path="images/screenshots/export-student-responses/step-04.png" />

## Export Responses from the Sessions Menu

1. Go to [Pear Deck Home](https://app.peardeck.com/home).

2. Open your [Sessions](https://app.peardeck.com/home/sessions).

3. Open the **More Actions** (three-dot) menu next to the session you want to export. If the session status is live, click **End Session** to close it first.

4. Click **Export to Spreadsheet**. Your spreadsheet will open in a new tab.

<img src="https://mintcdn.com/goguardian/s7oOcyDCDvZb2ExZ/images/screenshots/export-student-responses/step-03.png?fit=max&auto=format&n=s7oOcyDCDvZb2ExZ&q=85&s=c5627d05f429be740fff37270d392135" alt="Sessions page with the more actions menu highlighted in a red square, and in the menu, the item entitled export to…" width="1048" height="594" data-path="images/screenshots/export-student-responses/step-03.png" />

## Find Your Spreadsheet Later

When you export responses, the Google Sheet is automatically saved in your Google Drive under **Pear Deck** > **Exports**. This folder is created after your first export, and all subsequent exports are saved there as well.

## Understand the Spreadsheet Format

Spreadsheet exports include Text, Multiple Choice, and Number responses. Draggable and Drawing responses are not fully exported. Draggable answers export as coordinates, and Drawing answers do not appear at all (the spreadsheet indicates whether a student left a response to those question types). Each [response type](/products/pear-deck/the-five-interactive-question-types) is labeled in the exported spreadsheet.

## Resources

<CardGroup cols={2}>
  <Card title="The Teacher Dashboard" href="/products/pear-deck/the-teacher-dashboard">
    Review session activity and manage your presentations from the Teacher Dashboard.
  </Card>

  <Card title="The Five Interactive Question Types" href="/products/pear-deck/the-five-interactive-question-types">
    Learn about Text, Multiple Choice, Number, Draggable, and Drawing question types in Pear Deck.
  </Card>
</CardGroup>
