Importing excel workbook task names into MS Project isn't working

Ms. T 0 Reputation points
2024-02-24T06:54:06.5266667+00:00

Simple Task Sheet with Headers (no spaces used only underscores in headers and sheet names)User's image

Followed steps to create new project based on Excel list. Selected the worksheet.
Note: It does not show a drop-down field for "Task Name" although it is an existing field in the default Project Gantt with Timeline View. Forced to select "Task Summary Name" instead (or option to create a generic "Text 1" field). User's image

User's image

After selecting field map, preview shows mapping as-if it exists (correct on screen) User's image

However, after clicking Next> Finish, "Task Name" does not populate to Project file. I have tried every option and solution. It will always show in "Preview" but not populate to Project field in new project file (no matter how simple the list) although ALL the other fields populated. User's image

What could I be doing wrong or is it a glitch with Microsoft Project 2019? [On a side note, why is there no tag available for Microsoft Project for as much as the application costs? I could only choose Excel?]

Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2024-02-26T02:11:03.07+00:00

    Hi,

    I suggest you post this issue to Microsoft Project forum:

    https://techcommunity.microsoft.com/t5/project/ct-p/Project

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    If the response is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.