Skip to main content
C
canderson10-Marble
10-Marble
June 20, 2012
Solved

Creo 2.0 how do you export an assembly BOM into Excel?

  • June 20, 2012
  • 5 replies
  • 35521 views

Creo 2.0 how do you export an assembly BOM into Excel?

Best answer by BrianMartin

Hi Carl...

Martin's method uses the Bill of Material information screen in conjunction with the "bom_format" config setting to export data that can be pulled into Excel. Actually that "bom_format" file is quite tricky and doesn't do a very good job unless you're familiar with text file formatting circa 1995. If you want to try this route, I can actually help with this as I've wasted countless hours fiddling with the bom_format files.

Kshetrabasi Mahanta's method is cleaner. To use his method you'll need to generate a bill of material on a drawing format OR create a report format to generate a bill of materials. From here, you can save the contents of the table as a CSV file and read that directly into Excel. BOMs are relatively easy to create. Almost no one uses report formats but I can help with either of these if you decide to go this route.

Finally, if you have Windchill, you can export a "CSV" file directly from the "Information" screen of your assembly. If you decide to go this route, it would help to know which version of Windchill or Pro/INTRALINK you're running so we can give better directions.

Those are the 3 main ways to pull BOM data into an Excel file. The fastest way is directly through Windchill... and this requires no table, drawing, or report. It's very simple. The most flexible way is via the drawing table or report... because you can really customize the data you're exporting to Excel. The worst way in my humble opinion is the bom_format file because it's absoilutely archaic and tough to work with. The best use for that bom_format file is to re-arrange the data that appears in the on-screen report generated by the "Bill of Materials" report from the Info screens.

I hope this sort of "ties it all together" for you. If you need additional help, let us know which technique you'd like to use. It's relatively easy to get a BOM into Excel once you know what you want and make a decision on how much work you're willing to go through to get the data.

Thanks!

-Brian

5 replies

M
MartinHanak24-Ruby III
24-Ruby III
June 21, 2012

Carl,

I think that this functionality (direct export into xls file) is not implemented.

You can define formating file using BOM_FORMAT config.pro option and export BOM into text file (in Assembly mode). Afterwards you can open this file in Excel and save as xls file.

Martin Hanak

    K
    KshetrabasiMaha1-Visitor
    1-Visitor
    June 22, 2012

    Hi

    you can select your BOM table ; and save it as .csv file(Save as CSV)

    Then you can directly open it in excel

    This will place the BOM items it different cells as we generally require.

    Regards

    K.Mahanta

      B
      BrianMartin13-AquamarineAnswer
      13-Aquamarine
      June 22, 2012

      Hi Carl...

      Martin's method uses the Bill of Material information screen in conjunction with the "bom_format" config setting to export data that can be pulled into Excel. Actually that "bom_format" file is quite tricky and doesn't do a very good job unless you're familiar with text file formatting circa 1995. If you want to try this route, I can actually help with this as I've wasted countless hours fiddling with the bom_format files.

      Kshetrabasi Mahanta's method is cleaner. To use his method you'll need to generate a bill of material on a drawing format OR create a report format to generate a bill of materials. From here, you can save the contents of the table as a CSV file and read that directly into Excel. BOMs are relatively easy to create. Almost no one uses report formats but I can help with either of these if you decide to go this route.

      Finally, if you have Windchill, you can export a "CSV" file directly from the "Information" screen of your assembly. If you decide to go this route, it would help to know which version of Windchill or Pro/INTRALINK you're running so we can give better directions.

      Those are the 3 main ways to pull BOM data into an Excel file. The fastest way is directly through Windchill... and this requires no table, drawing, or report. It's very simple. The most flexible way is via the drawing table or report... because you can really customize the data you're exporting to Excel. The worst way in my humble opinion is the bom_format file because it's absoilutely archaic and tough to work with. The best use for that bom_format file is to re-arrange the data that appears in the on-screen report generated by the "Bill of Materials" report from the Info screens.

      I hope this sort of "ties it all together" for you. If you need additional help, let us know which technique you'd like to use. It's relatively easy to get a BOM into Excel once you know what you want and make a decision on how much work you're willing to go through to get the data.

      Thanks!

      -Brian

        C
        cgorni16-Pearl
        16-Pearl
        December 17, 2021

        The commands to follow for the Creo solutions can be found in the following articles:

         

        • CS54492: How to export Bill of Materials in 3D mode to Microsoft Office Excel in Creo Parametric

        • CS33205: How to export a repeat region table to be read in Microsoft Excel in Pro/ENGINEER, Creo Elements/Pro and Creo Parametric

          B
          bgramman1-Visitor
          1-Visitor
          July 6, 2012

          Simplified Logic offers a tool that will create BOM in MS Excel based on a Pro E assembly.

          http://simplifiedlogic.com/nitro-bom/

          J
          jc-31-Visitor
          1-Visitor
          August 24, 2018

          Hello,

          There 3 different way for BOM extraction

          1) directly go tools > Bill of material .

          2)Export Model tree as a text file

          3)Go to Windchill click Assembly     View Information  > Structure > Report (see the bom) > export(if the table is take default setting you can creat your own table format add the required parameter you want in you BOM) .

           

          The best way is 3rd extracting from Strucutes.

          if want to know in details email me jishnu.c009@gmail.com

           

           

            Terms & ConditionsCookie settingsAccessibility statement