> 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/integrations-and-api/google-sheets-and-excel.md).

# Google Sheets and Excel

Sync a study's results to a Google Sheet or Microsoft Excel workbook that updates during fieldwork.

You can sync a study's results to a Google Sheet or a Microsoft Excel workbook. The spreadsheet keeps updating as new answers come in, so your team or client can follow fieldwork without downloading files again.

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

* Connect your Google or Microsoft account once in **Settings > Integrations**, then sync a study from the download menu on **Table Data**.
* Yazi only asks for access to the specific spreadsheets it creates or you pick, not your whole Google Drive.
* If you connected Google Sheets before mid-September 2026, reconnect once.
  {% endhint %}

## Before you start

* A Google account (for Google Sheets), or a Microsoft account with Excel online and OneDrive (for Excel).
* Permission to create or edit files in the place you want the spreadsheet to live.

## Connect your account

<figure><img src="https://358667285-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzMRQUXiGQlBwWdg6WEmG%2Fuploads%2FH9wLf5dMKaNAmsc4wyJt%2Fgoogle-sheets-card.webp?alt=media&amp;token=70607a45-ffda-4242-b645-67494815445f" alt="The Google Sheets card in Settings > Integrations"><figcaption></figcaption></figure>

{% stepper %}
{% step %}

### Open Settings > Integrations

Below the Connectors card you see **Google Sheets** and **Microsoft Excel**.
{% endstep %}

{% step %}

### Click Connect

Sign in with your Google or Microsoft account and approve access. For Google, the consent screen says Yazi can see "only the specific Google Drive files that you use with this app".
{% endstep %}

{% step %}

### Check the card shows as connected

You can **Disconnect** from the same card at any time.
{% endstep %}
{% endstepper %}

## Sync a study

{% stepper %}
{% step %}

### Open the study's Table Data

Go to **Responses > Table Data** and click the download icon.
{% endstep %}

{% step %}

### Choose Sync to Google Sheets or Microsoft Excel

Under **Sync to**, pick **Google Sheets** or **Microsoft Excel**.
{% endstep %}

{% step %}

### Pick or create the spreadsheet

Pick the spreadsheet to sync to and choose the worksheet tab. For Google Sheets, Google's own file picker opens and shows only Google Sheets files.
{% endstep %}

{% step %}

### Wait for the first sync

Current results fill the sheet, then new results are added during fieldwork.
{% endstep %}
{% endstepper %}

Syncing the same study to the same spreadsheet again reuses the existing link instead of creating a second one. If you pick a different worksheet tab, the sync moves to it.

## What the sheet contains

* The same columns as Table Data: one row per participant, with each question, transcripts, translations, trust status, recruitment columns and any enrichment columns.
* Media as short links, with captions for photos. The files themselves are not embedded.
* On a multi-activity study, all activities on one sheet.

## How often it updates

The sheet updates automatically during fieldwork, so you do not need to sync again. If something looks out of date, run the sync again from the **Table Data** download menu: it reuses the same link.

## Keep your own work safe

* Keep the synced tab as raw data. Build your pivot tables and charts on a separate tab, so new rows never break them.
* If Yazi cannot read a linked sheet, it stops and reports the problem rather than overwriting it. Columns you added yourself are not wiped.
* Share the sheet as view-only with people who should not edit it.

## Reconnect after September 2026

In September 2026 Yazi switched to the narrower Google permission that only covers files you use with Yazi. If you connected Google Sheets before then, the old connection has expired. Go to **Settings > Integrations** and connect again. It is one click, and nothing in your existing sheets is lost. Google has verified the app, so you no longer see an "unverified app" warning.

## Limits and things to know

* **Media is linked, not embedded.** Download any media you need to keep from the Media Library. See [Exports](https://docs.askyazi.com/results-and-reporting/exports.md).
* **Enrichment uploaded later.** If you upload enrichment columns after setting up a sync, check the sheet picks them up, and sync again if not.
* **Connection checks.** If Yazi cannot confirm your Google or Microsoft connection (for example during an outage), it says so and offers a retry, rather than telling you the account is not linked.
* **Excel cell size.** Excel cells hold a limited amount of text. Yazi keeps photo cells short (link and caption) so answers are not cut off.
* **Not a database connection.** For Power BI, Tableau or your own systems, use a sheet as the source, [Response Push](https://docs.askyazi.com/integrations-and-api/response-push-webhooks.md), or the API.

## Related

* [Exports](https://docs.askyazi.com/results-and-reporting/exports.md)
* [Table Data](https://docs.askyazi.com/results-and-reporting/table-data.md)
* [Response Push webhooks](https://docs.askyazi.com/integrations-and-api/response-push-webhooks.md)
* [Network allow-listing](https://docs.askyazi.com/set-up-whatsapp/network-allow-listing-for-corporate-it.md)
