How to Extract Data from AutoCAD and Enter into Excel


show more Extracting data from AutoCAD to Excel provides you with in-depth training on video2brain. Taught by Scott Onstott as part of the Data Management with AutoCAD 2013 show less
please wait ...

Extracting data from AutoCAD to Excel

In this lesson, you'll extract attribute data from AutoCad and import it into Microsoft Excel. You'll then edit the data in Excel. It can be useful to extract data from AutoCad to Excel, so that one can add up the number of items used in drawings and create list of materials for price estimation or product ordering purposes. It is also possible to extract attribute data from AutoCad and display it in tables, all without leaving auto cad. The data links to and from Excel are provided because of the popularity of this spreadsheet program. You can also link to data from other spreadsheet programs that support the common separated values, or csv format, such as OpenOffice. Open the Office 10 project file, and then on the Insert tab in the linking and extraction panel, click this button, Extract Data. (audio playing) This launches a wizard interface that will take you step by step through the process.

Choose the Default Option to create a New Data Extraction and click N...

Extracting data from AutoCAD to Excel
Video duration: 5m 33s 1h 19m Intermediate

Viewers:

Extracting data from AutoCAD to Excel provides you with in-depth training on video2brain. Taught by Scott Onstott as part of the Data Management with AutoCAD 2013

Subjects:
video2brain CAD
Software:
AutoCAD
Author:
please wait ...