how to extract bom in excel format

rhr · ‎Dec 07, 2016

This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.

kdirth · ‎Dec 07, 2016

Go to table tab.

Select table.

In the Save Table drop down select Save as CSV.

This can be opened in excel and saved as an excel file.

There is always more to learn in Creo.

ssywak · ‎Dec 07, 2016

Go to the TABLE tab, and then go select the table you want in the main window. The BOM table should hi-light.

Within the "Table" group of functions, you should see "Save Table".

Within that pull-down, select "Save as CSV". CSV is a "Comma delimited format" that is easily imported by Excel.

Save it in a smart place, remember where you saved it, and then you can actually open the CSV file (it's a choice) within Excel. Unless you had fields with commas already IN them, you should have yourself a nice spreadsheet. If you had some commas, you'll have to do a little clean-up.

Don't forget to save the Excel file in Excel format (assuming that's what you want), or it may just save it as a CSV file again.