Syncing Data Sheet views to a spreadsheet

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 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 from the edit menu, select sync to excel/sheets from the edit menu select create query 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 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 go to the charthop sheets page in the google workspace marketplace 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 you may have to ask your it team for approval go to your google sheet select extensions > charthop sheets > insert data 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 go to your google sheet select extensions > charthop sheets > refresh data required disclosures charthop sheet use and transfer of information received from google apis to any other app will adhere to google api services user data policy , including the limited use requirements as charthop sheet 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 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 open your microsoft excel desktop app on windows, select data > existing connections > browse on mac, select data > get external data > run web query browse to the iqy file you downloaded and select get data 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 open your spreadsheet in the microsoft excel desktop app select data > refresh managing data sheet syncs after a live query link is displayed, it can not be displayed again and a new query needs to be pulled for administrators, you can view all of the live queries in your org and remove access to them via the managing data sheet and calendar syncs docid\ tqp 4z9cxqdaqswirlkgi packages basic basic | | headcount planning headcount planning | compensation reviews compensation reviews | performance performance | engagement engagement | hris