website logo
ChartHop documentation
Carrot reference
Release notes
Navigate through spaces
ChartHop documentation
Carrot reference
Release notes
⌘K
Welcome
Welcome to ChartHop documentation🚀
Available ChartHop packages
Getting Started
ChartHop Video Library
Navigating ChartHop
ChartHop terminology
Markdown formatting
Filtering data
Home page
Visualizing your organization
Org Chart
Map
Data Sheet
Employee Profiles
Setting up ChartHop
Creating your ChartHop org
Importing spreadsheet data
Configuring your Org settings
User management
Permissions and security
Creating and managing groups
Customizing ChartHop
Forms
Fields
Customizing employee profiles
Document templates
ChartHop apps and bundles
ChartHop apps
ChartHop bundles
Performance management
Performance reviews
Org management
About org management
Working with jobs
Working with people
Working with job history
Announcing org changes
Planning
Scenarios
Headcount planning
Compensation reviews
Legacy compensation reviews
Compensation bands
Viewing your people data
ChartHop reports
Partners
Sequoia getting started
Accessing ChartHop as a Sequoia customer
ChartHop first run guide for Sequoia customers
ChartHop features available to Sequoia customers
Troubleshooting common sync errors
Developers
ChartHop connect
Developer basics
Events
Syncing data to/from ChartHop
Resources
ChartHop Standard Terms and Conditions
ChartHop Basic Agreement
Data Processing Addendum
Privacy policy
Security statement
Subprocessors
FAQ
Docs powered by archbee 

Syncing Data Sheet views to a spreadsheet

Packages: Basic | Standard | Premium

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.

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 do one of the following:
    • Select an existing Data Sheet view
    • Create a new Data Sheet view to sync
  2. From the Edit menu, select Sync to Excel/Sheets from the Edit menu.
  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.

Syncing to Google Sheets

You'll need to install the ChartHop Sheets extension before you can use your query URL from ChartHop.

Install the ChartHop Sheets extension

  1. Go to the ChartHop Sheets page in the Google Workspace Marketplace.
  2. Select Install.

Add your query to your Google sheet

Prerequisite: Before adding a ChartHop query to a Google sheet, you need to install the ChartHop Sheets extension.

  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 and the data they populate automatically expire after 30 days.

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

Syncing to a Microsoft Excel spreadsheet

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

Add your query to your Excel spreadsheet.

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

  1. Open your Microsoft Excel desktop app.
  2. 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 and select OK.

Refresh the data in your Excel spreadsheet

You can refresh the data in your spreadsheet. When you refresh, the spreadsheet will sync again to all current query data in ChartHop.

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











Updated 23 Nov 2022
Did this page help you?
Yes
No
UP NEXT
Exporting data from the Data Sheet
Docs powered by archbee 
TABLE OF CONTENTS
Create your query in ChartHop
Syncing to Google Sheets
Install the ChartHop Sheets extension
Add your query to your Google sheet
Refresh the data in your Google sheet
Syncing to a Microsoft Excel spreadsheet
Add your query to your Excel spreadsheet.
Refresh the data in your Excel spreadsheet