PTXPORT-bgol (Export Point Data to CSV)

Command Type: AutoLISP routine (works in AutoCAD, BricsCAD, ZWCAD and most AutoLISP-compatible CAD platforms)
Developed by: BGol Community, bgol.in

Inspired by the general concept of point-data CSV export utilities used in survey/CAD drafting. This is an original, independently written routine, new file name, new command name, new source code, created so the CAD community has a free, editable, open-source alternative.

Overview

PXYZ extracts point coordinate data (X/Easting, Y/Northing, Z/Elevation) plus each point's text caption from selected TEXT entities and writes it out as rows in a Comma Separated Values (CSV) file, the reverse direction of a typical Total Station import, useful for reporting, further processing, or reimport into other software.

How to Use

1. Load PTXPORT-bgol.lsp into your CAD session (drag-and-drop the file onto the drawing window, or use the APPLOAD command).
2. Type PXYZ at the command line and press Enter.
3. Select the TEXT entities representing point data, then press Enter to confirm.
4. Choose a destination .csv file in the save dialog that appears.
5. Each selected text's X, Y, Z insertion-point coordinates and its caption are written as one CSV row (Easting,Northing,Elevation, Value). A small marker point is placed at each exported text's location on layer BGOL-PXYZ (colour blue) so the exported set can be reviewed visually in the drawing.

Why Use It

• Bridges CAD and Spreadsheet Workflows, converts drawing-embedded coordinate data into a portable, spreadsheet-ready CSV format.
• Preserves Full Point Data, captures X, Y, Z, and the associated text caption together in one export.
• Time Savings, automates what would otherwise require manually reading each text's Properties panel position and typing it into a spreadsheet.

Where to Use It

• Extracting point coordinate data from a CAD drawing back into a CSV/Excel format for reporting, further analysis, or import into other survey or GIS software.
• Any workflow needing a structured coordinate list (Easting, Northing, Elevation, and label) derived from text-based point markers already present in a drawing.
• Cross-checking or archiving point data that originated from Total Station imports.

Notes

• Coordinates are written with 4 decimal places using rtos mode 2 (decimal).
• If the destination file cannot be opened for writing (e.g. permissions, invalid path), the command reports the failure and no data is lost from the drawing.
• Source code is fully open, feel free to study, modify, and redistribute it under the same open, free-for-all spirit.

Credits

Developed and shared for the CAD community by BGol Community. Website: https://bgol.in/ Free and open-source, use it, modify it, share it, for personal or commercial work alike.