Export Workbook Metadata

If you want to look at the current workbook's metadata, you can export a metadata file in JSON format. Use this file to search for a particular item in the integrated workbook or to compare two versions of the same workbook.

WARNING:

Do not create any dependencies based on the structure of the metadata file. This schema of these metadata files may change from one release to the next.

To export and open the JSON file:

  1. From the Advanced menu, choose Export Workbook Metadata.

    Note:

    This menu option is only available when the designer tools are enabled.
  2. Save the file to your local drive.
    The add-in exports all catalog and layout metadata to this file.
  3. Open the file in an appropriate program like a text editor.

    Please note that the property names in the export file may not always match the property names in the add-in's editors.