website logo
Navigate through spaces
ChartHop documentation
⌘K
ChartHop Help Center
Getting around in ChartHop
ChartHop Video Library
Navigating ChartHop
Home page
Org Chart
Map
Data Sheet
Employee Profiles
Implementing ChartHop
ChartHop implementation overview
Creating your ChartHop org
Configuring your Org settings
Inviting users and setting permissions
Permissions and security
Creating and managing groups
Integrations and bundles
ChartHop for Administrators
Planning
Managing employee data
Creating reports and analytics
Managing people and jobs
Performance reviews
Building custom forms, tabs, and documents
ChartHop for Developers
ChartHop connect
Developer basics
Events
Syncing data to/from ChartHop
Partners
Sequoia getting started
Resources
Available ChartHop packages
ChartHop Standard Terms and Conditions
ChartHop Basic Agreement
Data Processing Addendum
Privacy policy
Security statement
Subprocessors
FAQ
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 Dec 2022
Did this page help you?
Yes
No
UP NEXT
Spreadsheet import examples
Docs powered by archbee