After exporting the activity table from Primavera P6 to Excel, it’s very hard to identity the level of the WBS structure.
This article describes how to identify the WBS level.
The first step is to add one column to show the WBS level and enter the following formula to this column:
Copy the formula to all the rest of the rows:
Finally, the WBS can show its level.