Spreadsheet import examples

This topic provides examples and tips to help you use the ChartHop spreadsheet uploader. These include adding a job that reports to an open job, working with PTO updates, adding terminations, and more.

Uploading a person or job that reports to an open job

You can upload a person or job that reports to an open job. To do so, add a column for Manager:req, and in it, enter the requisition code for the open job. By doing this, you tell ChartHop that the manager for the job or person corresponds to a requisition code for an open job.

The example in the following table creates two jobs: a Customer Success Manager and a Director of Customer Success, both starting on the same day. The Customer Success Manager reports to the Director of Customer Success.

Uploading PTO changes

You can update paid time off for your people by uploading a spreadsheet to ChartHop. In the following example, two people have requested time off and one request is still pending:

Required and optional columns

The following table describes required and optional columns for PTO uploads:

Uploading a person who is no longer employed

You can create a picture of your historical org by uploading people who are no longer employed. To do so, add an End Date column to the person’s information. 

If you want to avoid creating an automatic backfill, also add a backfillJob column with a value of No.

To change the departure type, add a Depart column with a value of Involuntary. This value defaults to Voluntary if not provided. 

The following table contains an example:

Uploading a person’s job history

You can upload a person’s job history via spreadsheet. As long as the person has already been created in ChartHop, you only need to include columns for information that has changed. 

In the following example, a person has been promoted. Note that the Date column reflects the start date of each position:

Uploading departures or terminations

When you want to update ChartHop to reflect a termination or departure, you can upload a spreadsheet that contains the change. Note that ending a job will automatically create a backfill unless you add a backfillJob column with a value of No.

See the following table for an example of an involuntary departure with no backfill:

Using a custom first column for a people upload

ChartHop prefers Work Email as the first column in a people upload. However, you can use another unique identifier such as payroll system ID. When using payroll system ID as the first column, rename the Manager column to manager:workEmail and then add email addresses as normal.

In the following example, the first column is a Paylocity ID and the manager's work email appears in the manager:workEmail column:

Uploading org changes with different dates

To upload multiple org changes with different dates, add them on separate lines of your spreadsheet with different values in the Date column. 

In the following example, John Smith received a title change on one date, but a salary adjustment on a different date.

Updating name fields

When you update name fields, take note of the following guidelines:

• To update a person's preferred name, add columns for First Name and Last Name in addition to Pref Name and Pref Last.
• To update a person's middle name, add columns for First Name and Last Name in addition to Middle Name.

The following table contains an example.

Updating phone numbers

When you update phone numbers, take note of the following guidelines: 

• Phone defaults to mobile number.
• Use contact.homePhone to update a home number.
• Use contact.workPhone to update a work number.