About Exporting/Importing Spreadsheet Data

Export project data using Export to Spreadsheet. Find

Edit the data and import changes to update the project drawings using Import from Spreadsheet. Find

Some of the updates that can be imported into drawings include:

• Component tags
• Descriptions
• Catalog values
• Terminal values
• Wire numbers
• Block names
  Note: A block name change performs a block swap on import.
• Drawing settings such as sheet value, section, sub-section, drawing descriptions.
  Note: Some drawing settings are written to the project .wdp file.

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}.

Note: New items can not be added to the drawings using this feature.