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 select data sheet from the left sidebar select select columns select the columns you want to include in your spreadsheet template in the select columns dialog be sure to unselect the image column select export csv or select the edit ▼ dropdown and select export csv the export csv dialog displays in the export type dropdown, select the data sheet export type select export select download the spreadsheet opens in your default spreadsheet application delete all of the rows in the spreadsheet except for the header row 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 open the file you downloaded in excel in the excel text wizard, select delimited and select next select comma and deselect tab , and then select next select finish