What is an XER file?
An .xer file is the native project-exchange export of Oracle Primavera P6. A single XER holds the entire schedule — activities, durations, logic relationships, WBS structure, calendars, resources and costs — stored as tab-delimited text in Primavera's own proprietary, multi-table relational format. By default it can only be read back into Primavera P6.
That is exactly why "convert P6 XER to Excel" is one of the most common searches on the planning desk: clients, executives and reviewers rarely have a P6 licence, but everyone can open Excel.
Can you just open an XER file in Excel?
Technically yes — and it is almost always useless. Because an XER is tab-delimited text, you can rename it to .txt and import it into Excel. What you get is dozens of stacked raw tables (PROJ, TASK, TASKPRED, PROJWBS, CALENDAR…) full of coded internal IDs, with none of the relationships resolved. You cannot read the schedule, trace logic, or build a report from it.
To get a usable Excel file, the XER has to be parsed: the activity IDs joined to descriptions, WBS paths rebuilt, calendars applied, and float / dates calculated. That is the real work — and it is where your method choice matters.
Method 1 — Manual copy-paste from P6
If you have a P6 licence, the traditional route is:
- Open the project in Primavera P6.
- Lay out the Activity table columns you need (ID, description, dates, durations, total float, % complete, cost).
- Select all rows, copy, and paste into Excel.
- Reformat headers, fix date formats, add S-curves and pivot summaries by hand.
The limitation: it only exports the columns currently on screen, it strips all logic and WBS hierarchy, and every reporting cycle you repeat the same 2–4 hours of formatting. On a 2,000-activity schedule with weekly updates, this is the single biggest time sink on the planning desk.
Method 2 — Generic online XER-to-XLSX converters
Free web converters will turn an XER into a raw XLSX table dump. They are fine for a quick look, but they carry two serious problems for professional use:
- Confidentiality: your schedule is uploaded to a third-party server. On EPC, oil & gas, defence and government projects this usually breaches the client NDA.
- No analytics: you get flat tables, not an executive reporting pack — no S-curves, no EVM, no schedule-quality checks, no dashboard.
Method 3 — Automated analytics with Schedulytics (offline)
This is the method this guide recommends for real project work. Progress Schedulytics is a dedicated Primavera P6 reporting tool that parses the XER or XML file locally and builds the complete report for you.
- Export the .xer or .xml from Primavera P6 (File → Export).
- Load the file into Schedulytics on your Windows PC.
- Generate — in seconds you get a 22-sheet Excel analytics workbook (executive summary, S-curves, WBS breakdown, SPI/CPI trends, float analysis), plus an interactive single-file HTML dashboard and a Word/PDF delay narrative.
Everything runs 100% offline, in-memory — no schedule data ever leaves your machine — so it is safe for confidential client work. You don't even need an active P6 licence: the XER/XML file is all it needs.
Convert your next XER in seconds
Install free from the Microsoft Store with a 30-day evaluation trial — full calculation engines active.
See Progress Schedulytics & the 75% offer →Which method should you use?
| Need | Best method |
|---|---|
| One-off quick look, non-confidential | Online converter |
| Have P6, need a few columns | Manual copy-paste |
| Recurring reporting, analytics, confidential data | Schedulytics (offline) |
Frequently asked questions
Can I open an XER file directly in Excel?
Not usefully. It opens as raw, coded table dumps with unresolved relationships — not a readable schedule. You need a parser that rebuilds the activity, WBS and logic links.
Do I need a Primavera P6 licence to convert an XER file?
No. Once you have the exported .xer or .xml, Schedulytics reads it with its own built-in CPM engine — no active P6 licence required.
What about XML (PMXML) files?
The same applies. Schedulytics reads both P6 XER and XML exports and produces the identical Excel, HTML and Word/PDF outputs.
Explore the full Progress Schedulytics reporting pack →