About the Excel File

When you export GE Digital APM metadata, you have the option of exporting it to a Microsoft Excel or XML file. When you choose to export data to a Microsoft Excel file, a Microsoft® Excel spreadsheet file (XLS and XLSX) is created that contains the metadata that you chose to export.

The specific content of the spreadsheet will depend upon what you chose to export. Every spreadsheet will contain an Information worksheet, which contains general information about the export operation, including:

MERIDIUM_VERSION: The GE Digital APM version used to perform the export.
EXPORT_CREATION_DATE: The date and time that the export operation was performed.
USER_ID: The user ID of the user who performed the export.
USER_NAME: The name of the user who performed the export.
MERIDIUM_DATASOURCE: The name of the GE Digital APM data source on which the export was performed.

In addition to the Information worksheet, one or more worksheets will appear for every data type that you chose to export.

Note: Some data type selections will result in the creation of more than one worksheet. For example, when you export Families, Fields, and Field Behaviors.

The content of each tab will be specific to that data type. Each column in the spreadsheet will contain a header with a name that indicates the type of data that the column contains. The column heading names should be self-explanatory for each data type, provided that you are familiar with that data type.