website logo
Navigate through spaces
ChartHop documentation
⌘K
ChartHop Help Center
Getting around in ChartHop
ChartHop Video Library
Navigating ChartHop
Home page
Org Chart
Map
Data Sheet
Employee Profiles
Implementing ChartHop
ChartHop implementation overview
Creating your ChartHop org
Configuring your Org settings
Inviting users and setting permissions
Permissions and security
Creating and managing groups
Integrations and bundles
ChartHop for Administrators
Planning
Managing employee data
Creating reports and analytics
Managing people and jobs
Performance reviews
Building custom forms, tabs, and documents
ChartHop for Developers
ChartHop connect
Developer basics
Events
Syncing data to/from ChartHop
Partners
Sequoia getting started
Resources
Available ChartHop packages
ChartHop Standard Terms and Conditions
ChartHop Basic Agreement
Data Processing Addendum
Privacy policy
Security statement
Subprocessors
FAQ
Docs powered by archbee 
website logo

Exporting data from the Data Sheet

Packages: Basic | Standard | Premium

After you've finished filtering data in your Data Sheet, you can export your Data Sheet to a .csv file. This allows you to view it in spreadsheet applications such as Microsoft Excel.

You can also export review PDFs directly from the Data Sheet.

Export CSV
Export CSV

Export Data Sheet to a CSV

ChartHop enables you to export the data you refine in the Data Sheet to a .csv file. This is helpful for sharing your Data Sheet with others in an external context (for example, when sharing a list of dates of last raises/promotions with a planning committee).

You can also export data from the Data Sheet as a way to create a template for importing data back into ChartHop. For example, you can create a view that lists a group of employees whose Employee IDs you want to update. You can filter the Data Sheet to display only that group of employees and select any additional columns you want to update (for example, Employee ID).

Once the Data Sheet view is set up, you can export it to a .csv and edit that file to make those bulk changes. After you're finished editing, you can then re-import that spreadsheet back into ChartHop. Learn more.

If your exported data includes non-English characters or foreign phone numbers, you can adjust these settings after you save your .csv to Excel format. See the Microsoft Excel documentation for information about how to format cells. Remember that you may need to change the language as well.

Export CSV dialog
Export CSV dialog

To export to a .csv file:

  1. Select the Data Sheet from the left sidebar.
  2. Customize or filter the data you want to export by adding columns or using filters.
  3. Select Export CSV or select the Edit ▼ dropdown and select Export CSV. The Export CSV dialog displays.
  4. In the Export type dropdown, select the Data Sheet export type.
    • You can also select from the following export types (when you have the appropriate access role):
      • Comp History - Exports compensation history.
      • Data Collection History - Exports form data collected during the current review cycle.
      • Pending To-dos Only - Exports a list of pending to-dos. Learn more. 
      • All To-dos - Exports a list of all to-dos associated with the current review cycle. Learn more. 
      • User Lists - Exports a list of all ChartHop users, including the email associated with their ChartHop account, last active date/time, and access role.
  5. Enter a date for the export.
  6. (Optional) Select whether to include ChartHop IDs or former employees in the spreadsheet.
  7. Select Export.
  8. Once the export is complete, select Download to save the generated .csv file.

The export type you can select depends on your user access roles and permissions. Users with the Employee role can select only the Data Sheet export type.

Export Review Data to PDF

In addition to exporting data to .csv, you can also export specific review data to PDF directly from the Data Sheet. When you export reviews to PDF, submitted review data exports in individual PDFs by employee within a central .zip file. Learn more.

Updated 14 Dec 2022
Did this page help you?
Yes
No
UP NEXT
Employee Profiles
Docs powered by archbee