Search

Task data export

Export your task data into a CSV file.

What you'll need

  • Free Forever and Unlimited Plans can export List view and Table view five times. 
  • Business Plan and above have unlimited access to List view and Table view exporting.
  • Business Plan and above users can also export 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. In the upper-left corner, click your Workspace avatar and select Settings. 
  2. In the All settings sidebar, select Imports / Exports.
  3. Click Export Items.
  4. On the Export page, click the Select locations dropdown and choose the locations to export. 
    • Exporting only the data you need increases the chances of your export succeeding.

    Screenshot highlighting the Select location dropdown and the Spaces section. The cursor is clicking the box to the left of a Space named Content.png
  5. Click Start Export.
  6. When the download is complete, click Download Export.
  7. Save the CSV file.
    • You'll also receive an email with a link to the CSV file. 

What is Included in an Export

The CSV export includes the following information from 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.
  • Attachments: All attachment names.
    [{"title":"sunset beach pic.png","url":"<hyperlink to file>"},{"title":"mydog.png","url":"<hyperlink to file>"}]
  • Assignees: All assignees.
    [John Smith,Mary Smith]
  • Tags: All tags.
    [tag 1,tag 2,tag 3]
  • Priority 
  • List Name  
  • Folder Name/Path: If the Folder includes subfolders, the Folder and subfolder names will be included.  
  • Space Name 
  • Time Estimated
  • Time Estimated Text
  • Checklists
  • 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 plain text. You can use a website like Epoch Converter to convert Unix timestamps to regular date/time stamps.