Export BOM to Excel
Export BOM to Excel
(OP)
I was wondering if it was possible to export a table-based BOM to excel. I use a lot of BOM's and in version 2003 I could export the BOM to excel to use it for part-lists. I was wondering if it was possible without an excel-based BOM.
Grtz,
Bouke Brouwers
Grtz,
Bouke Brouwers






RE: Export BOM to Excel
Select the BOM in the drawing, then "save as". Select the file type *.txt or *.csv. Excel can import either of these.
RE: Export BOM to Excel
In SW04, you have the option of moving away from Excel-based BOMs, but I have yet to try exporting this data out of SW.
Anyone else try it?
Ray Reynolds
"There is no reason anyone would want a computer in their home."
Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977
Have you read FAQ731-376 to make the best use of Eng-Tips Forums?
RE: Export BOM to Excel
Also, we have issues that you can change the description or text of a part and the new BOM thinks it's a new part and shifts it to the bottom of the BOM... ::sigh:: We're not the happiest of users with the new BOM.
We have some assembly drawings that are several sheets and each partial assembly view has it's partial BOM on it and we'd like to compile an exported BOM for purchasing to work from and really can't find an easy out....
RE: Export BOM to Excel
As for saving a BOM CMcF is correct.
Select the BOM in the drawing, then do a File "save as". Select the file type *.txt or *.csv. Excel can import either of these.
Regards,
Scott Baugh, CSWP

http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
RE: Export BOM to Excel
Grtz, Bouke...
RE: Export BOM to Excel
Regards,
Scott Baugh, CSWP

http://www.3dvisiontech.com
http://www.scottjbaugh.com
FAQ731-376
RE: Export BOM to Excel
Btw If I select my bom-table I dont get 4 green Squares, But I get A large Magenta-colored Border around ;)
Grtz... Bouke