CADWorxP&ID tab: Utilities > Export
Utilities toolbar: Export
Command line: PIDEXPORT
Exports component data for one or more drawings to an .xls Excel workbook file. This command displays the Select Dwg Files dialog box. Select the needed drawings, and then specify the .xls file to create.
The workbook contains a worksheet for each component type with the following columns:
Common to all worksheets: DWG_NAME, ID_COUNT, BLOCK_NAME, and LAYER NAME
Process Line - TAG_XDATA, SIZE_XDATA, and SPEC_XDATA
Instrument - TAG_XDATA, FUNCTION_XDATA, and LOOP_XDATA
Vessel - TAG_XDATA, LENGTH_XDATA, and OD_XDATA
Link - TAG_XDATA, LINK_ID_1_XDATA, and LINK_ID_2_XDATA
All other component types - TAG_XDATA, SIZE_XDATA, and SPEC_XDATA