Organize and Refine the Extracted Data

Extract Data Using the Data Extraction Wizard

Organize and Refine the Extracted Data

 

Share Data Between Drawings and Applications > Extract Data from Drawings and Spreadsheets > Extract Data Using the Data Extraction Wizard > 

Organize and Refine the Extracted Data

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To specify formatting for extracted data in a column

1. Click Insert tab Linking & Extraction panel Extract Data.At the Command prompt, enter dataextraction
2. In the Data Extraction wizard on the Refine Data page, right-click the column label for the column that will have its data type changed. From the shortcut menu, click Set Column Data Format.
3. In the Set Cell Format dialog box, select the data type from the Data Type list (Angle, Currency, Data, Decimal Number, General, Percentage, Point, Text, or Whole Number.)
4. Depending on the selected data type, specify additional options from the right side of the dialog box.
5. Click OK.

 Toolbar: Modify II 

 Command entry: DATAEXTRACTION