Community
AutoCAD Forum
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Convert points xyz into excel

14 REPLIES 14
SOLVED
Back to AutoCAD Category
Back to Topic Listing
Reply
Message 1 of 15
ishaq03
Advocate
1438 Views, 14 Replies
‎10-19-2021 06:39 AM

Convert points xyz into excel

ishaq03
Advocate
Advocate
‎10-19-2021 06:39 AM

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.

Points File-01.dwg
0 Likes
‎10-19-2021 06:39 AM

Convert points xyz into excel

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.

Points File-01.dwg
Report
0 Likes
Reply
14 REPLIES 14
Message 2 of 15
ВeekeeCZ
Consultant
in reply to: ishaq03
‎10-19-2021 06:49 AM

ВeekeeCZ
Consultant
Consultant
‎10-19-2021 06:49 AM

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

 

Z9E3zK5E_0-1634651472291.png

 

0 Likes
‎10-19-2021 06:49 AM

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

 

Z9E3zK5E_0-1634651472291.png

 

Report
0 Likes
Reply
Message 3 of 15
Alfred.NESWADBA
Consultant
in reply to: ishaq03
‎10-19-2021 06:58 AM

Alfred.NESWADBA
Consultant
Consultant
‎10-19-2021 06:58 AM

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

(not an Autodesk consultant)
0 Likes
‎10-19-2021 06:58 AM

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

(not an Autodesk consultant)
Report
0 Likes
Reply
Message 4 of 15
ishaq03
Advocate
in reply to: ВeekeeCZ
‎10-19-2021 08:57 AM

ishaq03
Advocate
Advocate
In response to ВeekeeCZ
‎10-19-2021 08:57 AM

Not 6,50,000 its only 65,000

0 Likes
‎10-19-2021 08:57 AM

Not 6,50,000 its only 65,000

Report
0 Likes
Reply
Message 5 of 15
ishaq03
Advocate
in reply to: Alfred.NESWADBA
‎10-19-2021 08:58 AM

ishaq03
Advocate
Advocate
In response to Alfred.NESWADBA
‎10-19-2021 08:58 AM

Surveyor need the points in csv format 

0 Likes
‎10-19-2021 08:58 AM

Surveyor need the points in csv format 

Report
0 Likes
Reply
Message 6 of 15
ВeekeeCZ
Consultant
in reply to: ishaq03
‎10-19-2021 09:04 AM

ВeekeeCZ
Consultant
Consultant
‎10-19-2021 09:04 AM

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
‎10-19-2021 09:04 AM

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

Report
0 Likes
Reply
Message 7 of 15
ishaq03
Advocate
in reply to: ВeekeeCZ
‎10-19-2021 09:13 AM

ishaq03
Advocate
Advocate
In response to ВeekeeCZ
‎10-19-2021 09:13 AM

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

0 Likes
‎10-19-2021 09:13 AM

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

Report
0 Likes
Reply
Message 8 of 15
Pointdump
Mentor
in reply to: ishaq03
‎10-19-2021 09:34 AM

Pointdump
Mentor
Mentor
In response to ishaq03
‎10-19-2021 09:34 AM
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
65292 KB
‎10-19-2021 09:34 AM

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
65292 KB
Report
Reply
Message 9 of 15
ishaq03
Advocate
in reply to: Pointdump
‎10-19-2021 10:50 AM

ishaq03
Advocate
Advocate
In response to Pointdump
‎10-19-2021 10:50 AM

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

0 Likes
‎10-19-2021 10:50 AM

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

Report
0 Likes
Reply
Message 10 of 15
Pointdump
Mentor
in reply to: ishaq03
‎10-19-2021 01:12 PM

Pointdump
Mentor
Mentor
In response to ishaq03
‎10-19-2021 01:12 PM

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
‎10-19-2021 01:12 PM

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
Report
0 Likes
Reply
Message 11 of 15
ishaq03
Advocate
in reply to: Pointdump
‎10-19-2021 09:33 PM

ishaq03
Advocate
Advocate
In response to Pointdump
‎10-19-2021 09:33 PM

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
‎10-19-2021 09:33 PM

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.

Report
0 Likes
Reply
Message 12 of 15
ishaq03
Advocate
in reply to: ishaq03
‎10-19-2021 09:55 PM

ishaq03
Advocate
Advocate
In response to ishaq03
‎10-19-2021 09:55 PM

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

0 Likes
‎10-19-2021 09:55 PM

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

Report
0 Likes
Reply
Message 13 of 15
Alfred.NESWADBA
Consultant
in reply to: ishaq03
‎10-19-2021 10:55 PM

Alfred.NESWADBA
Consultant
Consultant
In response to ishaq03
‎10-19-2021 10:55 PM

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

(not an Autodesk consultant)
‎10-19-2021 10:55 PM

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

(not an Autodesk consultant)
Report
Reply
Message 14 of 15
ishaq03
Advocate
in reply to: Alfred.NESWADBA
‎10-19-2021 11:23 PM

ishaq03
Advocate
Advocate
In response to Alfred.NESWADBA
‎10-19-2021 11:23 PM

Thanks Alfred

0 Likes
‎10-19-2021 11:23 PM

Thanks Alfred

Report
0 Likes
Reply
Message 15 of 15
hmsilva
Mentor
in reply to: ishaq03
‎10-20-2021 01:13 AM

hmsilva
Mentor
Mentor
‎10-20-2021 01:13 AM
@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

pt2csv.lsp
0 Likes
‎10-20-2021 01:13 AM

@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

pt2csv.lsp
Report
0 Likes
Reply
Reply

Forums Links

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

AutoCAD Inside the Factory


Autodesk Design & Make Report

Report a website issue