Fields supported by the Spreadsheets importer

These ClickUp fields are supported when importing your data using the Spreadsheet importer.  

Prepare your spreadsheet and import your data

Take a look at our article Use the Spreadsheets importer for details on importing your spreadsheet into ClickUp. During your preparation, you may also want to see which ClickUp fields are supported by our importer. 

Task fields

The following task fields are supported for import:

Field

Description

Example

Add as new field

 

 

Checklist

Import one checklist per task that will be named Checklist.

 

Separate checklist items by any delimiter such as commas or pipes.

checklist item 1, checklist item 2, checklist item 3

 

checklist item 1 | checklist item 2 | checklist item 3

Date created

Include the date a task was created. A time can also be included.

12/12/2025

12/12/2025 03:30

12/12/2025 03:30 pm

You can also use Epoch/Unix/POSIX date and time stamps or the ISO 8601 format.

Due date

Set a due date for your tasks. A time can also be included.

1/1/2025

1/1/2025 03:30

1/1/2025 03:30 pm

You can also use Epoch/Unix/POSIX date and time stamps or the ISO 8601 format.

Start date

Set a start date for your tasks. A time can also be included.

1/1/2025

1/1/2025 03:30

1/1/2025 03:30 pm

You can also use Epoch/Unix/POSIX date and time stamps or the ISO 8601 format.

Task name

Task name is the only required field.

Create a bug-reporting form

Status

Add your task statuses to your data. 

You'll need to map the imported statuses to statuses that exist in the Space you selected. 

If you want new statuses, you must add them before importing.

In Progress

Subtasks

Add a column for subtasks in your CSV file with a list of subtask titles to be created in each task you import. Separate them with any delimiter you like.

Nested subtasks are not supported. You can import them as subtasks and convert them to nested subtasks using the Bulk Action Toolbar.

Subtask 1, Subtask 2, Subtask 3

Description content

Include a task description with your import. Only plain text will be imported.

Our team needs a more efficient way to process bug reports so let's create a form to capture them

Task assignee(s)

Assign tasks using the assignees' email addresses. The assignees do not have to be part of your Workspace at the time of import. 

You must use a delimiter like commas or pipes and each address in the column must be in its own row. 

During the import process, you'll be able to map imported users into ClickUp users.

Assignee1@org.com,

Assignee2@org.com, 

Assignee3@org.com

 

Assignee1@org.com |

Assignee2@org.com |

Assignee3@org.com 

List (ClickUp)

To import tasks into separate Lists, use this column to group tasks in different Lists in ClickUp.

Engineering team priorities

Priority

Map your task priorities to ClickUp priorities.

 

1 = Urgent

2 = High

3 = Normal

4 = Low

 

Custom priorities are not available in ClickUp.

2

Tags

Separate tasks by any delimiter you choose such as commas or pipes.

tag 1, tag 2, tag 3

Time Estimate

Include the estimated or budgeted time for each task.

1 hour

2 hr 30 m

01:30

Time tracked

Include time tracked or spent working on a task.

1 hour

2 hr 30 m

01:30

Summary

?

?

Members

?

?

Task Type

Import the task types your team uses. 

Milestone

User story

Key result

Location fields cannot be imported at this time.

Custom Fields

You can create a new Custom Field or map to an existing Custom Field during the import process 

The following Custom Field types are supported:

Custom Field type

Example

Date

Refer to our supported date and time formats.

Dropdown (include multiple options with any delimiter such as commas or pipes)

Option 1, Option 2, Option 3

Option 1 | Option 2 | Option 3

Email

user1@company.com

Labels (include multiple labels with any delimiter such as commas or pipes)

Label 1, Label 2, Label 3

Label 1 | Label 2 | Label 3

Money

15.20

Number

1234

Phone


An area code is required to import data into a phone number Custom Field.

(212) 555 1234

Text

This is a single line of text.

Text area (Long text)

This is a longer paragraph of text. It will be imported into ClickUp to add context to the task. Due to the specialized nature of this text, it needs to be imported into a custom field.

Website

https://clickup.com

Was this article helpful?