Have you use data extraction? You can extract any properties from any objects in your drawings with data extraction. I believe some of you have seen a nice demo from Autodesk about this. They use a data set to create door schedule from a drawing. It count the number of door blocks, and report it on a table.
Data extraction actually can extract any data, not only from blocks. Lines, points, rectangle… any data! You might want to have a hole table, benchmark coordinates, or estimate pipe length from your drawing. Sure, AutoCAD might not the perfect solution, but if that what you have, data extraction might help you.
In this example I will try to extract data from lines. I draw several lines as shown below. Of course, you might want to use real data, better than mine :)
I created them in three layers. Imagine this layers define pipe size. If I draw pipe layout in my plan, I can generate a report how many pipe I will use. To understand more about this data extraction, I override color in some lines. Not by layer, but define it’s color. You can activate data extraction on blocks and references TAB. On linking & extraction section. After you activate the tool, then a wizard will open. There are 8 steps you must follow before you can have your report. Trust me, these 8 steps are not scary at all :D Here you must define, are you going to define a new data extraction or use previous extraction settings. Let’s just use create new data extraction now. Click next. Type a setting file name. For example: lines.dxe. Next step, you must define your data source. Are you going to generate reports from all objects in your drawing (includes reference, nested blocks) or just some objects you selected. Let’s just use select objects in current drawing, click the pick button on the right side of this option. Select all your lines, then [enter]. Click next. If you have different type of objects in your previous selection, you will see them here. You can filter what kind of objects you want to include (or exclude) in your report. In my drawing I only have lines, so that’s the only thing shown here. After finish selecting your object, then click next. Next, you will see the list of your object properties. What you will see depends on what you choose on the previous step. Line properties, grouped into 4 categories (column on the right). I only want to report general properties and geometry. I turn off the others. See image below. I select length, start X & Y, end X & Y, delta X & Y, layer name, and object color. You can choose other than these example to suit your needs. After this one, the rest is easy. You will see a preview of your report here. You can sort the table by clicking the header column, arrange the column by dragging the header and change some options. Preview if necessary. Where do you want to put your table? In the drawing or to excel file, or both? Choose a table style you want to use. This step won’t appear if you don’t choose your output to drawing. Choose appropriate table style for your output. Well… there’s nothing to do here but click the finish button. Here is my report. You might need to process your data further, you can do it easily in Excel or in your AutoCAD. Easy isn’t it? So what kind of reports that you might want to create with data extraction? I would love to discuss it with you here. 
1. Begin
2. Define Data Source
3. Select Objects
4. Select Properties
5. Refine Data
6. Choose Output
7. Table Style
8. Finish
Share this Post!
Rate This Post
(No Ratings Yet)
Loading ...
Application Engineer. Jakarta, Indonesia.
5+ years experience as CAD engineering application. AutoCAD, MicroStation, Inventor, Autodesk Revit Architecture 2010 certified professional, and certified CATIA part design specialist. Here are some topics I am currently focusing on 
I use the DATAEXTRACTION feature just like you and AutoCAD’s help tell me to. On Step 5 I do a preview. Everything looks good. At the end, whether I choose insert a table or output data to an Excel file, I get nothing. Well, it creates an Excel file, but only one cell, A1, has anything in it, “DeleteMe”. I’ve used it before and it worked. What happened? How do I fix it?
I found similar threads in many AutoCAD forums, and it looks like it’s not solved yet. The workaround is to save it as csv, not xls. You can save it to xls with Excel, then insert it to AutoCAD using datalinks. I tried to search in Autodesk support page and can’t find this issue.
I’m interested because it works before. Have you tried to install AutoCAD updates and reinstall it? Is it a machine specific or file specific problem?
I am using AutoCAD 2009 with SP1 & SP2. I have not tried searched for more recent service packs or tried to reinstall AutoCAD because we have recently recived 2010 and it will be getting installed within the next few days. The problem occurs on all files, and only on my computer. Other users in my department do not have the problem. My 2009 will be transfered to another user, so please let me know if a solution is found in case it occurs again.
I had not tried saving it as a CSV file. I was not familiar with that file type, so I ignored it. For now, it does work, though. If I find out anything more about it, I’ll let you know. Thank you very much for your help!
I’ve used this for years now (since 2008) and only recently, just out of the blue, it started with the “Deleteme” issue. I have no idea what caused it. But it’s strange to use this feature for so long and just like that, it does it.
One workaround I’ve read about, and it does work for me, is to save the file to my local hard drive instead of the network drive of the project folder. For whatever reason, this works. I just have the small inconvenience of having to move the file from my desktop to the network folder after-wards.