EXPORT Creo BOM Reports to Excel

Overview

This video demonstrates the detailed process of exporting Creo BOM reports to Excel using Nitro-BOM. Unlike a simple data dump, Nitro-BOM generates structured BOM reports that mirror the assembly hierarchy in your Creo model. The export captures component quantities, parameter values, and assembly relationships, then formats them into a clean Excel workbook ready for review or distribution. The video covers how to configure report columns, select which parameters appear in the output, and control the depth of the assembly traversal. This is the primary workflow most Nitro-BOM users rely on for generating procurement lists, engineering BOMs, and documentation packages. The resulting Excel file preserves the parent-child relationships of your assembly tree, making it easy to understand which parts belong to which sub-assemblies. Engineers and BOM managers can then use standard Excel tools — sorting, filtering, pivot tables — to analyze the exported data without needing Creo open.

Key Steps

1. Open your target Creo assembly
2. Launch Nitro-BOM and select the BOM Export function
3. Choose the parameters and columns to include in the report
4. Set the assembly traversal depth (top-level only or full hierarchy)
5. Run the export and review the generated Excel workbook
6. Use Excel's built-in tools to sort, filter, or further analyze the BOM data

Tips

• Save your export configuration as a template for repeatable reports
• Use parameter filters to keep reports focused and manageable
• For large assemblies, consider exporting sub-assemblies separately to improve performance