Data Import & Export

Fix Microsoft Project Import Merge Not Adding New Excel Tasks

Emma Brown Oct 23, 2026 869 views

Question details

Users are experiencing an issue where importing an Excel data file into Microsoft Project using a merge key successfully updates existing tasks but fails to append new tasks.

How to Fix Microsoft Project Import Merge Not Adding Excel Tasks

Product: Microsoft Project / Excel
Device & OS: not provided
Scenario: Importing and merging an updated Excel task list into an existing Microsoft Project schedule.
Observed behavior: During the data import, existing tasks are updated according to the merge key, but any newly added tasks in the Excel file are ignored and not added to the project.

Before you start

Ensure that your Excel file is not locked for editing and that the designated merge-key column contains unique, non-blank values for every task row.

Solution 1Recommended

Test with a Clean Project File to Isolate the Issue

Perform a test in a new Microsoft Project file to determine if the problem is specific to your current project file, the Excel data, or a system-wide application setting.

Sometimes, corruption within the specific Microsoft Project file or hidden formatting issues in the Excel source file can prevent new tasks from appending. Testing in a fresh environment helps isolate the exact cause.

Identify your merge key

Check your current import mapping to identify exactly which field (e.g., Unique ID or Task Name) is being used as the merge key.

Create a new project

Open Microsoft Project, create a new blank project file, and manually add a few sample tasks.

Export and modify data

Save the new project and export those sample tasks to a new Excel file. Open the Excel file, modify a few of the existing tasks, and add at least one entirely new task row.

Run the test import

Import the modified Excel file back into your new Microsoft Project using the 'Merge the data into the active project' option.

Test with a Clean Project File to Isolate the Issue

Interpreting Results: If the new task is added successfully during the test, the issue lies with your original project file or its specific import map. If it fails again, you may need to check for recent Microsoft Project software updates that might have introduced an import bug.

Solution 2

Verify Import Map and Merge Key Integrity

Ensure that your import map is correctly configured and that the Excel data strictly adheres to the data types required by Microsoft Project.

Free Microsoft Office alternative

Manage Task Data Seamlessly with WPS Office

While Microsoft Project handles complex timeline scheduling, preparing and managing your underlying task data is best done in a reliable spreadsheet program. WPS Office offers a free, lightweight suite that is fully compatible with Microsoft Excel formats, ensuring your data is perfectly formatted before importing it into any project management tool.

1. Download and install: Get WPS Office for free from the official website and install it on your device.
2. Open your task list: Launch WPS Spreadsheet and open the Excel file containing your project tasks.
3. Format data for import: Easily clean up your merge keys, remove blank rows, and save the file as a standard .xlsx format to ensure a smooth import process into Microsoft Project.

Highly compatible with Microsoft Excel (.xlsx and .csv) formatsLightweight and fast, ideal for formatting large task listsFree alternative with a familiar, easy-to-use interfaceSeamless transition with zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does the merge key update existing tasks but not append new ones?

This usually happens if the Excel rows for the new tasks are missing critical data fields required by Microsoft Project, or if the Import Map is configured in a way that it doesn't recognize the new rows as valid task entries.

What is the best field to use as a merge key in Microsoft Project?

The 'Unique ID' field is the most reliable merge key. Task names can change or be duplicated, which confuses the import engine, whereas the Unique ID remains constant for existing tasks and is safely distinct for appended tasks.

Does the Excel file format affect the Microsoft Project import process?

Yes, older Excel formats (.xls) or poorly formatted CSV files might cause parsing issues in newer versions of Microsoft Project. Saving your file as a standard .xlsx workbook before importing is highly recommended.

Excel & Data Problems