Blog posts


By Gus Petrikas

If you ever find yourself in a position were you have to change a property of a component after you finish your drawing, here are a couple of ways to do just that.  The obvious one would be to edit the components one-by-one using the Edit Component command, but that could be really time consuming, if you are working on a bigger project. The second, much faster solution to the problem would be to edit all the components at once, using Excel: 

  •  Inspect the components that need to modified. For the purpose of this demonstration I am going to change the Rating of these circuit breakers.  

  • Navigate to the Import/Export Data tab on the ribbon and select To Spreadsheet. 

  • Choose the data category that needs exporting. In this case - Components.

  • Choose the preferred format. I would recommend .xls as it is very easy to edit the exported file. 

  • Then, pick the files that will be included in the spreadsheet and hit OK.

  • You should now have an exported spreadsheet with all the Component information. Open the spreadsheet and make the necessary modifications.  

  • Save and exit. 
  • Navigate back to the Import/Export Data tab and click From Spreadsheet

  • Choose if the changes need to be made to the Project or the Active Drawing and hit OK. 

  • The drawing should automatically display the new, updated component values.