Task data export

Export your task's data in a comma-separated value (CSV) format.

What you'll need

  • Free Forever and Unlimited Plans can export List view and Table view five times to CSV and Excel. 
  • Business Plan and above have unlimited access to CSV List view and Table view exporting.
  • Business Plan and above users also have the option of exporting select data using List view export

Export your task data

A Workspace admin or owner can export data from ClickUp by doing the following:

  1. Click your Workspace avatar located in the upper-left corner, then select Settingsand go to the Import/Export page.

  2. Select Import/Export.

  3. Click Start Export.

  4. It will take a few minutes for your export to be ready. When the download is complete, click the Download Export button.

Image of the import/export page

Task data export emails include a link to download your data! This link is only active for one hour after the export completes.

What is Included in an Export

The format of the CSV export includes the following information on the tasks in your Workspace: 

  • Task ID

  • Task Custom ID

  • Task Name 

  • Task Description (included under the Task Content heading)

  • Status

  • Date created

  • Date created Text

  • Due date 

  • Due date Text

  • Start date

  • Start date Text

  • Parent ID: Included for subtasks.

  • Attachment array: All attachment names.
    [{"title":"sunset beach pic.png","url":"<hyperlink to file>"},{"title":"mydog.png","url":"<hyperlink to file>"}]

  • Assignees array: All assignees.
    [John Smith,Mary Smith]

  • Tags array: All tags.
    [tag 1,tag 2,tag 3]

  • Priority 

  • List Name  
  • Folder Name 
  • Space Name 
  • Time Estimated
  • Time Estimated Text
  • Checklists
  • Task Comments
  • Assigned Comments: Total number of assigned comments.
  • Time Spent
  • Time Spent Text
  • Rolled Up Time
  • Rolled Up Time Text

Dates and Time fields are included in both unix format and in plain text. You can use a website like Epoch Converter to convert unix timestamps to regular date/time stamps.

Was this article helpful?