Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
how to extract bom in excel format
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.
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.