Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership


Primavera p6 WBS grouping bands in excel

PLeae find the below Youtube link for the video how to prepare color bands of WBS in excel with one click

Export from Microsoft Project to Excel


If you have ever used Primavera P6, you would be surprised that exporting from Microsoft Project to Microsoft Excel does not provide you with a ready to be used data considering that both products are from the Royal House of Microsoft.

In Primavera P6, exports to Excel come formatted as an Excel Table for any data analysis you might want to carryout but with Microsoft Project, you still need to format the Excel properly prior to any Excel Table data analysis.

Primavera P6 export to Excel. How to color WBS level automatically

After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level.


I will show you how to color WBS level automatically so we can have report like in P6.

  • Step 1:

Follow this article to insert the "WBS Level" column :

Primavera P6 export to Excel. How to identify WBS level for activity

After export activity table from Primavera P6 to Excel, it's very hard to tell this activity belong to what WBS.



We can add 1 column to show the WBS level for each activity.

The formula for the column is : =((FIND(TRIM(B2),B2))-1)/2


Apply to the rest so we can see WBS level for each activity:



How to achieve rapid feedback progress through integrated EXCEL?

Title: "How to achieve rapid feedback progress through integrated EXCEL?"

Author: "Deyi.zhang/张德义"

Generating P6 S-Curves via Excel

A step-by-step procedure for extracting data out of Primavera to enable the generation of S-curves within Excel. Covers generating curves for planned value, earned value and actual expenditure, both in terms of manpower and cost.

Market Place

See how the TIME - LOCATION - VIEW brings clearness to your work programmes
For 25+ years, APMX has been providing competency based project management training to Fortune 500 companies around the world, applying the principles of project based learning, designed to produce measurable results, generating a favorable “return on training investment”.
Primavera P6 and Microsoft Project books, on-line video training courses and training material available from an internationally recognised publisher and PMI accredited REP. Teach yourself using on-line or book based learning or run your own in-house or public PMI accredited courses.
Syndicate content