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

An XER schedule opened in Excel with RANGAExcel with the RANGA tab open: the project and WBS as coloured bands, activities with status and dates, and a Gantt chart.XRiverside update 05.xlsx - ExcelFileHomeInsertPage LayoutFormulasDataReviewViewHelpRANGAImportXERColorby WBSGroupby WBSGantt Chartby shapeGantt Chartby Cell formatDeleteGantt ChartCreateWBSExtractCalendarAdvancedXER CleanerScheduleAssessmentABCDEActivity IDActivity NameActivity StatusStart DateFinish Date2026JanFebMarAprMayJunJulAugSepOctNovDec3Riverside Medical Centre05-Jan-202618-Dec-20264Design05-Jan-202603-Apr-20265A1000Project startCompleted05-Jan-20266A1010Concept designCompleted05-Jan-202606-Feb-20267A1020Detailed designCompleted09-Feb-202620-Mar-20268A1030Design approvalCompleted23-Mar-202603-Apr-20269Construction06-Apr-202618-Dec-202610Foundation06-Apr-202616-Jun-202611A2000Site preparationCompleted06-Apr-202624-Apr-202612A2010ExcavationIn Progress27-Apr-202622-May-202613A2020Concrete footingsNot Started25-May-202616-Jun-202614Structure17-Jun-202618-Dec-202615A3000Steel frameNot Started17-Jun-202618-Aug-202616A3010Floor slabsNot Started19-Aug-202613-Oct-202617A3020RoofNot Started14-Oct-202624-Nov-202618A3030Structure completeNot Started18-Dec-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.

The RANGA installer, code-signed by Prevara AutomationThe RANGA installer: a 30-day trial with every feature, signed by PREVARA AUTOMATION (OPC) PRIVATE LIMITED.RANGA installer30-day trial · every feature · no credit cardSigned: PREVARA AUTOMATION (OPC) PRIVATE LIMITED

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.

Excel's ribbon with the new RANGA tabThe tab row of Excel: File, Home, Insert and the other tabs, with RANGA at the end, highlighted.XBook1 - ExcelFileHomeInsertPage LayoutFormulasDataReviewViewHelpRANGAThe RANGA tab appears after you install RANGA.

Click Import XER

On the RANGA tab, click Import XER. It's the first button, in the XER Viewer group.

The Import XER button on the RANGA tabThe RANGA ribbon. Import XER, the first button, in the XER Viewer group, is highlighted.ImportXERXER ViewerColorby WBSGroupby WBSSchedule OrganizerGantt Chartby shapeGantt Chartby Cell formatDeleteGantt ChartDraw ScheduleCreateWBSExtractCalendarAdvancedXER CleanerScheduleAssessmentXER Tools

Choose the XER file

A Windows file window opens. Go to the folder with your file, select the .xer file and click Open.

Choosing an XER file in the Windows Open windowA Windows Open window in the Schedules folder, with the file Riverside update 05.xer selected, and the Open button.OpenThis PC › Documents › SchedulesHomeDesktopDownloadsDocumentsThis PCNameSizeOlder updatesXERRiverside baseline.xer1,204 KBXERRiverside update 04.xer1,388 KBXERRiverside update 05.xer1,412 KBFile name:Riverside update 05.xerOpenCancel

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.

The schedule loaded on the sheetActivities under coloured WBS bands, with Gantt bars and milestones on the right.ABActivity IDActivity Name2026JanFebMarAprMayJunJulAugSepOctNovDec3Riverside Medical Centre4Design5A1000Project start6A1010Concept design7A1020Detailed design8A1030Design approval9Construction10Foundation11A2000Site preparation12A2010Excavation13A2020Concrete footings

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.

Reading an XER schedule in ExcelThe schedule with six numbered markers: 1 project and WBS bands, 2 WBS summary rows, 3 activity columns, 4 filter arrows, 5 Gantt chart, 6 data date line.XRiverside update 05.xlsx - ExcelFileHomeInsertPage LayoutFormulasDataReviewViewHelpRANGAABCDEFGHActivity IDActivity NameActivity StatusActivity %Work DaysStart DateFinish DateTotal Float2026JanFebMarAprMayJunJulAugSepOctNovDec3Riverside Medical Centre28605-Jan-202618-Dec-20264Design6405-Jan-202603-Apr-20265A1000Project startCompleted100%005-Jan-20266A1010Concept designCompleted100%2505-Jan-202606-Feb-20267A1020Detailed designCompleted100%3009-Feb-202620-Mar-20268A1030Design approvalCompleted100%1023-Mar-202603-Apr-20269Construction18606-Apr-202618-Dec-202610Foundation5206-Apr-202616-Jun-202611A2000Site preparationCompleted100%1506-Apr-202624-Apr-202612A2010ExcavationIn Progress60%2027-Apr-202622-May-20261213A2020Concrete footingsNot Started0%1725-May-202616-Jun-20261214Structure13417-Jun-202618-Dec-202615A3000Steel frameNot Started0%4517-Jun-202618-Aug-2026016A3010Floor slabsNot Started0%4019-Aug-202613-Oct-2026017A3020RoofNot Started0%3014-Oct-202624-Nov-2026-318A3030Structure completeNot Started0%018-Dec-20260123456
An XER file opened in Excel with RANGA. The numbers match the list below.
  1. 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.
  2. 2WBS summary rows Each band shows the total work days and the start and finish dates of everything under it.
  3. 3Activity columns Activity ID, Activity Name, Activity Status, Activity %, Work Days, Start Date, Finish Date and Total Float, one activity per row.
  4. 4Filters Every column heading has a filter arrow. Show only activities that are Not Started, for example, or sort by float.
  5. 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.
  6. 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.

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.