---
title: Importing spreadsheet data
slug: importing-spreadsheet-data
createdAt: 2022-03-07T16:37:06.000Z
---

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 spreadsheet data to ChartHop

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

![Matching ChartHop fields to spreadsheet columns](https://api.archbee.com/api/optimize/CXAjUAezd9VEEVQBIYmdw/OiqMNasVhGbBVuagpsrr6_spreadsheet-uploader.png "   ")

To import a CSV or Excel file to ChartHop:&#x20;

1. Select **Admin (gear icon)** in the left sidebar, select **Import Spreadsheet data**.
2. On the **Import Spreadsheet data** page, drag your file to the target area.
   1. (Optional) Select **Allow spreadsheet to create new people and jobs** - use if your upload contains new people or jobs. If not checked, only existing people or jobs will be updated.
   2. (Optional) To create new [groups](https://docs.charthop.com/creating-and-managing-groups) in your ChartHop org, select **Allow spreadsheet to create new groups**. Note that this does not include [Job Codes](https://docs.charthop.com/job-codes), or [Bands](https://docs.charthop.com/compensation-bands), which must be created manually in ChartHop.
3. Select **Upload to org**.
4. 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.&#x20;
5. Once all columns are matched, select **Continue with import** to finish importing data.&#x20;
6. (Optional) When upload is complete, select **View Details** to see a summary.&#x20;

:::hint{type="warning"}
When matching spreadsheet columns with ChartHop fields, select **None of these** to skip a column. Skipped columns are not imported. &#x20;
:::

## Spreadsheet Templates & Guides

From the right side of the page, you can select and download templates of CSVs to use.

### Add new people

Use this guided template to create new people in your org

::File{src="https://api.archbee.com/api/presign/CXAjUAezd9VEEVQBIYmdw/6Re10Us1-O8uh2utgbrv6_add-new-people-template.csv" label="Add new people Template.csv"}

### Update current org

Make changes to existing people and jobs

::File{src="https://api.archbee.com/api/presign/CXAjUAezd9VEEVQBIYmdw/HkhOkZlNR5HLLNxHs6uXi_update-current-org-template.csv" label="Update current org Template.csv"}

### Update org history

Make changes to historical org data

::File{src="https://api.archbee.com/api/presign/CXAjUAezd9VEEVQBIYmdw/EUAE8BzKJCqEqLHF7k5Dx_update-org-history-template.csv" label="Update org history Template.csv"}

### Add or update equity data

Create or make changes to stock grants and vesting schedules

::File{src="https://api.archbee.com/api/presign/CXAjUAezd9VEEVQBIYmdw/ZD-ZOaGYyIdHVBa6amdU7_add-or-update-equity-data-template.csv" label="Add or update equity data Template.csv"}

### Add or update hiring plan

Create or make changes to open roles

::File{src="https://api.archbee.com/api/presign/CXAjUAezd9VEEVQBIYmdw/58E2MjXTvBsj8rL2Ojtb3_add-or-update-hiring-plan-template.csv" label="Add or update hiring plan Template.csv"}

##

## Formatting spreadsheets for import

When you format a spreadsheet file for upload to ChartHop, you should follow a series of guidelines listed in this section below.

### File format for spreadsheet imports&#x20;

When using Microsoft Excel, save files to XLSX, since Excel may corrupt files that are saved to CSV.

When importing a XLSX file, also be sure to do the following:

- Avoid empty columns.&#x20;
- 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.&#x20;
- 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 for the employee.

Also note that columns are case insensitive and ignore spaces. For example, a column named "Base Comp" is the same thing as a column named "basecomp".

:::hint{type="info"}
You must include the country code as a part of any international number for it to be recognized as such within ChartHop. When you are syncing phone numbers from an external system, such as a payroll system or ATS, be sure the country code is included in the phone number that is listed in the external system. This also applies when updating data through a spreadsheet.
:::

### Identifiers for spreadsheet imports

When you add information to ChartHop, you need to tell it which job or person the data belongs to. ChartHop uses the first column in a spreadsheet as the identifier, and it usually prefers that to be a person's **Work email**. You can also create your own unique identifier using a custom field. [Learn more](https://docs.charthop.com/create-a-custom-field).

:::hint{type="info"}
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](https://docs.charthop.com/exporting-data-from-the-data-sheet).
:::

:::hint{type="info"}
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](https://docs.charthop.com/working-with-custom-fields).
:::

:::hint{type="info"}
[Modules:](https://www.charthop.com/pricing/) HRIS | Engagement | Goals | Performance | Compensation Reviews | Headcount Planning
:::

:::hint{type="info"}
﻿﻿[Roles](https://docs.charthop.com/user-roles-and-permissions): Owner | Org editor
:::
