• Dp

Export The Primavera Project to Excel With The Exact Format (Look alike)

Updated: May 11, 2018

In the earlier posts, we have already seen  how to export the primavera schedule into the excel format and then do the  modifications for further usage. Now, let us see how the schedule in excel looks similar to that of the schedule in the primavera.



Here are the steps for the trick:

Step-1:

Open the project in the primavera p6.


Step-2:

Now, the sample schedule in primavera looks like this as shown below


Step-3:

Now Press Ctrl+A to select all the rows and columns in the primavera schedule  and Copy all the selected data


Step-4:

Now go to an excel sheet and right click and select "Paste" option to paste the data that has been copied from the primavera screen.


Step-5:

Insert a user defined column "Level" for filtering purpose and apply filters to all the data. and then filter the Column "Activity name" by checking the "Blanks"-This is nothing but we are filtering all the WBS rows and excluding the activities.




Step-6:

Now, in the column "Level" type the formula in the first cell as "=Find(trim(C4),C4)" an drag the formula so as to apply for all the WBS items.


Step-7:

Now Similar to the Primavera coloring, color the rows in the excel sheet based on the level of WBS as it is.


Repeat this step for all the rows in the excel sheet as similar to the primavera screen.


And now, finally the Schedule in Excel sheet should look similar to that of the primavera as shown below.

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at dptutorials15@gmail.com

Support my blog, if you liked

  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon
  • Google+ Social Icon
  • Blogger Social Icon