CADWorx Plant tab: Bill of Material panel > Export BOM 
Command line: BOMEXPORT
Exports the Bill of Material schedule to an external file format that you specify. The schedule for the Bill of Material is defined using BOM Setup. CADWorx can export the Bill of Material schedules to:
-
Access file (*.mdb)
-
Excel file (*.xls)
-
Text file (*.txt)
-
HTML file (*.htm)
When exporting data to Microsoft Excel, numeric data is exported as text and is preceded by a single quote. This single quote prevents you from totaling the column in Excel. To correct this in Excel, select the column and then select Data > Text To Columns. Step through the wizard selecting the Delimited option and Tab as the Delimiter check box. This changes the data from text to numbers. In Imperial/Inch settings, length is exported in feet and inches, which cannot be totaled in Excel. To export length in decimal format, change the current CAD platform Dimension Style settings Primary Units format to decimal.
-
Click Export BOM
in the Bill of Material panel.
You can also type BOMEXPORT in the command line.
-
Specify if you want a Cut, Total, or Single BOM.
-
Select the objects to include in the BOM. Right-click or press ENTER when you are finished.
-
In the Save as type box, select the file format that you want.
-
Type the file name, and specify the folder location.
-
Click Save.