DATAEXTRACTION — Data Extraction

Extracts object data (count, layer, length, area and attributes) to a table or a CSV file.

• Command: DATAEXTRACTION · Global name: _DATAEXTRACTION · Alias: DX, EXTRACDAT
• Ribbon: Annotate › Tables
• Menu: Insert

Extracts data from the objects in the drawing to a table or to a CSV file, like AutoCAD's data extraction with its default options: how many objects of each kind there are, their layer, length and area, and the attributes of the blocks. Useful for quantity take-offs and bills of materials.

Usage

1. Enter DATAEXTRACTION (or EXTRACDAT) or click the button.
2. Select the objects and press Enter, or press Enter without selecting to take all those in model space.

Select blocks or [ALL] <ALL>:

3. Choose the output.

Output [Table/File] <Table>:

4. With Table, specify the upper-left corner of the table.

Upper-left corner of the table:

5. With File, type the path of the file.

CSV file:

Columns

• Count: how many identical objects the row stands for (identical rows are combined, as in AutoCAD).
• Name: the block name or the object type.
• Layer, Length and Area: the length is that of lines, polylines and arcs and the circumference of circles; the area, that of circles and polylines.
• One attribute tag per column, with the value of each block.

Columns without any value are left out.

Notes

• There is no wizard to choose objects, properties or filters, nor a .dxe template: the columns above are output.
• To output only the attributes with the position of each block, use ATTEXT.
• If the path does not end in .csv or .txt, .csv is added. The file has a UTF-8 mark so that spreadsheets read accented characters correctly.

See also

ATTEXT · TABLE · DATALINK · Blocks and attributes