> For the complete documentation index, see [llms.txt](https://docs.askyazi.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.askyazi.com/results-and-reporting/exports.md).

# Exports

Every way to get data out of Yazi, what each file contains, and how to set labels, numeric codes, variable names and translations.

This page lists every export in Yazi and explains exactly what goes into each file: answer labels or numeric codes, variable names, translations, voice note transcripts, trust status and media. Most exports start from the download icon on **Responses > Table Data**.

{% hint style="info" %}
**In short:**

* The **Table Data** download menu gives you **CSV File**, **Excel File** or **SPSS File (.sav)**. For CSV and Excel you choose labels, numeric codes or both, and full question text or short variable names (Q1, Q2).
* Voice note and video transcripts sit in the column right after each media question, labelled like **Q5 Transcription**.
* **Download (current filter)** contains exactly the rows you are looking at. Clear search and filters first, or use **Export by status**, if you want everyone.
  {% endhint %}

## Every export at a glance

| Export           | Where                                                                                                                   | Format                                                          | Use it for                                               |
| ---------------- | ----------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------- | -------------------------------------------------------- |
| Response data    | **Responses > Table Data**, download icon                                                                               | CSV File, Excel File, SPSS File (.sav)                          | Analysis in Excel, SPSS, Q, R or Python                  |
| HTML Transcript  | **Share > Participants**, **Export** (see [Transcripts](https://docs.askyazi.com/results-and-reporting/transcripts.md)) | .html, one file covering the selected participants              | Reading or sharing whole conversations, or saving as PDF |
| Media files      | **Responses > Media Library > Download**                                                                                | ZIP                                                             | Photos, voice notes and videos, named your way           |
| PowerPoint       | **Reporting > Graph Data > PPT**, **Report**, **Insights**                                                              | .pptx (Report also PDF)                                         | Presenting results                                       |
| Insights data    | **Reporting > Insights**                                                                                                | PowerPoint, Excel                                               | Themes and classified responses                          |
| Questionnaire    | **Build > Export**                                                                                                      | Word, Excel (with or without translations), or copy as markdown | Sharing or reviewing the questionnaire                   |
| Live spreadsheet | **Settings > Integrations**                                                                                             | Google Sheets, Microsoft Excel                                  | A sheet that updates during fieldwork                    |
| Partner push     | **Build > Study configuration > Integrations**                                                                          | JSON to your endpoint                                           | Sending each response to your own system                 |

Downloads are named after the study (for example `customer-satisfaction-wave-2.xlsx`). While a file is being prepared, a progress banner shows at the bottom right of the screen.

<figure><img src="https://358667285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzMRQUXiGQlBwWdg6WEmG%2Fuploads%2FWObFVHfH8UbErOtx13kK%2Ffs-download-menu.webp?alt=media&amp;token=a65b457a-a60c-4891-b42c-c3b62b126663" alt="The Table Data download menu: CSV, Excel or SPSS for the current filter, export by status, and sync to Google Sheets or Microsoft Excel"><figcaption></figcaption></figure>

## Export response data (CSV, Excel, SPSS)

{% stepper %}
{% step %}

### Choose the rows

Go to **Responses > Table Data**. Search, filter or tick rows if you only want some participants. To export everyone, clear the search and filters and check the footer count.
{% endstep %}

{% step %}

### Open the download menu and pick a format

Click the download icon in the Table Data toolbar. The menu has three groups:

* **Download (current filter)**: **CSV File**, **Excel File** or **SPSS File (.sav)**. These contain exactly the rows you are looking at.
* **Export by status**: **Completed Only** or **Completed + In Progress**.
* **Sync to**: **Google Sheets** or **Microsoft Excel**, for a live spreadsheet. See [Google Sheets and Excel](https://docs.askyazi.com/integrations-and-api/google-sheets-and-excel.md).
  {% endstep %}

{% step %}

### Set the options (CSV and Excel)

A small options screen appears. Your choices are remembered for next time, so you do not set them on every export. See the options below.
{% endstep %}

{% step %}

### Choose the answer language (multi-language studies)

If your study has answers in more than one language, Yazi asks whether to translate before downloading. This question only appears when there is more than one language in the data.
{% endstep %}
{% endstepper %}

### Answer values: labels, numeric codes or both

| Option            | What a single-select answer looks like             |
| ----------------- | -------------------------------------------------- |
| **Labels**        | `Very satisfied`                                   |
| **Numeric codes** | `5`                                                |
| **Both**          | Two columns: one with the label, one with the code |

Before you script your analysis, check how the codes map to your answer options in a small test export.

### Column headings: question text or variable names

* **Full question text**: each column is headed with the question as written.
* **Short variable names**: columns are headed `Q1`, `Q2`, `Q3` and so on, which suits SPSS, Q and scripts.

### Multi-select layout

Multi-select questions can be split into **one column per option**, holding `1` if the participant chose it and `0` if not. This matches the SPSS export. Otherwise the chosen options sit together in one column.

These three settings change how the file is written, not the data itself. The SPSS (.sav) export is not affected by them.

Numeric codes and variable names are available on surveys, AI interviews and recurring or diary studies.

### Answer language: Translate to English or Leave as written

| Choice                   | What you get                                                                                                                                                                                        |
| ------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Translate to English** | English in the main answer column. Closed answers (single and multi-select) use your own scripted English wording, so an option reads the same in every country. Open answers are translated by AI. |
| **Leave as written**     | Every answer exactly as the participant gave it, in their language.                                                                                                                                 |

Separately, a multi-language study's export includes translation columns alongside the originals, so you can have both. Translation columns only appear on studies that have translations switched on. If some answers are missing a translation, run **Data Actions > Translate Responses** on **Table Data** before you export.

The language used for translations in **Table Data** is set in **Study configuration > Participant experience > Translate responses into**. See [Languages and translation](https://docs.askyazi.com/study-types/languages-and-translation.md).

## What is in a response data file

The file follows the Table Data columns.

| Column                                         | What it holds                                                                                                                                                                    |
| ---------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **User ID**                                    | The phone number, or a stable code if the study uses Privacy Protection. The code cannot be reversed into a phone number, and it matches the codes in exported media file names. |
| **Status**                                     | **Completed**, **In Progress** or **Interview In Progress**.                                                                                                                     |
| **Duration**, **Started At**, **Last Updated** | Timing for each participant.                                                                                                                                                     |
| **Transaction ID**                             | The value passed in through the study link, if any (for example a panel respondent ID).                                                                                          |
| One column per question                        | Every question in the study, even if nobody answered it (the column is then empty).                                                                                              |
| Matrix questions                               | One column per row.                                                                                                                                                              |
| Piped matrix questions                         | One column per possible row, filled only for the rows each participant was shown.                                                                                                |
| **Q*****n*****&#x20;Transcription**            | Right after each voice note or video question: the words the participant said.                                                                                                   |
| Media links                                    | A short link (`links.askyazi.co/...`) to each photo, voice note, video or document. Photo cells hold the link and a caption, not the full AI description.                        |
| **Full Transcript**                            | The AI interview conversation as text. Interviews held in another language also get a **Translated Transcript** column.                                                          |
| Translation columns                            | Translated answers, on multi-language studies.                                                                                                                                   |
| Theme columns                                  | AI themes for open text and voice note answers.                                                                                                                                  |
| **Trust status** and **Trust note**            | **Approved**, **Flagged**, **Rejected** or **Not yet scored**, with the reason and any reviewer note.                                                                            |
| **Recruited from** and **Recruitment**         | The panel or source, and the recruitment wave.                                                                                                                                   |
| Enrichment columns                             | Any columns you uploaded for these participants.                                                                                                                                 |
| **Simulated**                                  | Present when the file includes simulated test responses.                                                                                                                         |

Column headings stay in English even on accounts that use the app in another language, because analysis scripts often read them.

### Where voice note transcripts are

This is the most common export question. Transcripts are already in your file:

* In the column **immediately after** each voice note or video question, headed **Q*****n*****&#x20;Transcription** (for example **Q5 Transcription**).
* In the **Full Transcript** column, for voice notes sent during an AI interview.

## SPSS (.sav)

* Each multi-select option becomes its own 0/1 variable.
* Variable types are set correctly for numbers and text.
* The SPSS export is capped at **10,000 rows**. Above that, Yazi warns you. Use CSV with numeric codes and short variable names for the full set, then import that into SPSS.

## Media downloads

From the **Media Library**, download exactly what you ticked or filtered to, as a ZIP. Before it downloads you choose how files are named, for example by question, participant and activity (`Q1_27821234567.ogg`). On studies with Privacy Protection, file names use the participant code, never a phone number. See [Media Library](https://docs.askyazi.com/results-and-reporting/media-library.md).

You do not need the files themselves to see which photo or voice note belongs to which answer: the raw data download from **Table Data** (CSV, Excel or SPSS) contains a link to every media file in the row of the participant who sent it.

## HTML transcripts

**HTML Transcript** downloads one self-contained `.html` file covering the selected participants: each participant's questions, answers and images in WhatsApp style, under your organisation's logo. Voice notes and documents appear as labelled placeholders with their transcripts. Open it in any browser, and use **Print > Save as PDF** for a PDF. A study-level version combines each participant's conversation across all activities. You find **HTML Transcript** in the **Export** menu on **Share > Participants**.

## Questionnaire export

From **Build > Export**, download the questionnaire as **Word** or **Excel**, or use **Copy as markdown** to paste it elsewhere. When your study has a second language, two more options appear: **Word, with translations** and **Excel, with translations**. Each translated line is labelled **Manual translation**, **AI translation** or **Reviewed**, and the file includes the welcome, closing and completion messages. Use it to send translations to a local reviewer.

<figure><img src="https://358667285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzMRQUXiGQlBwWdg6WEmG%2Fuploads%2FQZaKSGmvFkVComUqOJhj%2Ffs-questionnaire-export.webp?alt=media&amp;token=7cc64401-b6c9-47de-b4ff-be42a0a38039" alt="Build > Export: download the questionnaire as a Word document or Excel spreadsheet, or copy it as markdown"><figcaption></figcaption></figure>

## Other downloads

* **Participant list**: **Share > Participants** has its own export of participants and their statuses. See [The Participants tab](https://docs.askyazi.com/monitor-fieldwork/participants-tab.md).
* **Send History**: each broadcast and schedule's recipients and outcomes download as CSV. See [Send History and statuses](https://docs.askyazi.com/reach-participants/send-history-and-statuses.md).
* **Reward approvals**: the rewards drawer has a CSV export. See [Set up rewards](https://docs.askyazi.com/reach-participants/set-up-rewards.md).
* **Group discussions**: a moderator can export the discussion to Excel or CSV while it runs.

## Limits and things to know

{% hint style="warning" %}
**Your filters decide what is exported.** If you searched or filtered Table Data, **Download (current filter)** only contains those rows. Check the footer count before you export.
{% endhint %}

* **SPSS stops at 10,000 rows.** Use CSV for bigger studies.
* **No weighting.** Exports are unweighted. Weight in SPSS, Q or similar. See [Analysis limits](https://docs.askyazi.com/results-and-reporting/analysis-limits.md).
* **Media links are links, not files.** Anyone you send the file to needs the links to open them. Media links in exports are permanent and do not expire.
* **Multi-activity studies.** An export waits until every activity has loaded. If it cannot load one, it stops with an error naming the problem rather than writing a short file. Try again.
* **Formula characters are made safe.** Cells that start with characters a spreadsheet would treat as a formula are neutralised, so a crafted answer cannot run when someone opens the file.
* **Exports before September 2026.** Two export faults were fixed in September 2026: columns for questions nobody on the viewed page had answered were dropped, and raw AI interview response exports carried the wrong interview and question IDs. If you built analysis on a file pulled before mid-September 2026, export it again and compare.

## Related

* [Table Data](https://docs.askyazi.com/results-and-reporting/table-data.md)
* [Google Sheets and Excel](https://docs.askyazi.com/integrations-and-api/google-sheets-and-excel.md)
* [Response Push webhooks](https://docs.askyazi.com/integrations-and-api/response-push-webhooks.md)
* [Languages and translation](https://docs.askyazi.com/study-types/languages-and-translation.md)
* [Analysis limits](https://docs.askyazi.com/results-and-reporting/analysis-limits.md)
