website logo
ChartHop documentation
Carrot reference
Release notes
Navigate through spaces
ChartHop documentation
Carrot reference
Release notes
⌘K
Welcome
Welcome to ChartHop documentationšŸš€
Available ChartHop packages
Getting Started
ChartHop Video Library
Navigating ChartHop
ChartHop terminology
Markdown formatting
Filtering data
Home page
Visualizing your organization
Org Chart
Map
Data Sheet
Employee Profiles
Setting up ChartHop
Creating your ChartHop org
Importing spreadsheet data
Configuring your Org settings
User management
Permissions and security
Creating and managing groups
Customizing ChartHop
Forms
Fields
Customizing employee profiles
Document templates
ChartHop apps and bundles
ChartHop apps
ChartHop bundles
Performance management
Performance reviews
Org management
About org management
Working with jobs
Working with people
Working with job history
Announcing org changes
Planning
Scenarios
Headcount planning
Compensation reviews
Legacy compensation reviews
Compensation bands
Viewing your people data
ChartHop reports
Partners
Sequoia getting started
Accessing ChartHop as a Sequoia customer
ChartHop first run guide for Sequoia customers
ChartHop features available to Sequoia customers
Troubleshooting common sync errors
Developers
ChartHop connect
Developer basics
Events
Syncing data to/from ChartHop
Resources
ChartHop Standard Terms and Conditions
ChartHop Basic Agreement
Data Processing Addendum
Privacy policy
Security statement
Subprocessors
FAQ
Docs powered byĀ archbeeĀ 

Importing spreadsheet data

Packages: Basic | Standard | Premium

Roles: Owner | Org editor

ChartHop provides apps with which you can sync data from different payroll, equity, and applicant tracking systems (ATS). When your system is not supported or when you want to make bulk updates, you can import a CSV or a Microsoft Excel XLSX file.

Import a spreadsheet file to ChartHop

The following image shows a section of the ChartHop spreadsheet upload process.

Matching ChartHop fields to spreadsheet columns
Matching ChartHop fields to spreadsheet columns

To import a CSV or Excel file to ChartHop:

  1. From the Settings menu (gear icon) in the left sidebar, select Import Spreadsheet data.
  2. On the Upload your spreadsheet page, drag your file to the target area.
  3. (Optional) To create new groups in your ChartHop org, select Allow spreadsheet to create new groups. Note that this does not include Job Codes, or Bands, which must be created manually in ChartHop.
  4. Select Upload to org.
  5. 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.
  6. Once all columns are matched, select Continue with import to finish importing data.
  7. (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.

Formatting spreadsheets for import

When formatting a spreadsheet file for upload to ChartHop, follow these guidelines:

  • When using Microsoft Excel, save files to XLSX, since Excel may corrupt files that are saved to CSV. 
  • Avoid empty columns in any file.
  • Column names are case insensitive and ignore spaces. For example, a column namedĀ "Base Comp"Ā is the same thing as a column namedĀ "basecomp".
  • When importing data to a custom field, use the field code as the column name instead of the field name.
  • When uploading data to a default field, you may use either the field code or the field name as the column name.
  • Enter complete job titles in any file to be uploaded (for example, "Senior Vice President" instead of "SVP"). ChartHop intelligently abbreviates titles in the org chart depending on how much screen space is available.
  • The first column in the file is the identifier column, which denotes the job or person to attribute the information to. ChartHop prefers Work email as the identifier in most cases.

  • Use the same kind of data in all similar fields. For example, use an email address in the Manager column if using Work email as the identifier.
  • You can upload historical data such as former employees. ChartHop will only display them if the date slider is moved back to when they were with your org.

You can export existing employee data from the Data Sheet as a .csv file to use as a spreadsheet template for your changes. Once you are done editing that .csv file, you can import it back into ChartHop. Learn more.

ChartHop Standard and Premium customers can add custom fields. If you are importing data to a custom field, be sure to first add the field to ChartHop. Learn more.

Updated 14 Dec 2022
Did this page help you?
Yes
No
UP NEXT
Add new people to ChartHop
Docs powered byĀ archbeeĀ 
TABLE OF CONTENTS
Import a spreadsheet file to ChartHop
Formatting spreadsheets for import