OP2 file has nastran specific data structure. There are sample programs delivered with Nastran for the purpose of reading the op2 file. This programs will have to be modified to extract needed data in the ascii column format which then can be imported into excel. Sample programs can be found in the nastran installation under
@Guillermo Salgado Sanjay makes an important point about the HDF5 output file available starting with Nastran 2016. HDF5 is more than a file format; it's a data model with an open source library (API). The HDF5 Group provides a Java browser you can use to open and view your data. From there, you can copy/paste the data to another application (like Excel). That's faster than writing a program (and is a lot easier!) If you need to do this frequently, or need to automate, you can use various APIs to access the data. Examples are provided in the 2016 and 2017 Release Guides. Note: Nastran H5 file includes both results and input data. Also, H5 file can be attached to Patran 2017, and has much better performance compared to XDB, OP2 (old) and OP2 (new).
Patran reads the HDF5 files and you should be able to post process results using it. If you are interested in looking at the HDF5 database content in a tabular format, you can use HDF5 viewer. You can down load it from www.hdfgroup.org/.../.
