How to export b.o.m. to excel temp?

In inventor 2015 ( Bill of materials tab ) I have been working more in this format with larger projects. but when i go to export to ( xls ) file format excel i get way too much info. where am i going wrong? do i have to set up a temp in excel first?? please help

Answer
 
Comments 0

7 Answers

am i able to do this with out using ibom app?

 
Comments 0

I have attached the one i exported. also an example of a customer that uses solid work. its a format issue i'm just starting to use this as a way to help on cost and other issues where having. i hope this exsplanse the problem better.

 
Comments 0

Can you post an image in here? I just did this with one of my BOM in inventor and had no problem. What I did was
1. Double Click on the BOM in the IDW.
2. Click the Export BOM icon that appears in the top of the menu that appears.
3. Select File name and save location
4. Then Open file in Excel

Let me know if this works for you or if you continue to have problems.

 
Comments 0

I think I get where your going. Are there just specific parts of the list that you want displayed in the excel file when you export it?

 
Comments 0

For instance, Item, quantity, and description.

 
Comments 0

Yes, also i would i can add a header per assembly. its more to be able to use the live update ability of the b.o.m. to spread sheet. I see people do this separate or manually all the time so I really started looking into keeping it simple less mistakes this way. With this said is there a temp style i can use that works with inventor? per attached image im able to adjust everything in the bom platform, just gettting it to export to exsample colored style excel i had attached is my problem. thanks

 
Comments 0

The only way I know of that Inventor can export to excel is with the Export BOM tool once you finish making the BOM in the idw. You can use the tool I have highlighted in the image to bring up the column chooser tool which will let you choose exactly what columns to display. As for exporting a header per assembly, there is no tool inventor has that I'm aware of. There isn't a temp. style that can really work with it either. I'm sorry I couldn't be of too much more help.

Answered with a tutorial: https://grabcad.com/tutorials/how-to-export-b-o-m-to-excel-temp

 
Comments 0