Export Structured BOM with grouping -- possible?

Export Structured BOM with grouping -- possible?

claudio.ibarra
Advocate Advocate
473 Views
4 Replies
Message 1 of 5

Export Structured BOM with grouping -- possible?

claudio.ibarra
Advocate
Advocate

When I export a Structured BOM to Excel with all levels, I get a column with 1, 1.1, 1.1.1, etc. Is it possible to have the Excel file with collapsible groups the same way it's presented in the Inventor BOM window? I could do it manually for a small assembly, but for a big one, it's not worth doing it manually.

 

claudioibarra_0-1712079374105.png

claudioibarra_1-1712079444203.png

 

 

0 Likes
Accepted solutions (1)
474 Views
4 Replies
Replies (4)
Message 2 of 5

johnsonshiue
Community Manager
Community Manager

Hi! There are quite a few BOM related Add-Ins on Inventor App store. Please take a look.

 

https://apps.autodesk.com/INVNTOR/en/List/Search?isAppSearch=True&searchboxstore=INVNTOR&facet=&coll...

 

Many thanks!



Johnson Shiue (johnson.shiue@autodesk.com)
Software Test Engineer
0 Likes
Message 3 of 5

claudio.ibarra
Advocate
Advocate

It's hard to tell if one of them does what I'm looking for. I'll keep looking! 

Message 4 of 5

MikeOG
Contributor
Contributor
Accepted solution

Hi @claudio.ibarra & @johnsonshiue, if you are using Vault there is a way to this. Select the assembly you want to export, and start a Copy Design process for this assembly. Select the relevant fields, I added the file extension field as I was only interested in the .iam files. Select File and Export. For large assemblies you need to type the filename as: Filename.xlsx as .xls is limited to a certain amount of rows. Once exported I filtered all non .iam files and removed these rows so that I was left with only .iam files. Hope this helps. Autodesk should add this as an option in the Inventor BOM export dialogue as its really handy to have.

MikeOG_0-1750816858388.png

MikeOG_1-1750816913392.png

 




0 Likes
Message 5 of 5

claudio.ibarra
Advocate
Advocate

I couldn't have said it better myself. Thank you for the tip!

 

"Autodesk should add this as an option in the Inventor BOM export dialogue as its really handy to have."

0 Likes