Ready to watch this entire course?
Become a member and get unlimited access to the entire skills library of over 4,900 courses, including more video2brain and personalized recommendations.Start Your Free Trial Now
- View Offline
- Why data management is important in AutoCAD
- Designing attributes and storing attribute data
- Using fields to display object properties
- Extracting data from AutoCAD send to Microsoft Excel
- Creating tables
- Formatting table cells and styles
- Editing table cells and using formulas
Skill Level Intermediate
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 Next. You're immediately prompted to save a data extraction as. Go into the My Files sub-folder and type the file name Furniture, click Save. Accept the default option here to define a data source, and click Next. This is a list of all of the objects you could potentially extract data from, right-click and choose Uncheck All, and then select armchair, chair, and desk, click Next. This a list of the properties that can be extracted from those selected objects. Deselect all of the different categories except for attribute, then click Next. This is a preview of the spreadsheet that you are extracting. You have an opportunity here to sort the columns by clicking on their headers. Click on Name to sort in forward alphabetical order, click Next. Here lets output the data to an external file, check this option. And then click this Ellipsis button to specify the path, go into your Chapter folder and My Files sub-folder, and select the name office10.xls, Save and Next.
Finally, click Finish, the data was extracted. Now, we need to open that in Excel. Browse to the My Files sub-folder, and double-click Office 10. Here we have all of the data here in the cells of this spreadsheet. Notice, that these cells have little tabs in the corner, there's a warning on these cells, the number in the cell is formatted as text. Let's change that, convert to number, do the same thing in each one of these cells.
Excel will then be able to add up the numbers, once it understands what this type of data is. Right click on the E column header and choose Insert, Select these cells and Copy them to the Clipboard. Target this cell and then Paste the information in there. Right click on A and chose Delete. That way we have account next to the price.
Over here, let's type equals. Click on this Cell, type the Asterisks to mean multiply by, and then click this Cell and press Enter. Select this cell and drag it down from this corner to copy that information into the next two cells. Down here, let's create a sum and press Enter.
Let's Rename this tag name to the full word Manufacturer, Rename this in title case and type model Number. Change this price in all caps to price in title case, and then let's call this one Totals. We'll just drag these column headers to reveal the full titles.
Okay, I think the data is formatted well enough, let's click Save. In this video, you went through the steps of AutoCad's data extraction wizard to select and format specific data for export to Excel. You also opened the extracted file in Excel and edited the data.