An XER file is a proprietary text-based data format used by Oracle Primavera P6 Professional and EPPM to export, import, and back up project schedules.
For troubleshooting the XER import problems you can download and use the XLSM file in this article to view the contents of an XER in Excel.
This file would work on both Windows and Mac operating systems.

Download XER File Parser

This file includes VB macros.
If you download it on a Windows PC, Windows may block its macros because it came from the internet. To fix that, right-click the file, choose Properties, tick Unblock and click OK, then open it again.

Disclaimer: xer File Parser & Builder

This workbook is provided free of charge “as is”, without warranty of any kind, express or implied. That includes, without limitation, any warranty of merchantability, fitness for a particular purpose, accuracy or non-infringement.

No support. PRM does not provide installation help, troubleshooting, bug fixes, updates or training for this file. Questions, error reports and feature requests may go unanswered. Support is available only to customers who have a separate written agreement with PRM that expressly covers this tool.

Use at your own risk. This tool reads and writes Primavera P6 XER files. Files it builds have not been validated by Oracle and may contain errors. Before you import any generated XER into P6 or any other system, you are responsible for:

• keeping backups of your original XER files and your P6 database;
• testing imports in a non-production environment first;
• checking that schedules, dates, costs, codes and relationships are correct after import.

Limitation of liability. To the maximum extent permitted by law, PRM and its employees and contributors are not liable for any direct, indirect, incidental or consequential damages arising from the use of, or inability to use, this file. This includes loss of data, corrupted schedules, project delays and lost profits.

Macros. This workbook contains VBA macros that read and write files on your computer. Enable macros only if you obtained the file from a trusted source. 

Trademarks. Oracle, Primavera and P6 are trademarks of Oracle Corporation and/or its affiliates. This tool is not affiliated with, endorsed by, or supported by Oracle.

By enabling macros or using this workbook, you accept these terms.