Data Export Dialog Boxes

Exports information from your project drawings to a file for editing. Use the Import from Spreadsheet command to update drawings with your changes.

Find

Command entry: AEEXPORT2SS

Select the data category from the Export to Spreadsheet dialog box.

List of Options

The following options are displayed.

Note: Options vary depending on the data category selected.

Data Export For

Specifies to export the data for the active drawing or the entire project.

Output Format

Specifies the format for outputting the spreadsheet.

Location Codes to Extract

Filters the information extracted for the report based on location values.

All

Extracts all components regardless of location value.

Blank

Extracts only those components that do not have a location value.

Named Location

Extracts only those components that have a location value matching the value entered in the box. Wild-card characters are supported.

• Drawing. Select one or more location values from a list of values used on the active drawing.
• Project. Select one or more location values from a list of values used across the project.

The attributes in the User Defined Attribute 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}.