CAD tip # 13784:

Question CAD
% platform category

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

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

* CAD

13.7.2023 58586×

Comments Tell a friend

Prices - CAD eShop:

applies to: AutoCAD · AutoCAD LT 2024 · AutoCAD Architecture · AutoCAD Mechanical ·

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.

Selected tip: Import AutoCAD 3D DWG files into Inventor.

Back All CAD Tips

Green square - mathematical charade and parametric constraints in AutoCAD. « | » How to publish several DWG drawings into one multi-page PDF?

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: OS: Categ:
Text:	FAQ glossary

Featuring:
Publish interactive 3D PDF models from AutoCAD, Inventor or Revit with Share3D 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.

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, Forma, 3ds Max and other Autodesk software (support by Arkance Systems) - see About	Arkance Systems CZ s.r.o. (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner	CONTACT: webmaster.cz@arkance-systems.com tel. +420 910 970 111
	Copyright © 2024 \| Advertise with us \| Online privacy

CZ \| EN \| DE
Login or
registration
	Visitors: 8084