Import spreadsheet fields in ClickUp

When you move work from a spreadsheet into ClickUp, it is important to know exactly which columns are supported and how each field is mapped to task data. This guide walks you through the supported fields so you can prepare a clean, accurate import.

The information below is based on the official Spreadsheets importer documentation and helps you avoid errors, duplicates, or missing task details.

Before you import spreadsheet data into ClickUp

To get the best results, you should prepare your file before running the ClickUp importer. Proper preparation reduces cleanup work after the import completes.

Basic spreadsheet requirements for ClickUp imports

• Use a supported file type such as CSV or XLSX.
• Ensure that each row represents a single task.
• Add a clear header row that labels every column.
• Remove blank columns or data you do not want to import.
• Check date formats and numeric values for consistency.

Once your file is ready, you will map each column to a supported field in ClickUp during the import flow.

Core task fields supported by the ClickUp importer

Most spreadsheets include basic task information like titles, descriptions, and status. The ClickUp importer recognizes many of these common columns and converts them into core task fields.

Task name or title

This is usually the most important column in your spreadsheet. Map it to the task name field so every row becomes a recognizable task.

• Use a single column for clear, descriptive task names.
• Avoid extremely long titles by moving details to a description field.

Description field mapping

If your spreadsheet has a notes or details column, you can map it to the description field in ClickUp. This preserves important context from your original file.

• Use one main description column wherever possible.
• Combine multiple notes columns in your spreadsheet before import if you need all the information in one place.

Status field support

If you track workflow stages, you can map a status column to task statuses. During the ClickUp import, each unique value can be matched to an existing status in your Space or converted to a new one.

• Standardize your status names in the spreadsheet first.
• Ensure you do not have spelling variations that should represent the same stage.

Assignees

You can map a column of people or email addresses to assignees.

• For best results, use email addresses that match existing ClickUp users.
• If names are used instead of emails, verify that they match current member display names.

Start dates and due dates

Date columns are commonly supported fields when you import to ClickUp. You can separately map:

• Start date
• Due date
• Close or completion date, if you use one

Make sure your dates are in a consistent format, such as YYYY-MM-DD, to avoid mapping errors.

Additional supported fields in the ClickUp importer

Beyond core task attributes, the importer can map several additional fields so that your data remains meaningful after migration.

Priority

If your spreadsheet has a priority column, you can map it to the priority field.

• Normalize priorities to a simple scale such as: Urgent, High, Normal, Low.
• Check that abbreviations in your sheet match the options available in ClickUp, or adjust them before importing.

Tags

Some spreadsheets store labels or categories in a dedicated column. The importer lets you map these values to task tags.

• Use a single tag column, with multiple tags separated by commas if needed.
• Confirm that commas are not also used inside tag names.

Time estimates and numeric values

If your spreadsheet tracks estimates, story points, or other numeric indicators, you can map these columns to number fields.

• Use pure numeric values without extra characters such as “hrs” or “points”.
• Decide whether you want the column to represent minutes, hours, or another consistent unit.

Custom fields in ClickUp mapped from columns

Any column that does not match a standard task field can often be imported as a Custom Field. During the ClickUp import process, you can create or select:

• Text custom fields
• Number custom fields
• Dropdown or label fields
• Other supported custom field types depending on your plan

This lets you keep unique properties like client name, budget, or sprint ID without losing structure.

How to map spreadsheet columns to ClickUp fields

When you run the Spreadsheets importer, you will reach a field mapping step. Here is a general process you can follow.

Step 1: Start the ClickUp spreadsheet import

1. Open the workspace and location where you want new tasks to live.
2. Launch the import tool and choose the spreadsheet option.
3. Upload your CSV or XLSX file.

Step 2: Review automatic field detection

The importer may automatically match some columns to fields like task name, description, and due date. Verify each suggested mapping carefully.

• Confirm the correct column is mapped to the task title.
• Check that date and assignee columns are mapped as expected.

Step 3: Manually map remaining columns

1. For each unmapped column, open the field dropdown.
2. Choose an existing task field or create a new Custom Field.
3. Repeat the process until every important column is mapped or intentionally skipped.

Step 4: Complete and verify the import

1. Run the import and wait for ClickUp to create the tasks.
2. Open a few sample tasks to verify that fields like status, assignee, and dates are accurate.
3. Check that all Custom Fields display the expected values.

Best practices for clean ClickUp imports

Careful setup ensures that your data in ClickUp is reliable from day one.

• Remove test rows and unnecessary columns before uploading.
• Standardize text values for statuses, priorities, and tags.
• Use separate columns instead of combining multiple data types in one cell.
• Perform a small test import with a copy of your file before migrating everything.

Where to learn more about ClickUp spreadsheet fields

For the complete, official list of fields supported by the Spreadsheets importer, review the original documentation on the ClickUp Help Center:

Fields supported by the Spreadsheets importer

If you want expert help planning large migrations, data structure, or workflow design around ClickUp, you can also explore consulting resources like Consultevo, which specializes in productivity and work management platforms.

By understanding exactly how spreadsheet fields map into ClickUp, you can run smoother imports, preserve critical task data, and keep your teams productive without manual rework.

Need Help With ClickUp?

If you want expert help building, automating, or scaling your ClickUp workspace, work with ConsultEvo — trusted ClickUp Solution Partners.

Get Help

“`