How to Export Data to Excel
Use the following procedure to export data to a Microsoft Excel spreadsheet using the action. For more information, see Considerations for Exporting Data.
1. Go to one of the following locations:
◦ part information page or document information page
From Actions menu, select Export Importable Spreadsheet.
◦ Structure tab on a part information page
In the Reports action set of the toolbar, click Export 
and then select Export Importable Spreadsheet.
and then select Export Importable Spreadsheet.◦ Folders or Search Results table
▪ From the Actions menu, select > .
▪ From the right-click menu, select Export Importable Spreadsheet.
◦ Clipboard table
▪ From Quick Links, select Clipboard. From the Actions menu, select Export Importable Spreadsheet.
 | The actions are controlled by profiling and appear in the following locations only if your administrator has added you to the appropriate profile. For more information, see Accessing Data. |
2. Under Export Options, select options as described in the table below. You can select more than one checkbox, except when BOM Table is selected.
Selection | Result | ||||
|---|---|---|---|---|---|
• BOM Table |
Exports the part and BOM worksheets (single-level BOM only) as well as a matrix worksheet. Replacements are not exported. From the matrix worksheet, you can add or remove child parts from parent parts and update usage link attributes. For more information, see BOM Table Worksheets. Click Set Parent Attributes and Set Usage Attributes to select the attributes that appear in the matrix worksheet.
| ||||
• Parts | • Selected parts are exported to the parts worksheet. Child parts are not exported.
| ||||
• Documents | Selected documents are exported to the documents worksheet. | ||||
• BOM | • BOM (all levels of children) is exported based on the selected configuration specification. Each parent part is in a separate BOM worksheet.
| ||||
• Replacements | • Alternates of selected parts are exported to the replacements worksheet. Substitutes are not exported.
| ||||
• Parts • BOM • Replacements | • All selected parts and their child parts (if any) are exported in the parts worksheet. It also lists parts that are included as alternates and substitutes. • BOM (all levels of children) is exported based on the selected configuration specification. Each parent part is in a separate BOM worksheet. • Alternates and substitutes for the parent and child parts included in the selected configuration specification are exported in the replacements worksheet. | ||||
• Parts • Replacements | • Selected parts are exported to the parts worksheet. Child parts are not exported. • Alternates are exported to the replacements worksheet. Substitutes are not exported.
| ||||
• BOM • Replacements | • BOM (all levels of children) is exported based on the selected configuration specification. Each parent part is in a separate BOM worksheet. • Alternate and substitutes for the parent and child parts included in the selected configuration specification are exported in the replacements worksheet. | ||||
• Parts • BOM | • All selected parts and their child parts (if any) are exported in the parts worksheet. • BOM (all levels of children) is exported based on the selected configuration specification. Each parent part is in a separate BOM worksheet. | ||||
• Parts • Documents | • Selected parts are exported to the parts worksheet. Child parts are not exported. • Selected documents are exported to the documents worksheet.
|
to view the existing configuration specifications and other filter settings.
to change the settings.3. Under Export Attributes, specify the file name and extension for the exported spreadsheet.
4. Click OK. A window opens asking if you want to open or save the Excel file.