---
sourceDocument: Australia Strategic Portfolio Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/it-business-management

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Strategic Portfolio Management

ft:clusterId :

    - itbm

bundleId :

    - itbm

workflow :

    - Technology


---

# Import project tasks for multiple projects

# Import project tasks for multiple projects {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
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 AllSystem Import SetsLoad 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.
5. **Optional:** 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. **Optional:** Create field mappings for custom columns.  
   For more information, see [Create field
   mappings](https://www.servicenow.com/docs/access?context=c_MappingOptions&version=australia&pubname=australia-integrate-applications&ft:locale=en-US).
8. Transform the data from the import set table to the target table.  
   For more information, see [Run an import](https://www.servicenow.com/docs/access?context=t_RunImport&version=australia&pubname=australia-integrate-applications&ft:locale=en-US).
**Related concepts**   

* [Project import from Microsoft Project](https://servicenow-prod.fluidtopics.net/F7VVZSmNFHuVSuHyHF~uLw "Import Microsoft project files into the ServiceNow Project Management application.")
* [Project export to Microsoft Project](https://servicenow-prod.fluidtopics.net/IyjMcF9FkPfd2HoqlznGJA "If you are using Microsoft Project to manage project activities, you can export a project to Microsoft Project (mpp) file, an XML file, or a CSV file.")
* [Calendars and schedules- Limitations](https://servicenow-prod.fluidtopics.net/iLy0352Uq4BOwaIkShn7Cg "Some calendar elements from Microsoft Project are not imported into the Project Management application.")
* [Importing and exporting projects](https://servicenow-prod.fluidtopics.net/Udes11Am4GzGZ2tx2zScLg "You can manage projects using both Microsoft Project and the ServiceNow Project Management application.")  
**Related tasks**   

* [Create custom field mapping for Microsoft Project import](https://servicenow-prod.fluidtopics.net/LzaLxEre4FdPojc3oz9xaQ "Map custom fields from Microsoft Project to ServiceNow fields before importing a project.")  
**Related reference**   

* [Project field mapping](https://servicenow-prod.fluidtopics.net/slBSKQEC_Hsu9Em7KEAZNQ "During an import, values from Microsoft Project overwrite fields in project records.")

*[\>]: and then


