Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Export to Excel

2 replies [Last post]
moutaz aldeib
User offline. Last seen 3 weeks 6 days ago. Offline
Joined: 31 Dec 2003
Posts: 281
Groups: None

Greetings Planners,

I am exporting project to excel from P6, the project includes 4 levels of WBS and when I export the project to Excel, it considers only the last level, how can I show all levels in Excel?




Santosh Bhat
User offline. Last seen 1 day 13 hours ago. Offline
Joined: 15 Apr 2005
Posts: 314
Moutaz, From within P6, in your activity view, select all activities (CTRL+A) l, then copy to your clipboard (CTRL+C) and then just paste into excel. this will retain.th3 grouping you're displaying if you need to keep the activity ids aligned, here is a quick tip i wrote recently:
Mohammed Ali
User offline. Last seen 3 days 12 hours ago. Offline
Joined: 16 Mar 2018
Posts: 53
Groups: None

Hi Moutaz

You can use the WBS Magic Tool, it's an amazing tool to display, modify and export the WBS between excel and Primavera.

This is the link: