Autodesk Inventor

[#1]

How do I get a BOM exported from my assembly into Excel?  The only option I have is export as XML format which is useless to me.  Thoughts?

Thanks!

[#2]

Open BOM click on export Icon in upper left corner.

[#3]

Or create a drawing, add a table, do all your formatting, sorting etc, right click over the table and export.

[#4]

The button is greyed out so I can select it. 

[#5]

Ah...you have to enable "Structured View" to get that option.  Really?  Ok Autodesk, why does this make sense?

[#6]

Here on 2012 it seems to require that one or the other BOM view be enabled, either Structured or Parts Only.

[#7]

I believe it's always been that way, my fault I forgot to specify that in my instructions. Once in excel you can manipulate to your heats content. If I had to make a guess as to why, most outputs are so you can send to a "MRP" system and that needs to be structured. If we had one, I could send to I would be sending out the whole muli-level top bill to them not just lower levels one at a time. If at all possiable as a preferance.

msk

[#8]

We use a macro to do an occurrence count and then format and send to excel. If you are interested let me know and I will post it.

[#9]

I would be interested to see the macro for exporting this to Excel, please. Thanks

[#10]

Attached is the zip file of the macro. It's not perfect but meets our needs. As stated it does an occurrence count of all parts and assemlies so all sketches, FG assemblies and phantom parts/assemblies are included (we custom name all of these so finding and deleting them is easy). It does not include Virtual parts as these produce no file. Re-code as you see fit.