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 file.

What you'll need

  • Unlimited imports are available on all plans

  • Workspace owners and admins can import data into a Workspace

  • A file in a supported format

We'll cover

  1. Supported file formats

  2. Supported fields

  3. Required fields

  4. Organize tasks into Lists before importing

  5. Data formatting requirements

  6. Next steps

Supported file formats

You can import the following file types where your data contains any number of columns and only 1 record per row:

  • Excel: .xls, .xlsx

  • Comma-separated values (CSV): .csv

  • Tab-separated values (TSV): .tsv

  • XML: .xml

  • Text: .txt

Check out 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.

Keep in mind, we have two limits for the number of Lists you can create:

  • Free Forever Plan: 100 Lists per Space

  • Unlimited Plan and above: 400 Lists per Space

After the import is complete, you can efficiently rearrange your tasks into different Folders and Lists using the Multitask 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:

  1. An existing ClickUp task field

  2. A Custom Field

  3. 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 am

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 05:30 pm

mm/dd/yy hh:mm

12 hour time

12/31/20 05:30 p.m.

Note: 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 p.m.

1609428600000

You can also use the ISO 8601 format:

Format

Date and Time

Example

ISO 8601

12/31/20 3:30 p.m. UTC

2020-12-31T13:30:00.123Z

Next steps

Review the list of 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.


Want to learn more?

Did this answer your question?