How to start a CSV import

  1. Go to your settings  
  2. Click Import/Export  (you must be an admin or owner)
  3. Click CSV file and follow the steps in the video! 

Frequent Questions

Can I import tasks into a Project? List?
By default, you'll select a Space  to import the tasks into, and we'll create a new Project titled CSV Import  with your imported tasks. After the import, you can move tasks around as you please.

Also by default, we'll import them into just one list  but if you prefer separating your tasks, you can opt to map a column named List  during your import. Doing this will separate your imported tasks into multiple lists. 

Does my file need to be in any specific format?
Nope, not really! You can have as many columns as you want and in whatever order you want. You'll be able to map the columns with our importer feature. 

Can I import excel files?
Sure! But you'll need to first save the Excel file as a CSV. To do this, click File  then Save as  then select csv  from the filetype  dropdown. 

Do my columns need to be in order?
Nope! You can map them in step 2. 

Can I import statuses?
Yes! Simply select which column is your status column and on the final step, you'll be able to map imported statuses as ClickUp statuses. 

Can I import assignees?
Absolutely! On the last step you'll be able to map imported users into ClickUp users. You can even choose to create new ClickUp users or simply not import users.

Can I import cells with multiple values such as tags?
Yes! On the final step, you'll be able to specify a delimiter (such as comma) that separates your values. For example, you could have:
tag 1, tag 2, tag 3  Delimiter = comma (,)
tag 1 | tag 2 | tag 3  Delimiter = pipe (|)
BOTH of these will be accepted, you'll just need to ensure you specify which delimiter you're using on the last step of the import process. Again, you can use ANY delimiter you want.  

Can I import checklists?
Yep! You can import one checklist per task. The checklist items should be separated by any delimiter you want, and in one cell. 

Columns accepted

Task name
Task title (name)

Description content
Only plain text will be imported

Task assignee(s)
Email address(es) of the people that are assigned to the task (for multiple assignees, use a delimiter such as commas or pipes)

List (ClickUp)
To import tasks as separate projects or lists, use this column to group tasks in different Lists in ClickUp.

Due date
We accept most common date formats

Priority
Map priorities to ClickUp priorities (1 = Urgent, 2 = High, 3 = Normal, 4 = Low)

Tags
Separate tasks by any delimiter you choose (such as commas or pipes)

Time estimate
Time estimate or budgeted (we accept readable times such as "1 hr" or you can use HH:MM)

Time logged
Time tracked or logged working on a task (we accept readable times such as "1 hr" or you can use HH:MM)

Checklist
Import one checklist (that will be named "Checklist") containing checklist items separated by any delimiter such as commas or pipes. 


Note: We have an example file if you'd like to see how import files should be formatted.

Did this answer your question?