topic Re: Export Structured BOM with grouping -- possible? in Inventor Forum

Export Structured BOM with grouping -- possible?

claudio.ibarra — Tue, 02 Apr 2024 17:38:11 GMT

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.

Re: Export Structured BOM with grouping -- possible?

johnsonshiue — Wed, 03 Apr 2024 00:13:25 GMT

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=&collection=&sort=&query=bom

Many thanks!

Re: Export Structured BOM with grouping -- possible?

claudio.ibarra — Wed, 03 Apr 2024 18:26:07 GMT

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

Re: Export Structured BOM with grouping -- possible?

MikeOG — Wed, 25 Jun 2025 02:02:47 GMT

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.

Re: Export Structured BOM with grouping -- possible?

claudio.ibarra — Wed, 25 Jun 2025 12:41:00 GMT

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