About Exporting/Importing Spreadsheet Data

Export project data using Export to Spreadsheet. Edit the data and import changes to update the project drawings. The spreadsheet can update existing components and wire numbers with your edits. If the block name is modified, it can swap one block for another. It cannot insert new items into the drawings.

You can edit component tags, descriptions, catalog assignments, wire numbers, and PLC I/O descriptions in the spreadsheet. Import the changes from the spreadsheet using Update from Spreadsheet. The spreadsheet can update existing components and wire numbers with your edits. If the block name is modified, it can swap one block for another. It cannot insert new items into drawings.

The attributes in the User-Defined Attributes list are also added to the fields exported in the Export to Spreadsheet feature. Add the User Defined Attribute names to the wd_xls_all_template.xlt worksheets to include these fields with the General export option. The default location for the spreadsheet template is C:\Program Files\Autodesk\AutoCAD {version}\Acade\Support\{language code}.