×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Export BOM to Excel

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

RE: Export BOM to Excel

Yes,
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

I was wondering if it was possible without an excel-based BOM.

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

With the new BOM format in SW2004 you do not have the "SAVE AS" or "SAVE" options and we have been struggling with SW on how to export a BOM and the only options we have been given have been to print out the BOM from the assembly drawings (or do a partial screen capture) which makes un-editable image files to paste into a Word document (or something like that).  Not looking very friendly.  

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....

    ~ Phlyx ~

RE: Export BOM to Excel

With new Functionality in SW, you have to give it some time to get better. Like a fine wine.

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

(OP)
Hmm, Are u all working in 2004 ?? I've tried to save it but it doesn't seem to work. If I select the BOM-table in the feature-manager and then FILE -> Save As... I can only save the whole drawing. Am I making a mistake???

Grtz, Bouke...

RE: Export BOM to Excel

No this works from SW01+ through SW04. I was pretty sure it workeed for all versions, but just to be sure I just tested it and it does. Just Pick it with your left mouse button (LMB). You will see 4 little green squares at each corner of the BOM (That lets you know you have it picked) Then do a files save as. If your pick anywhere else you will not be able to save BOM, only the drawing.

Regards,

Scott Baugh, CSWP
http://www.3dvisiontech.com
http://www.scottjbaugh.com

FAQ731-376

RE: Export BOM to Excel

(OP)
I think I know what's going wrong. I've tried to do "FILE --> Save As" But I have to do "right-mouse-click on the BOM --> Save As template --> Save as txt-file" But it works now!!

Btw If I select my bom-table I dont get 4 green Squares, But I get A large Magenta-colored Border around ;)

Grtz... Bouke

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources