Create parts lists in Excel

Creating BOM lists in Inventor is often a time-consuming job. Fortunately, the Publish Tool has a function to export BOM lists to Excel. For this we use a template that can be completely customized to your own taste. You can create as many templates as you want.

A number of templates are included with the Publish Tool. You can find these in:

‘C:\ProgramData\Autodesk\ApplicationPlugins\
PeppingMechanicalDesign_PublishToolLite.bundle\Contents\Sample Files’

Move the Excel files to the folder: ‘…./Design Data/Matprop/’
Rename the template you want to edit.
You can adjust the layout on the first page.
On the ‘config’ tab you can link the iProperties and the fields from the Publish Tool.

It is important to choose the correct type in the first column. Choose ‘Cell’ to link a specific iProperty to a cell. You can simply enter Cusom iProperties with the name and they will be automatically recognized.