SOLIDWORKS Electrical – Creating Wires Using Microsoft Excel

by John Lieber

SOLIDWORKS Electrical and Microsoft Excel

SOLIDWORKS Electrical can benefit from the use of Microsoft Excel to help create wire libraries.  For many projects, the same wire library can be used. But what about the times where there are custom requirements for your wires?

Creating the wires is simple enough, go to the wire library for your project and click on “Add” for as many new wires you need.  You can even create a “Numbering Group” to group these wires and provide custom numbering options for these wires.

Don’t forget that “Multiple add” is a super command that creates a grouping of individual wires that would always be used together.

One common example is 3 Phase power where there is always a Neutral, three phases and a ground available for use.

Excel for SOLIDWORKS ElectricalThe key to creating wires is that each wire will have its own set of properties and these properties are set on a wire by wire basis.  While this works well for small groups of new wires, or for changes, it can be tedious when you have a large number to modify. This is where Microsoft Excel comes into play.

Here are the steps I take:

  • Create a new numbering group (if applicable) and click add for the number of new wires you need.
  • Switch to the Import/Export table and select Export to Excel
    1. Select Add
    2. Then click in the checkbox next to WiringCabling.xls
    3. Click on the OK button and then NEXT
    4. Specify the folder where you want to save the spreadsheet and click finish
  • Edit the spreadsheet modifying the newly created wires or if you want the existing wires from the library. (See below for notes on editing the spreadsheet)
  • Save and close the spreadsheet and return to SOLIDWORKS Electrical
  • Select Import from Excel and click on ADD (Select the spreadsheet that you have just edited)
  • After clicking on Next you will see a dialog that will list the edited items that highlight the changes in green.
  • Click on Next to see a summary and finish to accept the changes.
  • This last dialog discusses a saved export point and if you want to save it or not. Ultimately you can choose to save it which would allow you to re-edit the spreadsheet without having to re-export it.  Typically, you will choose to delete the export saved point.
  • You have now quickly edited the properties of many wire properties using Microsoft Excel.

Properties available for edit:

Name, Description, Numbering type (wire number or equipotential) and formula, Bend radius, Color, Diameter, Frequency, line type, section or gauge, section type, voltage, translatable and user data.

Want to learn more or have a question? Fill out the form below and we’ll be in contact.

This entry was posted in blog, CAD, Electrical and tagged , , on by .

About John Lieber

Johnathen is a Sr. Applications Engineer at our GoEngineer Corporate HQ in Utah with over 15 years of technical experience, 13 of which has focused on SolidWorks. He has a unique perspective of having worked as a SolidWorks Application Engineer and Trainer, which fosters an understanding of the user requirements with the system capabilities, allowing for quick resolution to business problems. Johnathen has experience in business process development, configuration, administration, training, installation, software development, and troubleshooting. His training style is focused on simplicity for the end user and administrators while providing excellent functionality.

What's on your mind?

Your email address will not be published. Required fields are marked *