---
title: Syncing Data Sheet views to a spreadsheet
slug: live-queries
createdAt: 2026-10-13T19:54:42.790Z
---

You can sync a Data Sheet view directly to a Google Sheets or a Microsoft Excel file. This creates a "live query" that is kept up to date in your spreadsheet.

Changes you make to the spreadsheet are not synchronized to ChartHop. However, you can refresh the data for the spreadsheet periodically or when you expect that the ChartHop data may have changed.

For example, you can create a live query to sync the current hiring plan into a spreadsheet that you can use for financial modeling, and refresh the data straight from ChartHop as needed.

Live queries are automatically tied to the credentials of the user who generated them, so if that person's access is removed from the organization, the live query will automatically invalidate.

Query URLs expire automatically if they have not been used in 30 days. If a query URL expires, you need to re-create the query URL and link it again to a new spreadsheet.

Once you sync a live query to a spreadsheet outside of ChartHop, anyone with access to the spreadsheet can see the data included in it, regardless of sensitive data settings within ChartHop. When you are finished using your spreadsheet, delete the file to ensure access to the query is secured until it expires.

**Warning:** Query URLs are randomly generated and impossible to guess, but they are "public" because of how Microsoft Excel and Google Sheets retrieve data. Use caution when generating or pasting live queries. Do not share them outside of your organization. Remember that when unused, the query URL expires after 30 days.

## Create your query in ChartHop

Within ChartHop, create a query (based on a Data Sheet view) to use in either a Microsoft Excel file or a Google Sheet. You can then use the query in the respective spreadsheet type.

1. Go to the Data Sheet page and either select an existing Data Sheet view or create a new Data Sheet view to sync.
2. Select the **Export and Sync** (download) icon above the Data Sheet, then select **Sync to Excel/Sheets**.
3. Select **Create Query**.
4. In the **Sync to the spreadsheet** dialog box, either download the linked query file for Microsoft Excel or copy the query URL for Google Sheets.
5. Select **Close**.

After a live query link is displayed, it can't be displayed again. Copy or download it before you close the dialog. If you lose it, create a new query.

## Syncing to Google Sheets

You'll need to install the ChartHop Sheets extension before you can use your query URL from ChartHop. You may have to ask your IT team for approval.

### Install the ChartHop Sheets extension

1. Go to the [ChartHop Sheets page](https://workspace.google.com/marketplace/app/charthop_sheet/397657075455) in the Google Workspace Marketplace.
2. Select **Install**.

### Add your query to your Google sheet

1. Go to your Google sheet.
2. Select **Extensions > ChartHop Sheets > Insert Data**.
3. Paste the query URL and select **OK**.

### Refresh the data in your Google sheet

You can refresh the data in your Google sheet when you want to ensure your spreadsheet is up to date with ChartHop data. Remember that queries automatically expire after 30 days without use.

1. Go to your Google sheet.
2. Select **Extensions > ChartHop Sheets > Refresh Data**.

### Required disclosures

ChartHop Sheets use and transfer of information received from Google APIs to any other app will adhere to the [Google API Services User Data Policy](https://developers.google.com/terms/api-services-user-data-olicy#additional_requirements_for_specific_api_scopes), including the Limited Use requirements.

As ChartHop Sheets only exports data from ChartHop into your Google Sheet, it does not make any data from Google APIs available to any other app.

## Syncing to a Microsoft Excel spreadsheet

You can sync a ChartHop query to an Excel spreadsheet. Syncing is only supported in the Excel desktop app. Excel for the web is not supported.

### Add your query to your Excel spreadsheet

Be sure you have already downloaded the query (.iqy) file you created in ChartHop.

1. Open the Microsoft Excel desktop app.
2. On Windows, select **Data > Existing Connections > Browse**. On Mac, select **Data > Get External Data > Run Web Query**.
3. Browse to the .iqy file you downloaded and select **Get Data**.
4. Select **New Sheet** or choose an existing spreadsheet, then select **OK**.

### Refresh the data in your Excel spreadsheet

When you refresh, the spreadsheet syncs again to all current query data in ChartHop.

1. Open your spreadsheet in the Microsoft Excel desktop app.
2. Select **Data > Refresh**.

## Managing Data Sheet syncs

ChartHop Owners can view all of the live queries in your organization and revoke access to them from **Settings > Live Queries**. See [Managing data sheet and calendar syncs](https://docs.charthop.com/managing-data-sheet-and-calendar-yncs).

[Packages:](https://www.charthop.com/pricing/) Basic | Headcount Planning | Compensation Reviews | Performance | Engagement | HRIS