Others

Fix Microsoft Project Import Wizard Not Mapping Assignments When Appending Excel Data

Bushra Parveen Sep 25, 2026 872 views

Question details

The user needs to successfully import and map tasks, resources, and assignments from Excel into Microsoft Project without losing assignment links.

How to Fix Microsoft Project Import Wizard Not Mapping Assignments When Appending

Product: Microsoft Project
Device & OS: not provided
Scenario: Appending or merging Excel data sheets containing tasks, resources, and assignments into an existing Project file.
Observed behavior: Resources are imported into the Resource Sheet but fail to be assigned to the corresponding existing tasks when appending to an active project.

Before you start

Ensure your Excel workbook is correctly formatted with clear columns for Tasks, Resources, and Assignments before attempting the import process.

Solution 1Recommended

Import Excel Sheets into a New Project File

Since appending to an existing project breaks assignment mapping, the primary workaround is importing the data into a brand-new project file simultaneously.

This method avoids the appending bug entirely by initializing the task and resource relationships during the creation of a new project file.

Open a blank project

Launch Microsoft Project and start a completely blank project file.

Start the import process

Navigate to File > Open, locate your Excel file containing the project data, and select it.

Select new project option

When the Import Wizard appears, choose the option to import the data 'As a new project' instead of appending or merging.

Map your data

Proceed through the wizard to map your Tasks, Resources, and Assignments sheets concurrently, then click Finish.

Import Excel Sheets into a New Project File

Workaround Limitation: Because this method creates a new project file, you may need to manually copy over any custom views, calendars, or project-level settings from your original file.

Solution 2

Submit a Bug Report to Microsoft Support

If importing into a new project does not meet your workflow needs, you will need to escalate this known appending issue to Microsoft Support.

Free Microsoft Office alternative

Manage Project Data Seamlessly with WPS Office

While Microsoft Project may experience import mapping issues, you can manage your task and resource data efficiently using WPS Spreadsheet. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office that ensures your data remains intact across platforms.

1. Download WPS Office: Download and install the free WPS Office suite from the official website.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet to open and edit your project management Excel files.
3. Manage Project Data: Enjoy seamless compatibility and formatting preservation for all your task and resource tracking needs.

Fully compatible with Microsoft Excel (.xlsx) formats for uninterrupted project data management.Lightweight architecture ensures fast loading and smooth handling of large task and resource datasets.Familiar user interface makes transitioning to WPS Office completely seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my resources not assigning to tasks when importing from Excel into Microsoft Project?

When appending or merging data into an existing Microsoft Project file, a known software limitation prevents the Import Wizard from properly mapping resource assignments to existing tasks, even though the resources are added to the Resource Sheet.

Can I manually assign resources after appending the data?

Yes, you can manually assign resources to tasks using the Resource Sheet and Task views. However, for large projects, this can be highly time-consuming, making it faster to import the data into a new project file instead.

What data should I prepare before contacting Microsoft Support about this issue?

You should gather your specific Microsoft Project version number, the exact structure of your Excel workbook, and sample data for tasks, resources, and assignments to help the support team reproduce the appending issue.

Office Quick Solutions