Forum Discussion

Tahawai's avatar
Tahawai
Copper Contributor
Dec 20, 2023

Importing Excel while maintainging Summary (Rollup) Tasks

Hi All 

 

Can I import Summary (Rollup) tasks to MS Project if the data is in Excel?

 

I have an Excel spreadsheet - It's an output from a Builder's scheduling tool, it's not great, I won't name names but the only extract I get is a task list ID, Name, Dates, Resources, Predecessors and the Coulumn  for the task info also includes the rollup task name that the task belongs to, they refer to it as 'Phase' I can't see a way to import to into MS Project and create a hierarchical view

 

Thanks for any assistance 

Regards

Alex

  • Dale_HowardMVP's avatar
    Dale_HowardMVP
    MVP
    Dec 20, 2023
    Tahawai --

    Yes, this is possible. What you will need to do is to add a column named Outline Level in the Excel workbook. If the summary tasks represent Phases, as you mention, then you should set the Outline Level value to 1 for those summary tasks. For the subtasks that appear below the summary task in question, set the Outline Level value to 2. Save those changes to the Excel workbook, and then you should be able to import those tasks from the workbook into your Microsoft Project schedule. Hope this helps.

Resources