This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I have an existing MS Project mpp file.
I have an Excel Spreadsheet with task durations that I want to import into the existing mpp file.
I have both the Task Name and Work field names in the Excel file matching those (native) defaults in the mpp file.
When I try to use the MS Project Import Wizard, I select New Map and then "Merge the data into the active project" since I want to keep everything in the mpp file as is except for updating the Work fields.
I then select Tasks as the type of data for import and specify the import includes headers.
In the Import Wizard Task Mapping dialog I then select the desired worksheet.
Everything in the "From: Excel Field" shows up correctly.
When I scroll down, I can see that the wizard correctly mapped "Work" in the Excel file to "Work" in the mpp.
However, it does not map the Excel "Task Name" to anything.
This should be mapped to "Task Name" in the mpp.
When I try to manually select "Task Name" in the "To: Microsoft Project Field" the option for "Task Name" is not present.
So, I cannot map the Task Name and hence can't Set Merge Key to Task Name.
What am I doing wrong here?
Thank you in advance!
Chris
Microsoft project management software used to plan, manage, and communicate a project schedule and other information among workgroup members, project managers, and other stakeholders.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 92%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Chris Minerva,
What you are doing wrong is looking for a field called Task Name. The field you want is simply "Name", the "task" is assumed by Project since you are mapping into a task based view.
I'll caution you on something though. In Project all time related data is in minutes, so you will need to express duration and work as minutes in Excel in order for Project to accept your Excel data as intended.
Hope this helps.
John
Chris,
You're welcome and thanks for the feedback.
John
OK, that makes sense. Thank you for the detailed explanation, John. I'm just coming back to using Project again after many years and this is the first time I'm trying to setup a workflow that exports from Excel to Project. *sweat* :-)