Updating AutoCAD Electrical From Microsoft Excel

By Miles Nicholson

Did you know that you can modify the component tags or other data in Excel and then update your drawings after?

 

Why is this useful?

 

• Customers may have cad operators and designers; the cad operator can sketch the design and then the designer can detail the schematics via Excel
• The client may determine the tags of the equipment
• The panel may be manufactured by an external source; the manufacturer part information defined by the panel builder in Excel and then updated back to the schemes

 

How do you do it?

 

1.       Select the Import/Export Data ribbon tab >  

 

Choose what you would like to export (edit)

Select 

Select ¤ Project and ¤ Excel file format

Select  

Select  

Select  

Specify the location to save the excel spreadsheet

 

2. Modify the spreadsheet using Excel

• If changing the component TAG, both the parent and child devices need to be changed

 

3.       Select the Import/Export Data ribbon tab >  

 

Browse to the spreadsheet and select  

 

Select the options that you prefer:

Select