Importing spreadsheet data
Use the import tool to make bulk changes to your ChartHop organization by uploading a CSV or spreadsheet. You can upload a CSV file or a Microsoft Excel native file (*.xlsx).
ChartHop provides synchronization apps to easily synchronize data from different payroll, equity, and applicant tracking systems (ATS) into ChartHop. In the cases where your system is not supported, you can import your people data directly to ChartHop by using a spreadsheet.
ChartHop supports importing the following types of data via a spreadsheet:
- People data
- Organization updates (changes to existing people or jobs)
- Org history (historical org data like start dates, and so on)
- Add or update equity data
- Add or update a hiring plan
When you use this option, you can download an example spreadsheet, add your data to it, and then upload the spreadsheet to ChartHop.
You can upload your CSV or spreadsheet file directly from the Import CSV Data page. You can upload any information you want, provided the target field(s) already exists.
ChartHop Premium customers can customize data fields in ChartHop. If you are uploading data to a custom field, you need to ensure that you add the field to ChartHop first.
- Select the gear menu in the left sidebar and then select Import Spreadsheet data.
From the right side of the page, select the respective link to view guidelines and download a spreadsheet template.
- Select Download template. A spreadsheet template downloads from your browser.
- Select the back button on your browser.
- Add your data to the spreadsheet template, including any optional columns that you want to include.
- Save the template to a new name.
- Drag the spreadsheet to the Upload your spreadsheet page or select the Browse button to navigate to where its located.
- Select Upload to org.
When uploading data, you can elect to create new groups in your ChartHop organization.
- From the Settings option in the left navigation bar, select Import spreadsheet data.
- Drag or manually upload your spreadsheet to uploader tool.
- Select the Allow spreadsheet to create new groups check box.
- Select Upload to org.
The easiest way to ensure the proper formatting for a spreadsheet you want to upload is to download a spreadsheet template. In addition to using a template that you download from ChartHop, you should use the following guidelines:
All column names are case-insensitive and ignore spaces. For example, a column named "Base Comp" means the same thing as a column named "basecomp" or "baseComp". Use whichever is most convenient for you. If you are importing data to a custom field that you created in ChartHop, use the field code as the column name instead of using field name.
The first column in your file is used as the identifier column, which identifies which job or person to attribute the information to. We require work email to be used as the identifier in most cases. Refer to the respective instructions for specific requirements.
Below is a list of commonly imported spreadsheet columns and example values.
Column | Format notes | Example |
Work email | Standard email address format. | john.smith@example.com |
First name | Full legal first name, not including middle names or ChartHop preferred names. | John |
Middle name | Leave blank if none. | George |
Last name | Full legal last name, not including any suffixes. | Johnson |
Preferred name | Any name, or nickname, that is different from legal name, leave blank if none. | Johnny |
Gender | Single letter representing gender. | F |
Ethnicity | A string indicating the ethnicity. | Asian |
Job title | Entire job title should be included in the same column. | Engineering Manager |
Start date | Must be mm/dd/yyyy format. | 12/09/2021 |
Date | Must be mm/dd/yyyy format. | 12/09/2021 |
Manager | Must be the email of the manager. | john.smith@example.com |
Department | Input a department that has already been added in ChartHop. | Engineering |
Base comp | Supports both annual and hourly compensation for base compensation. | Annual: 100,000 or 100,000/year Yearly: 25.75/hour |
Variable comp | Money value without currency sign or comma. | 10000 |
Currency | Currency symbol. | EUR |
Location | Input a location that has already been added in ChartHop | New York |
Grant price | Strike price per share of the grant, in dollars. | $2.50 |
Grant shares | Number of shares | 4700 |
Grant vest date | Date that the vesting schedule begins, in mm/dd/yyyy format. Defaults to issue date. | 12/09/2021 |
Grant ID | A unique identifier for the grant | FY2021 |
Grant type | Type of stock issued (ISO, NSO, RSU), defaults to ISO if left blank | NSO |
Grant vest | Represents the vesting schedule. Vesting schedules consist of an interval, the total length of the grant, and the cliff period. |
|
Recruit | The current recruiting status of an open role. Active or inactive. | Active |
ï»ż
