Back

Fastest method to export data from primavera p6 to excel

Very fast and simple method to export data from primavera to excel, Actually it is the fastest and easiest method i know so far.

Step No. 1:

Open your P6 file and apply all the filters and columns you want to see in excel

Fastest method to export data from primavera p6 to excel Step 1
Fastest method to export data from primavera p6 to excel Step 1

 

Step No. 2:

Right click on any activity and select export to excel

Fastest method to export data from primavera p6 to excel Step 2
Fastest method to export data from primavera p6 to excel Step 2

 

Select the location to save your Excel file and that is it. you will have excel file like this

 

Fastest method to export data from primavera p6 to excel Result
Fastest method to export data from primavera p6 to excel Result

 Applications of this Method:

To create reports in excel based on primavera schedule, such as progress report or summary reports etc. the core benefit of exporting data using this method and not using the regular method on primavera (export to spreadsheet) is what you see what you will get in excel. Try it and i wish you will find it easy and useful.

 

Keep in Touch:

Join our Email Newsletters and receive FREE daily useful content.

Tag:, , , , , , , , , , ,

User Avatar
Hany Ismail, MSC, PMP

Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

You may also like

How to copy activity codes from Project to another
How to copy activity codes from one project to another
12 September, 2023
How to calculate Planned % and Actual % using weight
How to calculate Planned % and Actual % using Weight
6 September, 2023
How to connect Primavera P6 to Power BI
How to connect Primavera P6 to Power BI (Full Guide)
24 August, 2023

    3 Comments

  1. Ahmed Al-antabli
    April 27, 2013

    Perfect

  2. Sam
    July 29, 2015

    Awesome. Nothing could be simpler than this… (Y)

  3. asif
    November 15, 2016

    Hi
    Is it possible to copy – paste the columns from primavera to excel keeping the same format?

Leave A Reply