Primavera P6 to MS Excel, Manpower Histogram and Plans in Excel – Templates

How to get Primavera P6 to Excel as It is? | WBS Levels Colors | Video Explanation

It is a widespread question, planners/schedulers used to convert P6 to PDF & then PDF to excel, but it is all messy. Here, I will show you how to do it in a clean & effective way.

I have included one column at the extreme right of the excel sheet. Normally it would help if you kept it hidden. It uses the Trim & Length formula with a bit of customization. The idea is to calculate the Trim values & then put conditional formatting to make the color per your convenience.

Here is the formula: =IF(C2=””,0.5*(LEN(B2)-LEN(TRIM(B2))),0)

I have applied all up to 4000 rows. But if you need more, drag it to that level – This will only take its values from Activity IDs.

It would help if you opened Primavera P6…..> Click on any activity, then select all (Ctrl+A) & the Ctrl+C. Now paste it into excel by putting the courser at the “Activity ID” box.

Note: You can watch a video explanation here  Primavera P6 to MS Excel 

Here is the MS Excel Sheet for Primavera P6 to Excel – WBS Layout colorwise

Primavera P6 to MS Excel


One Small Request:

If you have liked reading content, kindly give it a share. Your share is beneficial to me. Or at least comment below if you need more information regarding Project Management.

Download More: Manpower Histogram and Plans in Excel – Templates

FEATURED POSTS


Download Primavera P6
To download and install Primavera P6 was never that easy as nowadays. By following these steps…

Download Primavera P6

What is PMP?
What does PMP stand for? You are here as you just have heard about PMP, or you know a little already but have some …

What is PMP?

Stakeholer Engagement
A stakeholder is any individual, a group of people or an organization that can affect or be affected positively….

Stakeholer Engagement

Work Breakdown Structure
Work Breakdown Structure is simply a tool that breaks the work down into a structure…

Work Breakdown Structure

Project Management
Project management is how you apply the knowledge, skills, tools, and techniques to get the project management …

Project Management

Gantt Chart
A Gantt chart is also known as bar chart represents a project plan by making each task into a bar and …

Gantt Chart

Planning Engineer
Planning Engineer is considered the right-hand of a Project Manager as he floats the information about project…

Planning Engineer

Team Development
Dr. Bruce W. Tuckman, a psychologist published a theory in 1965 called ‘Tuckman’s Stages of …

Team Development


1 thought on “Primavera P6 to MS Excel, Manpower Histogram and Plans in Excel – Templates”

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top