Import project tasks for multiple projects

---
title: Import project tasks for multiple projects
description: Import project tasks for multiple projects from an external file system or data source using import sets and transform maps.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/it-business-management/project-management/import-project-tasks-multiple-projects.html
release: australia
product: Project Management
classification: project-management
topic_type: task
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Importing and exporting projects, Using Project Management, Project Management, Project Portfolio Management, Strategic Portfolio Management]
---

# Import project tasks for multiple projects

Import project tasks for multiple projects from an external file system or data source using import sets and transform maps.

## Before you begin

Role required: import\_transformer, import\_admin, or admin

## Procedure

1.  Navigate to **All** > **System Import Sets** > **Load Data**.

2.  Select the **Existing table** option.

3.  From the Import set table list, select the **Import planned task \[imp\_planned\_task\]** option.

4.  In the **Source of the import** field, select File, and then select **Choose File** to select the source Excel spreadsheet.

    \[Omitted image "import\_task\_file.png"\] Alt text: Import task file configuration form

5.  If required, specify the Work sheet and Header row number.

6.  Select **Submit**

    The imported data is available in the selected Import Set table.

7.  Create field mappings for custom columns.

    For more information, see [Create field mappings](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/integrate-applications/c_MappingOptions.md).

8.  Transform the data from the import set table to the target table.

    For more information, see [Run an import](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/integrate-applications/t_RunImport.md).


**Parent Topic:**[Importing and exporting projects](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-business-management/project-management/c_ProjectImportAndExport.md)

**Related topics**  


[Project field mapping]()

[Map custom fields for Microsoft Project import]()

[Project import from Microsoft Project]()

[Project export to Microsoft Project]()

[Calendars and schedules- Limitations]()

[Importing and exporting projects](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-business-management/project-management/c_ProjectImportAndExport.md)