Importing historical data

you can upload historical data for current and terminated employees, including changes to departments, compensations, and titles you can view h istorical data from both the history page as well as in any other place in charthop that uses the date slider tool, such as the org chart and the data sheet types of historical employee data that can be tracked terminated employees compensation changes manager changes department changes title changes to upload multiple historical data categories at once for one or more employee(s), when uploading your spreadsheet, you must give each category its own tab when you import historical data to charthop, depending on the category above, it will only accept the import if the data is provided using the correct column headers you can use the examples below to learn about the required column headers for each category historical data examples the following section below provides templates you can use to upload historical data for employees in your charthop organization events that occur on unique dates should be reflected on new lines terminated employees template you can upload historical data for terminated employees to do so, you will need to add the employee's employment information including full name first manager during their hire date (start date) any manager and title changes during their tenure in the organization the end date of their employment in the example below, we have the employment history for john the software engineer 225,0,0,0,0,0,111,203 false true false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type line 1 john's new hire information is added including his work email (unique identifier), first and last name, start date of his employment, starting manager's email, and starting job title line 2 john receives a promotion and a manager change on the same day the date of the change was captured in the date field line 3 john's termination day is captured in the end date also no planned backfills for his position compensation changes template you can upload historical data for changes to employee's compensation over time to do this, add the employee's employment information including base salary hourly compensation (optional if hourly compensation is used by your org) the currency that was used any variable or base commission changes (reflecting annual amounts) 0,0,0,0,0,0,101 false true false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type line 1 evan's base compensation of $100,000 is captured on april 1st, 2021 alongside a compensation of 10% of his yearly income line 2 even receives a $15,000 yearly salary increase effective january 1st, 2022 alongside his bonus being increased by 5% line 3 sarah's pay is captured at $50 per hour while working 32 hours per week alongside a variable commission of $5000 line 4 joy's pay is captured at $50 per hour while working 32 hours per week alongside a bonus of 12% of her yearly income manager changes template you can upload historical data for changes to employee's managers over time to do this, you will need the dates of the changes, as well as the manager's emails 260,0,0,0,0,0,101 false true false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type line 1 larry was assigned a new manger on april 1st, 2021 line 2 larry was then later assigned a new manager on january 1st, 2022 department changes template you can upload historical data to reflect departmental changes for employees over time to do this, you will need the dates of the changes, as well as the names of the departments 260,0,0,0,0,0,101 false true false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type line 1 henry was assigned to the engineering department on april 1st, 2021 line 2 ashley was assigned to the product department on january 1st, 2021 line 3 later that year, ashley was reassigned to the hr department on june 1st, 2022 title changes template you can upload historical data to reflect the changes to an employee's titles over time to do this, you will need the dates of the changes, as well as the names of the titles 260,0,0,0,0,0,101 false true false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type line 1 ben's title was engineer, but was then promoted to senior engineer on january 1st, 2022 line 2 illen's title was junior accountant was then promoted to accountant on january 1st, 2021 line 3 in the following year, illen was promoted to senior accountant