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.

 

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

Hany Ismail, MSC, PMP
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

20220629_013616
Primavera P6 Excel Import/Export Require Microsoft Access [Solved]
29 June, 2022
Remove Actuals using Global Change cover
Remove Primavera P6 Actuals using Global Change
24 January, 2022
Bulk Delete Relationships in P6 cover
Bulk Delete Relationships in P6
20 January, 2022

    3 Comments

  1. blank
    Ahmed Al-antabli
    April 27, 2013

    Perfect

  2. blank
    Sam
    July 29, 2015

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

  3. blank
    asif
    November 15, 2016

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

Leave A Reply