# Export results

> Download responses as CSV or Excel, print a PDF summary of the charts, or get the key numbers as JSON.

Source: https://docs.hearsay.co.in/results/export

On the Analytics page, choose **Export**. Exports follow your current filter or segment: the menu says **Filtered: N responses** when one is applied.

![The Export menu: responses as CSV or Excel, a PDF summary report and a JSON summary](https://firebasestorage.googleapis.com/v0/b/hearsay-53fed.firebasestorage.app/o/docs%2Fshots%2Fexport-menu%2F1d6c7dfb7a02b9a5.webp?alt=media "The Export menu")

| Export | What you get | Plans |
|---|---|---|
| **Responses (CSV)** | Every response, one column per question | Pro and above |
| **Responses (Excel)** | Responses, a summary sheet and the filter used, in one workbook | Pro and above |
| **Summary report (PDF)** | The charts as a printable report | Every plan |
| **Analytics summary (JSON)** | Key numbers, channels, devices, languages and answer counts | Every plan |

## CSV and Excel

Large exports run in the background: Hearsay shows **Preparing your export…** and then **Exporting… N responses so far**, and the download starts by itself. The download link works for 15 minutes.

Each row is one response, with:

- **Response ID**, **Submitted at (UTC)**, **Survey version**, **Source** (channel), **Reference**, **Device**, **Language**, **Completion time (s)**, **Flagged**, **Reward code**, **Ending**, **Embed** and **Page URL**;
- a **Hidden:** column for each link field, personal ones included;
- one column per question: per row for matrix grids, per field for contact details, and two for file uploads (file names, and links to download them; the links need you to be signed in);
- the order options and questions were shown in, for anything shuffled.

Ranking answers are written as `First > Second > Third`. Cells that start with `=`, `+`, `-` or `@` get an apostrophe in front, so spreadsheets don't run them as formulas.

The Excel workbook adds a **Summary** sheet (counts, shares, averages and NPS) and a **Filter** sheet describing the filter. Excel can't hold more than a million rows; above that, use CSV.

Only editors and above can export. See [Roles and what each can do](https://docs.hearsay.co.in/workspace/roles).

## PDF summary

**Summary report (PDF)** opens a printable page in a new tab and starts your browser's print dialog: choose **Save as PDF**. It includes the key numbers, responses over time and every question's chart.

It leaves out written answers, contact details and uploaded files, so it's safe to pass around.
