Export an Assembly to Excel

When you export an assembly to Excel, automatically formats the resulting spreadsheet.

The spreadsheet contains the following:

The Excel file name is the same as the assembly name.
First-level folders (major divisions or modules) become the spreadsheet tabs. One sheet is created for each first-level folder. First-level folder names are truncated at 31 characters.
One row for each folder, leaf and document element is created. The rows are in the order of the assembly. The Excel spreadsheet is not hierarchical but a Level column is provided which indicates the hierarchy.
Folder attribute names become the column names.
Folder attribute values become the column contents.
Leaf attribute names that differ from the folder attribute names become additional column names.
Leaf attribute values become the column contents.
Assigned document and placeholder attribute names that differ from the folder or leaf attribute names become column names.
Assigned document and placeholder attribute values become the column contents.
Leading zeros are stripped during the export process. To work around this, rename the file with a .txt extension rather than a .csv extension. Open the file in Excel. Use the Text Import wizard to make the initial cells text cells instead of general cells, and choose a comma delimiter.

Note: Occasionally Excel may prompt you to make repairs. This is an errant message; you can click Close to ignore the message.