Search

Task data export

Export your task's data into a spreadsheet.

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. 

Exports of large Workspaces or Workspaces with large projects may not succeed. Try deleting tasks that are not relevant and breaking down large projects into smaller ones.

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, then select Settings. 

  2. Select Imports / Exports.

  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.

ExportWorkspaceDataExportButton.png

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

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?