Import your work from almost anywhere with our flexible and powerful Excel & CSV import feature.
Ensure your files are prepared for import, so your team can start using ClickUp right away!
After you prepare your data file, make sure you know which supported fields you'll use in ClickUp before you import your data.
What you'll need
- Unlimited imports are available on all plans.
- Guests cannot import data into a Workspace.
- A file in a supported format.
Supported file formats
You can import the following file types where your data contains any number of columns and only one record per row:
- Excel:.xls, .xlsx
- Comma-separated values (CSV): .csv
- Tab-separated values (TSV): .tsv
- XML:.xml
- Text: .txt
Take a look at this example file to see how import files should be formatted. You may need to right-click and select Save link as to download the file.
Supported fields
You can import data into a huge number of task fields including several Custom Fields.
Check out the full list of available fields.
Required fields
The only field that is required is task name, all other fields are optional.
Organize tasks into Lists before importing
By default, tasks will be put into one List titled CSV Import.
If you have a column in your data that identifies which List the tasks should belong to, then you can map it to a List during the import process.
The number of Lists that can be created varies by plan.
After the import is complete, you can efficiently rearrange your tasks into different Folders and Lists using the Bulk Action Toolbar!
Data formatting requirements
Column headings
We do recommend including a header row, but it is optional! If you do include a heading row, each column must have a unique heading.
Column and row order
You will map your columns to ClickUp task fields during the import. Your rows can be in any order, however, you can only include one task per row.
You can match a column to:
- An existing ClickUp task field
- A Custom Field
- Or ignore the column to exclude it from your import
Dates and time formats
You can use the following date formats:
|
Format |
Example |
|---|---|
|
mm/dd/yy |
12/31/20 |
|
dd/mm/yy |
31/12/20 |
|
yy/mm/dd |
20/12/31 |
|
mm/dd/yyyy |
12/31/2020 |
|
dd/mm/yyyy |
31/12/2020 |
|
yyyy/mm/dd |
2020/12/31 |
You can specify a time by including it along with any of the above date formats:
|
Format |
Time format |
Example |
|---|---|---|
|
mm/dd/yy hh:mm |
24 hour time |
12/31/20 13:30 |
|
mm/dd/yy hh:mm |
24 hour time |
12/31/20 03:30 |
|
mm/dd/yy hh:mm |
12 hour time |
12/31/20 03:30 a.m. |
|
mm/dd/yy hh:mm |
12 hour time |
12/31/20 03:30 p.m. |
| mm/dd/yy hh:mm | 12 hour time | 12/31/20 03:30 am |
| mm/dd/yy hh:mm | 12 hour time | 12/31/20 03:30 pm |
Time data is interpreted as 24-hour time by default (00:00–23:59). To use 12-hour time, add a.m., p.m., am, or pm as shown above.
You can use Epoch/Unix/Posix date and time stamps:
|
Format |
Date and Time |
Example |
|---|---|---|
|
Unix in milliseconds |
12/31/20 3:30 pm |
1609428600000 |
You can also use the ISO 8601 format:
|
Format |
Date and Time |
Example |
|---|---|---|
|
ISO 8601 |
12/31/20 3:30 pm UTC |
2020-12-31T13:30:00.123Z |
Next steps
Supported fields
Learn about the fields available for importing so your data is meaningful and valuable once you bring it into ClickUp!
Import a data file
With a properly formatted file, including all the data you need to import your work into ClickUp, you are ready to bring your work into ClickUp.