These ClickUp fields are supported when importing your data using the Spreadsheet importer.
Feature availability and limits vary by plan and user role. Learn more
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 |
|
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. |
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. |
|
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 is the only required field. |
Create a bug-reporting form |
|
|
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 |
|
|
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 |
|
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 |
|
|
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 |
|
To import tasks into separate Lists, use this column to group tasks in different Lists in ClickUp. |
Engineering team priorities |
|
|
Map your task priorities to ClickUp priorities.
1 = Urgent 2 = High 3 = Normal 4 = Low
Custom priorities are not available in ClickUp. |
2 |
|
Separate tasks by any delimiter you choose such as commas or pipes. |
tag 1, tag 2, tag 3 |
|
Include the estimated or budgeted time for each task. |
1 hour 2 hr 30 m 01:30 |
|
Include time tracked or spent working on a task. |
1 hour 2 hr 30 m 01:30 |
|
Import the task types your team uses. |
Milestone User story Key result |
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 |
Description |
Example |
| Checkbox | A true or false checkbox. |
true/false t/f 1/0 checked/unchecked Case does not matter. |
Date |
A custom date and time. |
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 |
A formatted email address. |
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 |
A formatted amount of money. |
15.20 |
Number |
A formatted numeric value |
1234 |
Phone |
A formatted phone number with area code. |
(212) 555 1234 An area code is required to import data into a phone number Custom Field. |
| Progress | A progress bar that's manually set. | It starts at 0 and can be updated from 10–100. |
| Rating | A numeric integer from 1–5. | 1–5 |
Text |
A single line of text. |
Use ClickUp to save one day a week! |
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. |
Use ClickUp to save one day a week! Use ClickUp AI to help you make this text into a longer paragraph. |
Website |
The URL of any website. |
https://clickup.com |
Unsupported Custom Fields
These Custom Fields are not currently supported for use with the Spreadsheets importer:
- Button
- Files
- Formula
- Location
- People
- Relationships
- Rollup
- Signature
- Voting