CAD tip # 13784:

Using a freeware utility by ARKANCE - BlockCoords - you can easily export the coordinates of selected blocks, including their attributes, if any, and dynamic properties (incl. visibility state), 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).