ChartHop for Administrators
...
Importing spreadsheet data
Add or update a hiring plan
you can import a csv or spreadsheet file to make changes to open roles ensure that the data in your file conforms to charthop's formatting requirements to upload a hiring plan to charthop, complete the following steps from the settings menu (gear icon) in the left sidebar, select import spreadsheet data on the right side of the page, select add or update hiring plan select download template a csv template downloads to your computer add your data to the csv template, including any optional columns save the template under a new name on the upload your spreadsheet page, drag the template to the target area (optional) to create new groups in your charthop org, select allow spreadsheet to create new groups no te th at this does not include job codes , or bands , which must be created manually select upload to org for any fields in your spreadsheet that weren’t automatically matched to a charthop field, select a charthop field to match to your spreadsheet column you may need to scroll to see all unmatched fields, which are highlighted in red once all columns are matched, select continue with import to finish importing data (optional) when upload is complete, select view details to see a summary when matching spreadsheet columns with charthop fields, select none of these to skip a column skipped columns are not imported required columns the following columns are required column description example job title the job title customer service manager start date the job's start date in m/d/yyyy format 6/1/2022 manager the email address for the job’s direct manager example\@charthop com date effective date of job creation, in m/d/yyyy format 5/1/2022 optional c olu mns the following columns are optional 136,398,209 false true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type packages basic basic | | headcount planning headcount planning | compensation reviews compensation reviews | performance performance | engagement engagement | hris roles owner | org editor