• Exported spreadsheets are saved with the XLS or XLSX extension.

• When exporting parts and product structures, spreadsheets can contain multiple worksheets. A worksheet is created for each of the following:

◦ part type

◦ part subtype

◦ the product structure or BOM

◦ replacements

• Classified parts that share a common classification node are exported to the same worksheet, and that worksheet is assigned a system generated name.

• Different part types, for example, manufacturer parts and vendor parts, are exported to separate worksheets, even if they belong to the same node in the classification structure.

• The Export Importable Spreadsheet action is not available for custom parts.

• When you export from a search results table, all parts in the table are exported to a spreadsheet.

• The first cell of a worksheet defines the type of data that was exported. If you plan to import the spreadsheet back in Windchill, do not modify the first cell of the top row of a worksheet.

• Row 5 of the exported spreadsheet contains the display names of the soft attributes included in the worksheet. If the attribute does not have a display name, this field is blank.

• Row 6 of the exported spreadsheet can contain the internal names of the attributes included in the worksheet. The internal name of an attribute may be a system generated name such as xje262.