Others

How to Fix Task Name Missing in Microsoft Project Import Wizard

Maira Mehtab Sep 28, 2026 869 views

Question details

The user is trying to map task names during an import process but cannot find the 'Task Name' field in the Microsoft Project Import Wizard.

Product: Microsoft Project
Device & OS: not provided
Scenario: Importing task data from an Excel spreadsheet into Microsoft Project using the built-in Import Wizard.
Observed behavior: The 'Task Name' field is missing from the list of available Microsoft Project fields, preventing the user from mapping the task name column correctly.

Before you start

Ensure your source Excel spreadsheet is properly formatted with clear column headers before initiating the data import process in Microsoft Project.

Solution 1Recommended

Map the Excel Column to the 'Name' Field

Resolve the missing field issue by mapping your Excel task name column directly to the underlying database field called 'Name' in Microsoft Project.

Microsoft Project distinguishes between underlying database field names and display titles. While 'Task Name' is the column title commonly seen in task views (like the Gantt Chart), the actual underlying field is simply called 'Name'.

Because the Import Wizard reads the underlying field names rather than contextual display titles, you will not find 'Task Name' in the mapping list. In resource views, this exact same field is titled 'Resource Name'.

Open the Import Wizard

Launch Microsoft Project, go to File > Open, select your Excel file, and start the Import Wizard.

Proceed to Field Mapping

Follow the wizard prompts until you reach the Task Mapping step where you align your Excel columns with Project fields.

Locate the 'Name' Field

In the 'To: Microsoft Project Field' dropdown list, look for and select the field titled 'Name' instead of searching for 'Task Name'.

Complete the Import

Verify your other column mappings and click 'Finish' to successfully import your task data into Microsoft Project.

Importing Time-Based Values: When importing duration or work values alongside your task names, ensure they use the correct Project units. Microsoft Project stores all time-based data internally in minutes.

Free Microsoft Office alternative

Manage Project Data Seamlessly with WPS Office

If you find Microsoft Project's database mapping and field terminology overly complex, consider organizing your project timelines using WPS Spreadsheet. It offers a user-friendly interface and robust formatting without steep learning curves.

1. Download the Installer: Visit the official WPS Office website and click the Free Download button.
2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions.
3. Open WPS Spreadsheet: Launch WPS Spreadsheet and select a project management template to start tracking your tasks immediately.

Free, lightweight, and incredibly easy-to-use office suite.Seamless format compatibility with Microsoft Excel (XLSX, XLS).Built-in templates for project management, trackers, and Gantt charts.No complex database field mapping required for basic project scheduling.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the column title change between Task Name and Resource Name?

In Microsoft Project, the underlying database field is always called 'Name'. The software automatically updates the displayed column title depending on your current view to provide better context, showing 'Task Name' in task-based tables and 'Resource Name' in resource-based tables.

How does Microsoft Project store duration and work data?

Project stores all time-based data internally in minutes. When importing duration or work values from an external file like Excel, you must ensure that your data is mapped to the correct Project units so scheduling calculations remain accurate.

Can I create a custom field called 'Task Name' to bypass this issue?

It is not recommended to create a custom text field named 'Task Name' for your imports. Doing so separates your imported data from Project's core scheduling engine, meaning your tasks won't behave properly in the Gantt chart. Always map task names to the built-in 'Name' field.

Office Quick Solutions