I understand wanting to have a well formatted schedule in Excel.



What I have done in the past is include all the columns I need; Unique ID, Task Name, % Complete, Duration, Start Finish.

I also add the columns Outline Level and Summary. I then use the Outline level column in Excel to create a formula for indentation. I use the Summary column to have a conditional format that will change the color and bold all my summary task rows.

I've attached an image so it makes better sense. You can see in the formula bar the formula I used for the task name with indentation.

This makes a great difference for my users.

Attached Images

Project Data Pasted into Excel.png (99.1 KB, 19 views)

Thank you so much for that advice. That is very helpful. I am very surprised that there is not a very simple way to export to Excel that automatically gives a really clean format. In most of my projects, the major objection I get about using MS Project is this one issue.