Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Convert points xyz into excel

ishaq03
Advocate

Convert points xyz into excel

ishaq03
Advocate
Advocate

I have a almost 1,00,0000 points in my cad file, I would like to export all the points geometry in excel means xyz. I have been Tried with data extraction command but the command allowing me only upto 650000 geomatry points, Please anyone either provide me a lisp or solution for this dwg. For your reference I attached the dwg here. 

Note: It's top urgent please.

0 Likes
Reply
Accepted solutions (1)
1,849 Views
14 Replies
Replies (14)

ВeekeeCZ
Consultant
Consultant

So select less than 650.000 and make it twice... Where's the issue?

 

Z9E3zK5E_0-1634651472291.png

 

0 Likes

Alfred.NESWADBA
Consultant
Consultant

Hi,

 

>> I have a almost 1,00,0000 points in my cad file, I would like

>> to export all the points geometry in excel

Be careful, Excel can not show more than 1.048.576 lines (and I would not try to use them all 😉 ).

What are you trying to do with these amount of points in Excel?

 

- alfred -

------------------------------------------------------------------------------------
Alfred NESWADBA
ISH-Solutions GmbH / Ingenieur Studio HOLLAUS
www.ish-solutions.at ... blog.ish-solutions.at ... LinkedIn ... CDay 2025
------------------------------------------------------------------------------------

(not an Autodesk consultant)
0 Likes

ishaq03
Advocate
Advocate

Not 6,50,000 its only 65,000

0 Likes

ishaq03
Advocate
Advocate

Surveyor need the points in csv format 

0 Likes

ВeekeeCZ
Consultant
Consultant

Use a log file and this line

(progn (repeat (setq i (sslength (setq s (ssget "_x" '((0 . "POINT")))))) (princ "\n") (princ (cdr (assoc 10 (entget (ssname s (setq i (1- i)))))))) (princ))

0 Likes

ishaq03
Advocate
Advocate

Sorry I didn't get you idea Please explain me in detail

0 Likes

Pointdump
Mentor
Mentor
Accepted solution

Hi Syed,
Wow, 997888 Points! Your finger must be tired from all that clicking! If you didn't create all those points, how did they get in your drawing?
No matter. Here you go. CSV attached.
Dave

 

Dubai_1.png

 

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024

ishaq03
Advocate
Advocate

Thank u very much, Please tell me how did you extract this points.

0 Likes

Pointdump
Mentor
Mentor

Syed,
I used Civil 3D to MAPEXPORT the points as a Shapefile. In QGIS I saved the Point Shapefile as CSV. There's probably more ways to do this, but this seemed fastest.
Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Likes

ishaq03
Advocate
Advocate

Dave,

Thanks once again for your quick response and solution, I have been tried to convert this points in as a cogo in civil3d but it's taking time process my system hanging because of the quantity of points. Any how your solution is more faster if we have a mass point quantities.

0 Likes

ishaq03
Advocate
Advocate

Can you send me QGIS software link if it's free or trial version.

0 Likes

Alfred.NESWADBA
Consultant
Consultant

Hi,

 

>> Can you send me QGIS software link

SCNR: >>>click<<<

 

- alfred -

------------------------------------------------------------------------------------
Alfred NESWADBA
ISH-Solutions GmbH / Ingenieur Studio HOLLAUS
www.ish-solutions.at ... blog.ish-solutions.at ... LinkedIn ... CDay 2025
------------------------------------------------------------------------------------

(not an Autodesk consultant)

ishaq03
Advocate
Advocate

Thanks Alfred

0 Likes

hmsilva
Mentor
Mentor

@ishaq03 wrote:

I have a almost 1,00,0000 points in my cad file, I would like to export all the points geometry in excel means xyz. I have been Tried with data extraction command but the command allowing me only upto 650000 geomatry points, Please anyone either provide me a lisp or solution for this dwg. For your reference I attached the dwg here. 

Note: It's top urgent please.


@ishaq03 try the attached file....

 

Hope this helps,
Henrique

EESignature

0 Likes