solidworks export indented bom

SolidWorks: Export Indented BOM

By Sarah King
AD

Mastering the export of an indented Bill of Materials (BOM) in SolidWorks is crucial for streamlined manufacturing processes, efficient part procurement, and ensuring quality control. Here, we'll delve into the intricacies of this process, empowering you to export indented BOMs with ease and precision.

Let's begin by understanding what an indented BOM is and why you might need it. An indented BOM is a hierarchical representation of a product's components, showing each part's quantity, along with their sub-assemblies and sub-components in a tabular format. This format aids in tracking part relationships, managing inventory, and facilitating procurement.

Understanding the SolidWorks BOM Structure

Before diving into the export process, let's grasp the SolidWorks BOM structure. It comprises three views: 'Product Structure,' 'Manufacturing BOM,' and 'Specsheet BOM.' Each view serves specific purposes and might require unique exports depending on your needs.

AD
SOLIDWORKS - Nested IF Statements to Create a Universal Weldments BOM
SOLIDWORKS - Nested IF Statements to Create a Universal Weldments BOM
Solidworks Tutorial: Cosmetic Thread - Tutorial45
Solidworks Tutorial: Cosmetic Thread - Tutorial45
How To Design a Helical Bevel Gear In SolidWorks
How To Design a Helical Bevel Gear In SolidWorks

For exporting an indented BOM, the 'Manufacturing BOM' view is usually the go-to, as it lists all components in a hierarchical manner, ready for manufacture and procurement. Now, let's explore how to export this in detail.

Exporting an Indented Manufacturing BOM

To export an indented BOM in SolidWorks, follow these steps:

Muncaster2 3D Drawing Design SolidWorks
Muncaster2 3D Drawing Design SolidWorks
SolidWorks Lofted Bend Tutorial | SolidWorks Sheet Metal Cone Tutorial | Sheet Metal Transitions
SolidWorks Lofted Bend Tutorial | SolidWorks Sheet Metal Cone Tutorial | Sheet Metal Transitions
Solidworks Induction Motor Cover Modelling (Flange type) | Solidworks tutorial 2026
Solidworks Induction Motor Cover Modelling (Flange type) | Solidworks tutorial 2026
  1. Access the 'Manufacturing BOM' view of your product structure.
  2. Right-click anywhere within the BOM and select 'Table' > 'To Excel' from the context menu.
  3. In the ensuing dialog box, ensure 'Indented' is selected under 'BOM Hierarchy'.
  4. Choose 'Flattenced' under 'Reference Type' to ensure all parts are listed individually.
  5. Click 'OK' to export the indented BOM to an Excel spreadsheet.

Customizing the Indented BOM Export

Sometimes, you might need to customize the BOM export to suit specific requirements. Here's how:

  1. Access the 'Manufacturing BOM' view and right-click to select 'Table' > 'Named Selections...'.
  2. To include or exclude specific columns, check/uncheck the boxes corresponding to the desired columns in the 'Named Selections' dialog box.
  3. Click 'OK' to apply the changes and re-export the BOM following the steps mentioned above.

Exporting Indented BOM for a Configuration or Assembly

Sometimes, you might need to export an indented BOM for a specific configuration or assembly within your product structure. The process remains largely similar, with slight variations.

AD

To do this, select the desired configuration or assembly in the 'Product Structure' view before proceeding with the 'To Excel' export. Ensure you've configured the BOM as desired, including any mates, mates applications, or design tables that might affect the BOM structure.

I will do 2d technical drawings convert in to 3d cad models using solidworks
I will do 2d technical drawings convert in to 3d cad models using solidworks
solidworks drawing DIN 6358 D22
solidworks drawing DIN 6358 D22
SolidWorks tutorial Coca Cola Cap
SolidWorks tutorial Coca Cola Cap
Solidworks tutorial | sketch Gate Valve in Solidworks | Solidworks
Solidworks tutorial | sketch Gate Valve in Solidworks | Solidworks
Flanged Hub Design in SolidWorks | SolidWorks Tutorial
Flanged Hub Design in SolidWorks | SolidWorks Tutorial
SolidWorks tutorial Coca Cola Bottle
SolidWorks tutorial Coca Cola Bottle

Exporting an Indented BOM for a Single Item

If you're working with a large assembly or have multiple configurations, exporting an indented BOM for a single item can be beneficial. Here's how:

  1. Select the desired item in the 'Product Structure' view by checking its box.
  2. Right-click the selected item and select 'Table' > 'To Excel'.
  3. The export process remains the same, but it will now only include the selected item's BOM.

With these detailed steps and sub-topics, you're now equipped to export indented BOMs in SolidWorks with confidence. Happy designing and exporting!

AD

As a final thought, consider exploring SolidWorks' numerous customization options for BOM exports. This could include adding custom columns, filtering rows, or manipulating data post-export to further streamline your workflow. Keep experimenting, and don't hesitate to reach out to SolidWorks support or online resources for more guidance.

Importing a STEP File in SOLIDWORKS - Engineering.com
Importing a STEP File in SOLIDWORKS - Engineering.com
AD