Prepare a data file for import

Import your work from almost anywhere with our flexible and powerful Excel & CSV import feature.
Screenshot of someone importing a file into ClickUp.png

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

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:















You can specify a time by including it along with any of the above date formats:


Time format


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:


Date and Time


Unix in milliseconds

12/31/20 3:30 pm


You can also use the ISO 8601 format:


Date and Time


ISO 8601

12/31/20 3:30 pm UTC


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.


Was this article helpful?