Importing excel workbook data into MS Project isn't working

Tereza Murphy 1 Reputation point
2022-08-17T14:31:39.707+00:00

232024-excel-import-1.png231999-excel-import-2.png232076-excel-import-3.pngHi
When I try to import excel data into MS Project, I have to select the tab name (which I haven't had to do before if there is only one active tab), but when I try and select the data - nothing is showing.
I have cleared all formatting from the excel file, used 'Task Name', 'Start' and 'Finish' as the data headers and there are no spaces in the file name.
Any ideas, why the data fields are not displaying?

Apologies but could not work out what tags to use, so have selected something so I could post the question!
Thanks

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,563 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,654 questions
{count} votes

6 answers

Sort by: Most helpful
  1. Carey Daniel 36 Reputation points
    2023-02-06T00:54:14.39+00:00

    @Garima C - The issue is that the Excel worksheet being imported cannot have spaces in the worksheet name. Change the tab name so that it is titled Phase_1 and you will find that you are not prompted to pick a tab (assuming it is the only tab) and you will see the field choices.

    6 people found this answer helpful.

  2. Garima C 1 Reputation point
    2022-12-07T00:19:28.067+00:00

    Hey
    @Tereza Murphy did you solve your problem? I am also facing the same issue


  3. Tereza Murphy 1 Reputation point
    2022-12-12T10:04:29.917+00:00

    Hi @Garima C and @Aubrey Herring

    No, I haven't managed to sort it out. So agree, I think it must be a bug.


  4. Ira Lockwood 0 Reputation points
    2023-01-31T16:19:34.3833333+00:00

    I had the same issue. The way I worked around it was to export my Excel file in .csv format. Then project was able to import the columns correctly when I opened the .csv file. Hope that works for you.

    0 comments No comments

  5. Michal Blazejczyk 0 Reputation points
    2023-02-06T18:42:16.4733333+00:00

    Thanks, Daniel! I had the same problem; renamed the worksheet and was able to import my Excel file.

    As a side note, it's a complete joke that a piece of software that costs hundreds of dollars is unable to correctly perform the trivial task of data import, and does not even give any indication with respect to what's wrong and how to fix it... A major disappointment.

    0 comments No comments