Convert points xyz into excel

[ishaq03]

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.

[ВeekeeCZ]

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

[Alfred.NESWADBA]

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 -

[ishaq03]

Not 6,50,000 its only 65,000

[ishaq03]

Surveyor need the points in csv format 

[ВeekeeCZ]

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))

[ishaq03]

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

[Pointdump · 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

[ishaq03]

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

[Pointdump]

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

[ishaq03]

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.

[ishaq03]

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

[Alfred.NESWADBA]

Hi,

>> Can you send me QGIS software link

SCNR: >>>click<<<

- alfred -

[ishaq03]

Thanks Alfred

[hmsilva]

---

@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