CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 4347

CAD tip CAD tip # 13784:

   
Question CAD 
 %  platform  category 
Q - question

Export block coordinates to a table. How to use the DATAEXTRACTION command in AutoCAD LT?

A - answer AutoCAD LT does not offer the DATAEXTRACTION command, but you can use one of the most common variants of this command - exporting block coordinates - even in AutoCAD LT. At least since version 2024, which supports LISP applications.

Using a freeware utility by Arkance Systems - BlockCoords - you can easily export the coordinates of selected blocks, including their attributes if any, from both AutoCAD and AutoCAD LT to a CSV table for Excel.

Download the BlockCoords application from Download, load it into your CAD using APPLOAD and type the BLOCKCOORDS command. Select an example of the block you want to export, and then all the references of that block you want to export (e.g. All). The application will create a .CSV file in the current working folder (with the same name as your DWG drawing) with a list of X,Y,Z coordinates and values of all block attributes.

The CSV file uses the correct Excel delimiter and an automatic header - no need to set anything.

Sample output:

X;Y;Z;"NUMBER"
2618.603164;1648.992874;0;"6"
2626.207808;1649.933546;0;"5"
2636.270122;1646.061134;0;"4"
2640.223405;1634.706376;0;"3"
2640.223119;1628.098149;0;"2"
2638.393498;1616.722316;0;"1"

BlockCoords in use:

In V1.1 we have added support for dynamic blocks and showed a mod for export of rotation angles (uncomment the second lines with "***" and comment the first ones).

In older versions of AutoCAD LT you can use the Export XYZ function from our LT Extension for a similar purpose.

ACADACLT2024ADTACADM
100% *  CAD 
13.7.2023    59273×  

See also:
Tip 14059:Import coordinates from CSV files into Fusion profiles.
Tip 12926:How to import point coordinates from Excel to AutoCAD?
Tip 11913:Simple export of vertex-coordinates from a selected polyline.
Tip 11776:Export XYZ coordinates of DWG objects from AutoCAD LT.
Tip 11076:Reading and displaying 3D point matrix from a CSV file.


Back   All CAD Tips



Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Generate hatch patterns automatically from your DWG drawings with
HGEN 2006 More info


Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist