Blog Solidworks SAVING SOLIDWORKS GENERATED BOM TO EXCEL FILE
SAVING SOLIDWORKS GENERATED BOM TO EXCEL FILE
| 
Written by Julius Acosta | 
| 
| 
| Blog - Solidworks |
In a manufacturing Industy producing a certain unit or product ,BOM is used for communication between manufacturing partners or confined to a single manufacturing plant containing all components Description,Part Number, Quantity, Materials, etc..If there are many Sub-assembly, It is easy to have BOM in excel file to display all the parts in the assembly for easy navigation of components.
In Solidworks, there are templates for computed BOMS, weldment BOMs, and weldment cut lists. Each BOM template can have different data variables displayed in the BOM columns depends on the needs of the user. Just insert all the property or data need before saving as excel file.
For example, a BOM for engineers or designers might have the following columns:
- Part Number
- Description
- Part Number
- Quantity
- Material
A BOM for purchasing managers might have the following columns:
- Vendor
- Cost
- Material
- Part Name
- Part Number
- Quantity
- Unit of Measure
From the Bom Created in Solidworks just Single Click the BOM so it is selected and then go to file-Save As ( or right-click on the BOM and choose Save As.) . Select save as file type Excel (.xls.).
