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
Step No. 2:
Right click on any activity and select export to excel
Select the location to save your Excel file and that is it. you will have excel file like this
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.