Convert Primavera XER to Excel Sheet (Free Tool)

Greetings, Planning Engineers! At times, we may need to convert Primavera to Excel to transfer data from our Oracle Primavera schedule to an Excel sheet for sharing with parties who are not familiar with Primavera P6.

Unfortunately, copying data from P6 results in losing the WBS formatting. To address this issue, I have developed an Excel sheet that allows you to copy data from Oracle Primavera and paste it into the sheet.

The macro embedded in the sheet will automatically format the data to match Primavera’s layout. Additionally, the sheet offers various color themes to apply to your data, and with a single click, you can save your formatted data to a new Excel sheet

How to use the Free Tool to convert Primavera to Excel

Open Primavera P6 then “ Ctrl + A “ then “ Ctrl + C”.

Then Open our Excel sheet to paste them.

FREE COURSE

Primavera Online Basic Course -English

Online Primavera P6 Course for Engineers & Construction Managers Learn how to use Oracle Primavera P6 to plan, schedule, monitor, and control…

• 5,494 students
• WhatsApp support group
• Certificate

Start free

Then Type “ Ctrl + V” to paste them into this sheet.

Click on “Create” to show the WBS to make the Excel sheet looks the same as the Primavera P6.

Then align the columns

So, to save it click on “Save As”

And the sheet will open a new Excel Sheet with your data.

Choose the Location and click “Save”

Then Close our Excel sheet WITHOUT saving it to be able to use it later

Note: If you face a security issue with the downloaded file as per the below screenshot: 

Just Do the Following Steps and It will Work Fine:

1- Right click on the file after you unzip it and click properties

2- Check the Unblock in the security section in the general tab as shown below

Check out this video for full tutorial on how to use the tool

For those who are interested in planning and Scheduling, We provide Beginner, Intermediate, and Advanced Courses

Download the Resources of this Article

Primavera to Excel Sheet R1

1 file(s) 31.95 KB

Download

From Primavera P6 to Excel (Tool Tutorial)

1 file(s) 822.70 KB

Download

---

Keep in Touch

Join our Email Newsletters and receive FREE weekly useful content!

Your Name

Email

---

Related posts:

Cost Management for Engineers-Cost Terms Calculate Duration in P6 based on scope PMI-SP vs AACEI-PSP | Which exam is better for you? How to connect Primavera P6 to Power BI (Full Guide) Understanding Merge Hotspot, Diverge Hotspot, and Logic Hotspot in Project Scheduling