Tech Tip Tuesday: Export Assembly BOM as an Excel File in SolidWorks 3D CAD

There will be cases when you would want to share the Bill of Materials with someone who doesn't have access to SolidWorks, in such scenario SolidWorks allows you to export BOM in file formats like excel or any other formats that most people have access to. In this tech tip video we show you how to export Assembly BOM in excel to share the product composition with the wider audience.
Be sure to follow us on social media and subscribe to our UA-cam channel for our weekly SOLIDWORKS Tech Tips and the latest in industry news with CAD Micro TV!
Twitter: / cad_micro
Facebook: / cadmicro
LinkedIn: / cad-microsolutions-inc-
Instagram: / cad_micro
Visit CAD MicroSolutions at www.cadmicro.com/ to learn more about our services! We are the top reseller of SolidWorks products in Ontario, and a reseller of Virtalis Virtual Reality and Markforged, HP, Nano Dimension, BigRep, Ultimaker and Formlabs 3D printing solutions across Canada. We provide consulting, software, hardware and training in all areas.

[@espartaco8001]

You're awesome dude

[@baironmoreno9766]

excelente, muchas gracias

[@kasperfurbo668]

Thanks for the video! I have a question though. All the thumbnails are locked/immoveable after exporting my BOM to excel. I'd like to move some of the thumbnails, but this is not possible as they all are locked. Is this solveable?

[@Brad-RB]

Is there any way that I can have SolidWorks use a specific Excel template to start from? That way the page layout, headers, company logos, etc. can be already the way I want them.

[@H696MM]

That is with macro. You can read the part propierties of your assembly and then write them into your Excel template. Im not good at macros, I export the excel file as csv, and then execute a python script to read the csv and write the information of the rows in an excel template.