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 Prepare your spreadsheet for import to learn how to set up your spreadsheet. Then check out Use the Spreadsheets importer for details on importing your spreadsheet into ClickUp.
Task fields
When thinking of the fields in your spreadsheet, remember each row represents a task. Each column represents a property of that task, either a task field, such as Priority, or a Custom Field.
The following task fields are supported for import:
| ClickUp task field | Description | Example of how to enter field data into spreadsheet |
| Checklist |
Import one checklist per task. It will be named Checklist. Separate tags by any delimeter, such as commas or pipes. |
checklist item 1,checklist item2 Learn more about formatting delimiters. |
| Task type |
Set task types for imported tasks. You can map the imported task types to existing or new CickUp task types. You'll need permission to create task types to add new ones during the import process. |
Milestone |
| Date created | Include the date a task was created. You can also include a time. | Learn which time and date formats are accepted. |
| Description content | Include a plain text task description. | Our team needs a more efficient way to process bug reports. |
| Due date | Set a due date for your tasks. You can also include a time. | Learn which time and date formats are accepted. |
| List (ClickUp) |
Every unique value in the List column becomes a separate ClickUp List. For example, if you add Engineering team to the List column for seven tasks, those seven tasks will be in the Engineering team List. |
Engineering team |
| Priority |
Map your task priorities to ClickUp priorities. You'll use these numeric values: 1 for Urgent priority 2 for High priority 3 for Normal priority 4 for Low priority |
2 |
| Start date | Set a start date for your tasks. You can also include a time. | Learn which time and date formats are accepted. |
| Status |
Set task statuses for imported tasks. You can map the imported statuses to existing or new CickUp statuses. You'll need permission to create statuses to add new ones during the import process. |
In Progress |
| Subtask IDs |
Use this option when your subtasks need their own properties, such as status or priority. Learn how to prepare your spreadsheet to include subtasks and nested subtasks. |
|
| Subtasks |
Use this option to create subtasks that only have a name. Add delimited subtask names into their parent task row. |
Subtask 1,Subtask 2 Learn more about formatting delimiters. |
| Tags | Separate tags by any delimeter, such as commas or pipes. |
Tag 1,Tag 2,Tag 3 Learn more about formatting delimiters. |
| Task Name | Task Name is the only required column. | Design landing page |
| Task ID | Since each row represents a task, you'll need to assign a unique ID to each row. |
Task 1 Task 2 Task 3 |
| Task assignee |
Assign tasks using the assignees' names or emails. If you use the assignees' names, you may have to map them individually to existing users. The importer is better at mapping emails to existing ClickUp users. Assignees don't have to be part of your Workspace. You can map imported users during import. |
assignee1@org.com,assignee2@org.com,assignee3@org.com Learn more about formatting delimiters. |
| Time Estimate | Include the estimated or budgeted time for each task. | Learn which time and date formats are accepted. |
| Time Tracked | Include the time tracked or spent working on a task. | Learn which time and date formats are accepted. |
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 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 (Manual) | A progress bar that's manually set. | Any numeric value from 0 to 100. |
| Rating | A numeric integer from 1–5. | 1–5 |
Text |
A single line of text. Text Custom fields have a 2,048-character limit. |
Use ClickUp to save one day a week! |
Text area (Long text) |
This is a longer paragraph of text. Text area (Long text) fields have a 50,000-character limit. |
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
- Progress (Auto)
- Relationships
- Rollup
- Signature
- Task links
- Voting