Ask and answer engineering questions

Learn from millions of experts

Feed

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

By Robert tegtmeyer on 12 Feb 13:53 7 answers 1259 views 0 comments

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

Attachments

project export bom file data sheet.xls, 35 KB
Download

7 answers

  • Robert  tegtmeyer
    Robert tegtmeyer over 1 year ago

    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.

  • Jonathan DeRoner
    Jonathan DeRoner over 1 year ago

    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.

  • Jonathan DeRoner
    Jonathan DeRoner over 1 year ago

    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?

  • Robert  tegtmeyer
    Robert tegtmeyer over 1 year ago

    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

  • Jonathan DeRoner
    Jonathan DeRoner over 1 year ago

    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

Add your answer to: "How to export b.o.m. to excel temp?"

Save Cancel