Guide
How to open a Primavera P6 XER file in Excel
Someone sent you an XER file and you don't have Primavera P6? Or you use P6 and want the schedule in Excel to report on or share? RANGA opens P6 XER files straight into Excel, with the WBS, dates, float and a Gantt chart, in a few clicks.
By Rangarajan Ramaswamy, founder of Prevara Automation · Updated 19 October 2026
What is an XER file?
An XER file is the export format of Oracle Primavera P6, the scheduling software used on most large construction, energy and infrastructure projects. One XER file holds a whole project, or several: activities, the WBS, relationships, dates, float, calendars, resources and activity codes.
Planners send XER files because P6 can import them exactly. Contractors submit them to clients with each schedule update, and reviewers, project managers and claims teams receive them. Many of those people don't have P6, and Excel can't read an XER file by itself. RANGA adds that to Excel.
Inside, an XER file is plain text: dozens of tables one after another, such as PROJECT, PROJWBS (the WBS), TASK (activities), TASKPRED (relationships) and CALENDAR. The tables point to each other by internal IDs, which is why the raw text is hard to read. RANGA joins them back into a schedule.
What you need to open XER files in Excel
- Windows 10 or Windows 11.
- Microsoft 365, or Office 2016 or later, with 64-bit Excel. To check, go to File → Account → About Excel: the first line ends in 32-bit or 64-bit.
- The XER file. It can come from any version of Primavera P6. If it arrived in a .zip file, extract it first.
- RANGA. You don't need Primavera P6 on your PC.
32-bit Excel and Excel for Mac are not supported.
How to open an XER file in Excel, step by step
Install RANGA
Start your 30-day trial from the Pricing page: download the installer and run it. No credit card and no registration are needed. The installer is code-signed by PREVARA AUTOMATION (OPC) PRIVATE LIMITED; if Windows asks before installing, check that this publisher name is shown, then continue.
Open Excel and find the RANGA tab
Open Excel and start a blank workbook. A new RANGA tab appears on the ribbon. Can't see it? See If something goes wrong.
Click Import XER
On the RANGA tab, click Import XER. It's the first button, in the XER Viewer group.
Choose the XER file
A Windows file window opens. Go to the folder with your file, select the .xer file and click Open.
Your schedule opens in Excel
RANGA reads the file and builds the schedule on the sheet: the WBS, every activity with its status, dates and float, and a Gantt chart next to it. The next section explains what you see.
Reading the schedule in Excel
RANGA lays out the schedule the way planners read it in P6: the WBS as coloured bands, the activities under each WBS, and a Gantt chart on the right.
- 1Project and WBS bands The project is the top band. Each WBS level has its own colour, so you can see the structure at a glance.
- 2WBS summary rows Each band shows the total work days and the start and finish dates of everything under it.
- 3Activity columns Activity ID, Activity Name, Activity Status, Activity %, Work Days, Start Date, Finish Date and Total Float, one activity per row.
- 4Filters Every column heading has a filter arrow. Show only activities that are Not Started, for example, or sort by float.
- 5Gantt chart A timeline by month and year. Summary bars span each WBS; activity bars show the completed part and the remaining part in different colours; diamonds are milestones.
- 6Data date A red dashed line marks the schedule's data date, so you can see what should be finished by now.
If the XER file holds more than one project, RANGA loads them all on the same sheet, one after the other, each with its own project band.
Tips for reviewing an XER schedule in Excel
Once the schedule is on the sheet, ordinary Excel tools answer most review questions:
- What's critical? Sort or filter Total Float from smallest to largest. Zero and negative float come first.
- What's in progress? Filter Activity Status to In Progress and compare Activity % with the dates.
- Where is the work? Click Group by WBS to fold the sheet to the WBS bands, then read the work days and dates on each.
- Need a printout or a PDF? Use Excel's own Page Layout and Print settings; the Gantt bars print with the sheet.
Your changes in Excel don't change the XER file. To review the next update, import its XER file the same way.
Convert XER to Excel and share it
The result is a normal Excel workbook. Save it as an .xlsx file and share it like any other spreadsheet: the colours, Gantt bars and filters stay, so colleagues and clients can open it without RANGA or Primavera P6.
That makes it easy to send a schedule update to someone without P6, attach it to a report, or keep a copy of each update for comparison.
Your schedule stays on your PC
RANGA runs locally in Excel. Your schedule files never leave your PC; only basic system details are sent once, to activate your licence. RANGA doesn't upload your XER file anywhere to convert it.
After activation, RANGA works offline.
What you can do next
Once the schedule is in Excel, the other RANGA tools work on it. The 30-day trial includes all of them.
Color by WBSBasic
Change the WBS colours to your own with one click.
Group by WBSBasic
Fold the schedule to any WBS level for a quick summary for management.
Gantt chart by shape or by cell formatBasic
Redraw the Gantt chart by days, weeks, months or years.
Extract CalendarPRO
See every calendar in the XER file: working days, exceptions and holidays.
Schedule AssessmentPRO
Check the schedule against 45 configurable checks, such as open ends and negative float, in one report.
Advanced XER CleanerUltimate
Remove or hide costs, resources, codes and notes before you share an XER file.
Opening XER files across a team
Each person who opens XER files with RANGA needs their own licence: one licence per user, on their PC.
For a company, we quote by the number of licences, and your IT team can install RANGA silently through Microsoft Intune or Group Policy. See Deploy RANGA in your organisation.
If something goes wrong
The RANGA tab doesn't appear in Excel
Excel sometimes doesn't load a new add-in straight away. Load it yourself, and if it's still missing, turn it back on in Disabled Items.
RANGA won't install or run on my Excel
RANGA needs 64-bit Excel on Windows. Check your Excel version.
I can't find my XER file in the file window
Check that the file ends in .xer. If it came in a .zip file, extract it first, then choose the .xer file inside.
RANGA asks for an activation key
Your 30-day trial has ended. Choose a plan and your key is emailed to you automatically after payment. Activation help.
Still stuck? See the FAQ or email [email protected].
Open your first XER file in Excel
Try every feature for 30 days. No credit card needed to download.