How to Read a Primavera P6 XER File Without a P6 License

What Is an XER File?

An XER file is Primavera P6's native export format. It's a plain-text file (UTF-8) containing structured data in a series of tables. Each table begins with a %T line (e.g., %T PROJECT) followed by %F for field names and then rows of data. The file stores schedules, activities, relationships, resources, and more.

Because it's text, you can open it in any text editor, but the raw format is not human-friendly for analysis. You need a tool that parses the tables and presents them as a schedule.

Ways to Open an XER File Without P6

1. Text Editor (Notepad, VS Code)

Open the .xer in any text editor. You'll see lines like %T TASK and column headers. This is useful for quick checks (e.g., verifying the file isn't empty) but impractical for understanding the schedule.

2. Spreadsheet Software (Excel, Google Sheets)

Rename the file to .csv or import it as a delimited file (pipe or tab). You'll get a flat view of one table, but the relational structure is lost. This works for small files but is error-prone.

3. Online XER Parsers (Browser-Based)

The safest and most practical method is using a browser-based tool that parses the XER locally. Project Assure is a free, no-upload tool that reads your XER entirely in the browser. Nothing is sent to a server, so your data stays private.

What to Look at First When Reading an XER

Activities

The TASK table contains all activities. Key fields: task_code, task_name, target_drtn_hr_cnt (duration), act_work_qty (actual work), remain_drtn_hr_cnt (remaining duration), status_code (e.g., 'TK_CP' for complete).

Relationships

The TASKPRED table defines predecessors/successors. Fields: task_id (successor), pred_task_id (predecessor), pred_type (FS, SS, FF, SF), lag_hr_cnt. This shows the logic driving the schedule.

Constraints

Constraints are in the TASK table via cstr_date and cstr_type (e.g., 'CS_MUST_FINISH_BY'). They override logic and can cause date issues.

Data Date

The PROJECT table contains last_recalc_date (the data date). This is critical for status updates and EVM.

Reading an XER Safely in the Browser (No Upload)

Using a tool like Project Assure, you can drag and drop your XER file. The tool parses it locally using JavaScript, so your file never leaves your computer. It displays activities in a table, allows filtering, and runs DCMA 14-point checks, GAO/NASA checks, and EVM analysis. This is the fastest way to understand a schedule without installing any software.

Step-by-Step: Reading an XER with Project Assure

1. Open Project Assure in any modern browser.
2. Drag your .xer file onto the page or click to select it.
3. The tool automatically parses the file and shows a dashboard with activities, relationships, and key metrics.
4. Use the filters to focus on specific activities (e.g., by status or WBS).
5. Check the DCMA 14-point report for common schedule issues like missing logic, constraints, or long durations.

Common Pitfalls When Reading an XER

• Missing relationships: Many activities may have no predecessors or successors. This breaks the critical path.
• Outdated data date: If the data date is far in the past, the schedule is likely stale.
• Excessive constraints: Too many 'Must Finish By' constraints can force unrealistic dates.
• Negative float: Indicates the project is behind schedule.

Conclusion

Reading an XER file without P6 is straightforward with the right tools. Use a browser-based parser like Project Assure to inspect activities, logic, and constraints safely. Focus on the data date, relationships, and constraints to quickly assess schedule health.