Exporting data from the Data Sheet

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.

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.

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.

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.