---
title: Connecting bands to jobs
slug: connecting-bands-to-jobs
createdAt: 2022-05-23T17:34:49.000Z
---

After you create compensation bands, you can assign each job in your organization to a band by uploading a spreadsheet that maps your existing employees to the band to which they belong. This method allows you to map all of your jobs to bands at the same time.

Alternatively, you can associate an individual job with a band by selecting **Edit Job**, selecting the **Compensation **tab, and selecting a band from the dropdown list.

:::hint{type="warning"}
Compensation bands can display in the job details for those with the appropriate sensitivity access. If your organization previously entered bands without the use of the Compensation Band wizard, you'll see a **Band (legacy)** field when editing a job. This field is for information only and you cannot be edited.
:::

### Create a job-band mapping spreadsheet

You'll need a list of the work emails associated with each job you want to map, as well as which band applies to each job. You can also map to a job ID instead of a work email if you want to add a band to an unfilled job.

To create your spreadsheet:

1. Create a spreadsheet (.csv or .xlsx) that includes the following two columns: 
   - An identifier column (for example, work email or job ID)
   - A column named `compBand`
2. Add a row for each job you want to connect to a band and add values for both the job (work email or job ID) and the compBand.  

### Upload your spreadsheet

After you've created a spreadsheet to help you map your jobs to the bands you created, upload the spreadsheet to ChartHop to complete the mapping. You can make any individual changes by editing the respective job.

1. From the left sidebar, select **Data Model**
2. From the sub-menu, select Job Architecture > **Compensation Bands**.
3. Click **Edit** in the top right corner.
4. In the **Map your jobs to your band levels** section, select **Upload mapping**.
5. Select **Save Settings**.

### Verify that your bands are mapped

You can use the **Data Sheet** to verify that you've mapped your bands to their respective jobs.

To verify bands are mapped:

1. From the left sidebar, select **Data Sheet**.
2. Select **Select columns**.
3. In the **Select columns** dialog, select the checkbox for the **Comp Band** field. 
4. Select **Apply**. This displays compensation bands on the **Data Sheet** as a column.
5. Review the rows to view band information for employees and open jobs.

:::hint{type="info"}
Once you've configured your compensation bands, you can also create custom field mappings with our help to export your compensation bands to your external systems. For more information, please reach out to your ChartHop Customer Success Manager.
:::

:::hint{type="info"}
**[Packages](https://www.charthop.com/pricing/):&#x20;**<font color="#a9a9a9">Basic</font> <font color="#000000">|</font> <font color="#000000">**Standard\*** | **Premium**</font>****

\* Available as an add-on
:::

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