> 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/table-data.md).

# Table Data

Browse, search, filter and export your raw study answers in the Table Data view.

**Table Data** is the spreadsheet view of your study: one row per participant and one column per question. Use it to read raw answers, check data while fieldwork runs, and export. You find it under **Responses > Table Data**.

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

* Every question in your study has a column, even if nobody has answered it yet.
* Search and filters run against the whole study, not just the rows on screen. **Download (current filter)** exports exactly the rows you are looking at.
* Voice notes play inline, and their transcripts sit in their own columns.
  {% endhint %}

<figure><img src="https://358667285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzMRQUXiGQlBwWdg6WEmG%2Fuploads%2FdZJwzUQJHminJb4PpzQc%2Ffs-table-data.webp?alt=media&amp;token=2fc9e6e9-a84f-484c-99a7-bdc6c2d419af" alt="Responses > Table Data: one row per participant with status, timings, source and an answer column per question, and the toolbar for filters, columns, downloads and Data Actions"><figcaption></figcaption></figure>

## The toolbar

From left to right above the table:

* **Search responses**: searches the whole study on the server, not only the rows that have loaded.
* **+ Add Filter**: filter by answer, trust status and other columns (see below).
* **Share link** icon: copies a read-only results link. See [Share results](/results-and-reporting/share-results.md).
* **Row filter** (for example **All 20**): narrow to completed or in-progress participants. The counts here and in the footer match.
* **Refresh**: pulls in new answers and keeps the table on screen while it reloads.
* **Column picker**: show or hide columns.
* **Download** icon: CSV, Excel, SPSS, export by status, and sync to Google Sheets or Microsoft Excel. See [Export](#export) below.
* **Data Actions**: **Enrich Data**, **Translate Responses** and **Retranslate All**.

## What the table shows

Each row is one participant's answers.

<figure><img src="https://358667285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzMRQUXiGQlBwWdg6WEmG%2Fuploads%2FJ0UvXWn5aipyTcrXpvyp%2Ffs-column-picker.webp?alt=media&amp;token=ef6d6db0-026d-455f-8a2c-3dcad0dddb59" alt="The Table Data column picker: show or hide column groups such as survey answers and themes, or single columns, then Save"><figcaption></figcaption></figure>

The first columns describe the participant and their progress:

| Column                              | What it holds                                                                                                                                   |
| ----------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------- |
| **User ID**                         | The participant's identifier: their phone number, or a stable code if the study uses Privacy Protection.                                        |
| **Status**                          | **Completed**, **In Progress**, or on an AI interview **Interview In Progress**.                                                                |
| **Trust status**                    | The Response Trust verdict, for example **Approved** or **Not yet scored**. See [Response Trust](/monitor-fieldwork/response-trust.md).         |
| **Trust note**                      | The reason for the verdict (for example "All checks passed.") and any note a teammate added.                                                    |
| **Duration**                        | How long the participant took.                                                                                                                  |
| **Started At** and **Last Updated** | When they started, and when they last answered.                                                                                                 |
| **Transaction ID**                  | The one value you can pass in through a study link, for example a panel's respondent ID. See [Study links](/reach-participants/study-links.md). |
| **Recruited from**                  | The source, for example a panel provider or "Direct / other". See [Panel recruitment](/reach-participants/panel-recruitment.md).                |
| **Recruitment**                     | Which recruitment wave the participant came from.                                                                                               |

Then come the answer columns, which you can show or hide as families from the column picker:

| Column family       | What is in it                                                                                                                                                                                   |
| ------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Survey answers      | One column per question. Multi-select answers show as separate chips. Matrix questions get one column per row.                                                                                  |
| Transcriptions      | The written-out words of each voice note or video answer. In exports these sit right after the media question, labelled like **Q5 Transcription**.                                              |
| Translations        | Answers translated into your reporting language, when the study runs in more than one language. AI interviews held in another language also get a translated transcript column.                 |
| Themes              | AI theme labels for open text and voice note answers. While themes are being worked out, a banner reads "Classifying themes… columns will appear automatically". Test responses are not themed. |
| Participant profile | Name, age, gender, city and similar fields from your contact list. Hidden by default because they are often empty.                                                                              |
| Enrichment          | Extra columns you uploaded for these participants. See [Data enrichment](/integrations-and-api/data-enrichment.md).                                                                             |

An AI interview's follow-up questions and answers appear as transcript text, not as separate question columns, because every participant gets different follow-ups.

## Filter by answer

Use **+ Add Filter** to show, for example, only people who chose "Very likely". Filters on single-select and multi-select questions list the answer options. Filters combine, and each one narrows the table further. You can also filter on trust status, for example to review every participant who was flagged.

<figure><img src="https://358667285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzMRQUXiGQlBwWdg6WEmG%2Fuploads%2F5ILcdidu9yXGqnPogxUD%2Ffs-add-filter.webp?alt=media&amp;token=2d7f4e81-8b80-4b84-98a0-23e433c96f1c" alt="Adding a filter to Table Data: choose a column, a condition and a value"><figcaption></figcaption></figure>

## Media in the table

* **Voice notes** play inline in the cell.
* **Photos, videos and documents** open in the full-screen media viewer, with the question and participant above and the transcription or image description below.
* Click a participant to open their WhatsApp conversation in a side drawer.
* **Show more** on a long transcript cell expands just that cell.

## Translations

If your study runs in more than one language, Yazi translates answers into the language set in **Study configuration > Participant experience > Translate responses into**. Participants never see this. Translation runs automatically as new answers arrive. Two manual controls sit under **Data Actions**:

* **Translate Responses**: translates answers that have not been translated yet.
* **Retranslate All**: runs the translation again on every answer, for example after you change the reporting language.

Closed answers (single and multi-select) use your own scripted wording in each language rather than AI translation, so the same option lines up across countries. See [Languages and translation](/study-types/languages-and-translation.md).

## Enrich Data

**Data Actions > Enrich Data** uploads a CSV or Excel file of extra participant information (for example region or customer tier) and joins it to the table by phone number. See [Data enrichment](/integrations-and-api/data-enrichment.md).

<figure><img src="https://358667285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzMRQUXiGQlBwWdg6WEmG%2Fuploads%2FRTc7s33mALOd8072n1aA%2Ffs-data-actions.webp?alt=media&amp;token=85a53545-1c2a-4c8c-8846-69f745b902b0" alt="Table Data > Data Actions: Enrich Data, Transcribe, Translate Responses and Retranslate All"><figcaption></figcaption></figure>

## Export

The download icon opens three groups of options:

| Group                         | Options                                            | What you get                                                                                                                       |
| ----------------------------- | -------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------- |
| **Download (current filter)** | **CSV File**, **Excel File**, **SPSS File (.sav)** | Exactly the rows you are looking at, after any search, filter or row selection.                                                    |
| **Export by status**          | **Completed Only**, **Completed + In Progress**    | Completed participants only, or completed and in-progress participants together.                                                   |
| **Sync to**                   | **Google Sheets**, **Microsoft Excel**             | A live spreadsheet that updates during fieldwork. See [Google Sheets and Excel](/integrations-and-api/google-sheets-and-excel.md). |

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

For labels versus numeric codes, variable names, translations and what each column holds, see [Exports](/results-and-reporting/exports.md).

## Limits and things to know

{% hint style="warning" %}
**Filters change your download.** **Download (current filter)** contains only the rows that match your current search, filter or selection. Check the footer count before you export.
{% endhint %}

* **Column layout.** You can show and hide columns, and a layout you save is kept. Pinning and drag-to-reorder are not available.
* **Hiding a column does not delete the question.** It only changes your view of the table.
* **Not an external dashboard.** For a view your client can open without logging in, use a [share link](/results-and-reporting/share-results.md).
* **Very large studies** load progressively as you scroll. If a count looks low, check the footer total.
* **On a phone** the table switches to a card view.

## Related

* [Exports](/results-and-reporting/exports.md)
* [Transcripts](/results-and-reporting/transcripts.md)
* [Graph Data and cross-tabs](/results-and-reporting/graph-data-and-cross-tabs.md)
* [Data enrichment](/integrations-and-api/data-enrichment.md)
* [Response Trust](/monitor-fieldwork/response-trust.md)