Hide Table of Contents

Updating Template Material Cost Data

You can export machining template material property data to an .xlsx file and modify the cost data in the spreadsheet. You can upload the material cost data from the .xlsx file to the Costing machining template.

To update material cost data in a Costing machining template:

  1. To open a Costing machining template, do one of the following:
    • From the Windows Start menu, click All Programs > SolidWorks version > SolidWorks Tools > Costing Template Editor version.
    • With a part open:
      1. Click Costing tool_costing_tools.gif (Tools toolbar or the Evaluate tab on the CommandManager) or Tools > Costing.
      2. In the Costing Task Pane, select a template, and click Launch Template Editor.
  2. If your machining template is not open, in the Costing Template Editor application, click Open Tool_Open_Standard.gif, select the machining template and click Open.
  3. Select Stock Material and click Export.
  4. To save the material properties data as an .xlsx file, type a name and click Save.

    The file opens in Microsoft Excel, where you can modify the cost data.

    You must not add rows or columns to the spreadsheet.

  5. To import the updated material cost data:
    1. In the machining template, select Stock Material and click Update.
    2. Select the edited .xlsx file and click Open.

    Updated costs are highlighted in the template Cost column.

  6. Save the template and close the application.

Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

Subject:   Feedback on Help Topics
Page:   Updating Template Material Cost Data
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:


We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again

Web Help Content Version: 2014 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.