Sometimes it is useful to copy and paste schedule information from Primavera P6 to excel in wbs format.
Howerver, whenever you paste information from P6 into excel the color fomatting and the ability to group by wbs doe snot carry over.
There is an excel wbs add in utility that can color your wbs and add the ability to exapnd and or collapse the wbs and inforamtion.
This is a handy utility so that other people who do not have Primavera P6 or who do not know how to use P6 can use excel to view schedule information in a wbs format coloring and grouping similiar to P6.
Here is a link to the excel add-in uility.
https://planlamamuhendisi.com/wbs-organizer.html