Menu Close

Easily Export Bill of Materials From SOLIDWORKS

Easily export beautiful Bill of Materials from your SOLIDWORKS assembly. The plugin uses an Excel template to store the information and creates thumbnails for each component.

You can insert BOMs in both assembly and multibody part documents. These can be edited in a drawing or as an independent spreadsheet. A BOM can also be merged, split, and anchored.


A SOLIDWORKS BOM is a crucial tool in the manufacturing process. It provides important information for MRP (manufacturing resource planning) systems and product costing. This can help you make informed decisions about how to design and build your products. Having accurate BOMs can also save you time and money in the long run.

Creating a BOM in SOLIDWORKS is easy and requires a few clicks. You can use the BOM Workshop to customize the layout, display style, and format of your BOM. You can also choose to include a reference designator and other relevant notes. The BOM can be used to determine how each part fits into the product structure and to ensure consistency in production.

There are different types of BOMs, ranging from single-level to multi-level. Single-level BOMs are simpler to create and allow you to see the completed product at the top of the list while costs, part description, quantities, and other specifications come later in the list. Multilevel BOMs, on the other hand, are more involved and provide more detailed information about the parts and subassemblies of your product.

To create a BOM in SOLIDWORKS, go to Insert > Tables > Excel Based BOM. You can also use the command CTRL+C to copy the BOM to your clipboard. You can then paste the BOM into your drawing using Insert > Tables > Add to Drawing or by clicking on the graphics area and selecting a table.

Insert a BOM in a drawing

A BOM is a list of all the parts, subassemblies, assemblies and components that are needed to build a product. It also includes the quantities of each item. This is a useful tool in product design and manufacturing. It helps to manage the entire project workflow. It can be used to make an accurate and complete estimate of the cost of the finished product. It can also be used to keep track of all the stages of a project and manage timelines.

BOMs can be inserted into a drawing using the Insert > Tables > Excel-based Bill of Materials command in SOLIDWORKS. To use this feature, you must have Microsoft Excel installed on your computer. The application searches for existing records in the BOM and replaces the text lines with the records. If the BOM is linked to a component, you must choose the Automatic update of BOM option in Document Properties – Bill of Materials.

The Excel-based BOM allows you to customize the layout of the tables. You can add columns and hide rows, allowing you to create a more organized BOM. It also supports a filter based on a formula, making it easier to find and edit the data. You can also display stacked balloons that link to the BOM.

The new features in the Excel-based BOM improve usability and performance. You can now view the contents of a BOM by selecting it and clicking on an icon in the graphics area. In addition, you can drag the BOM tables around on a canvas to resize them. You can also lock cells, rows, columns, and tables to prevent unwanted changes.

Insert a BOM in a part document

Using SOLIDWORKS Excel, you can insert a BOM in a part document. This can be useful when you need to send a BOM to someone outside of your organization. It also allows you to make changes to the BOM without changing the drawing. To edit a BOM, double-click it or right-click and select Edit. The BOM will display with row and column headers. Excel toolbars will replace the SOLIDWORKS toolbars. You can also edit the text in the Item No. and DESCRIPTION columns, but you should clear the Row numbers follow assembly ordering option on the Control tab of the Bill of Materials Properties dialog box to prevent a BOM from updating when the drawing is edited for any reason.

A BOM is a list of all parts, subassemblies, and assemblies used to build a product. It also contains information about the components and raw materials used to create the final product. It is a valuable piece of information for engineers and can help them make more informed decisions about their products.

If you need to export a SOLIDWORKS BOM to an Excel spreadsheet, you can use a macro to do it. This macro can be run from within SOLIDWORKS or from outside the program as an external application. The macro will save a copy of the BOM in an Excel file with thumbnails.

Insert a BOM in a multibody part document

If you need to model an assembly that uses multi-bodies, there is a simple solution. Instead of creating individual part files and creating an assembly drawing, use a weldment cut list. This will make the part drawing look almost indistinguishable from an assembly drawing, but without all of the exploding views and 3D-sketching. This method also allows you to save time and space on your hard drive, and it can be used in place of the ‘Move/Copy Bodies’ command or manual 3D-sketching of explode lines.

You can insert a BOM in a multibody part document by selecting a table from the Insert > Tables menu and specifying the BOM properties. You can choose a parts-only BOM, which displays part components only, or a top-level only BOM, which excludes subassembly components from the BOM. You can also export an assembly BOM into different formats or copy an assembly BOM into a referenced drawing.

If you want to link your BOM to Excel, you can copy a table in the SOLIDWORKS drawing and then paste it into Excel using the Paste With Link feature. Once you have linked the table, whenever you modify the data in Excel, the changes will be updated in the BOM table in SOLIDWORKS. This is a powerful feature that helps you to quickly and easily create an Excel-based BOM.