website logo
Navigate through spaces
ChartHop documentation
⌘K
ChartHop Help Center
Getting around in ChartHop
ChartHop for Employees
Implementing ChartHop
ChartHop for Administrators
Carrot reference
ChartHop for Developers
Partners
Release notes
Resources
Docs powered by archbee 
website logo

Create a spreadsheet template

You can use the Data Sheet to design a spreadsheet that you can use to upload data. On the Data Sheet, you can select the columns you want to use in your spreadsheet and then download a .csv that can serve as a template for your import. 

You need to include any required fields as columns. Required fields vary according to the type of data you are uploading. For example, when uploading data associated with an employee, you need to include the name of the employee and their manager. 

Uploading images via a spreadsheet is not supported. Be sure to deselect that column before downloading your .csv.

  1. Select Data Sheet from the left sidebar.
  2. Select Select Columns.
  3. Select the columns you want to include in your spreadsheet template in the Select Columns dialog. Be sure to unselect the image column.
  4. Select Export CSV or select the Edit ▼ dropdown and select Export CSV. The Export CSV dialog displays.
  5. In the Export type dropdown, select the Data Sheet export type.
  6. Select Export.
  7. Select Download. The spreadsheet opens in your default spreadsheet application.
  8. Delete all of the rows in the spreadsheet except for the header row. 
  9. Complete the new spreadsheet and upload it to ChartHop.

Open a Data Sheet CSV download in Excel

When you open a Data Sheet .csv download in Excel, you’re prompted with a Text Wizard to ensure the data displays correctly.

  1. Open the file you downloaded in Excel.
  2. In the Excel Text Wizard, select Delimited and select Next.
  3. Select Comma and deselect Tab, and then select Next.
  4. Select Finish.



Updated 16 May 2023
Did this page help you?
Yes
No
PREVIOUS
Add or update a hiring plan
NEXT
Spreadsheet import examples
Docs powered by archbee 
TABLE OF CONTENTS
Open a Data Sheet CSV download in Excel