Export X Y Z coordinates from AutoCAD to Excel direct! [English]

No video

Export X Y Z coordinates from AutoCAD to Excel direct! [English]

Рет қаралды 226,698

7 жыл бұрын

Sometimes we need to export data (X,Y co-ordinates or Easting,Northing) from AutoCAD drawing.
Here in this video I have showed the method by which you could export X Y Values from autoCad drwaing to Excel with just few minutes.
what is in this tutorial?
1) how to export coordinates from autocad to excel
2) how to use LIST Command in autocad
3) how to extract coordinates from autocad to excel
4) How to export XYZ Coordinates from autocad to excel
5) how to collect coordinates from autocad
If you like this video then
Give a LIKE in the video and
SUBSCRIBE us and keep supporting!
watch more tutorials related to AutoCAD and Excel:
(How to import Points/X,Y Co-ordinates)
• How to import X Y coor...
(How to import Lines from excel to AutoCAD)
• How to Create a Topo M...
(How to import Texts from excel to AutoCAD)
• How to Import Texts fr...
Like & Share this video and Subscribe our channel to get free updates
With best wishes
L&E Team!

Пікірлер: 96

@LearnExplore 6 жыл бұрын

I invested lot of time to prepare this video! for this if you wanna gift something to me then just SUBSCRIBE our channel and stay connected with us! (Its free!) Donate us here: www.paypal.me/learnxplore

@engr.rashidiqbal237 3 жыл бұрын

I liked the vedio becuase of your comment, if you like the video like it and if you dislike, dislike is....Thats a good point,,,, I liked it ...Thanks

@surveyingengineeringdesigninfo 3 жыл бұрын

Good Working

@qwerty62902 Жыл бұрын

Thank you so much 🙏

@arifengineeronline 16 күн бұрын

Good !

@a.person8514 Жыл бұрын

THANK YOU! 🎉

@ginoongboyong 4 жыл бұрын

Waw! Thank you very much! This is very helpful.

@pradyumnabehera3676 7 ай бұрын

Thankyou very much sir

@rajashekar7452 5 жыл бұрын

Really thank u very very very much for u channel

@travel4work Жыл бұрын

huge help thanks for this!

@LearnExplore Жыл бұрын

Welcome. Thank You for your valuable feedback 😊

@waqassiraj8599 10 ай бұрын

IF WE WANT COORDINATES SEQUENCE NUMBERS ALSO ALONG WITH XY COORDINATES THEN WHAT IS THE OPTION THE ONE IS SHOWING IN POLYLINE I WANT THAT SEQUENCE NUMBERS IN EXCEL ALSO

@debobratapatra9247 3 жыл бұрын

Very good explain

@kalyanmaity2021 Жыл бұрын

Awesome learning sir 🙏

@hamizanfakhri5898 4 жыл бұрын

Thank you very much.

@mdzamirulhaque3345 2 жыл бұрын

Bhai video mst hai,pr hindi bol kr bnaiyega qki sbko English smjh nhi lgti hai.

@akhtarhussain3263 5 жыл бұрын

Thank you very much for uploading this video

@rumelian 2 жыл бұрын

thank you! God bless U

@LearnExplore 2 жыл бұрын

You are welcome

@jamal6015 5 жыл бұрын

Good, I will try it tomorrow as you shown us

@Wasiqpathanking 3 жыл бұрын

Perfect 👌🏻 video

@mocanumihai8023 4 жыл бұрын

Hello. Thank you for the videos. But if we only have random points that are not joined by a poly line how can we extract the coordinates?

@LearnExplore 4 жыл бұрын

We will make video on this topic. Soon. Stay tuned.

@2005panka 2 жыл бұрын

Very easy .. use command( Data extraction )..

@derkaffeeistlangweilig Жыл бұрын

guess you can use text2csv lisp drive.google.com/file/d/18ZPtK3aQ4HThw3B8Cfrz6pwRnEpOYsXK/view?usp=share_link text2csv select the layer select the folder give file name

@Hitngan 3 жыл бұрын

Thanks very useful

@user-ie6uf7nt7p 10 ай бұрын

Thank you

@ba-dum_tss 2 жыл бұрын

Thanks a lot

@civilengineering1410 11 ай бұрын

Good video

@AshokTiwari-ti8iw 5 жыл бұрын

Useful video. But, I have hollow sphere in CAD and want to extract the coordinates of its center, how can i do that?

@salmanyounis 4 жыл бұрын

thank you. this video really helped me a lot.

@LearnExplore 4 жыл бұрын

Glad it helped!

@prakashreddyk6317 Жыл бұрын

thank you so much

@LearnExplore Жыл бұрын

You are welcome sir. Please share our video

@ayoubdoughmi9415 3 жыл бұрын

Thank you so much, you're the best 🙏

@LearnExplore 3 жыл бұрын

You are welcome. 🙂

@ahamedsabryac4951 6 жыл бұрын

wow... what a easiest method. you are great. keep going... i support to you .

@LearnExplore 6 жыл бұрын

Thank you for ur support ☺️

@nizamuddin8418 5 жыл бұрын

Thanks bro, relay I have benefited.

@tousifsayyed7 5 жыл бұрын

Usefull video ...Greater job bro..

@pberezowski4630 Жыл бұрын

get your points on separate layer, turn off the rest of the layers and type dataextraction, select points and enter, then follow screen ( points are not in order)

@Mostafa20268 5 жыл бұрын

Thank you so much..liked and subbed.

@kimonas70 3 жыл бұрын

Nice vid. But how I will get the point to excel in specific order? I mean the first point of polyline to be in the first row in my excel and so on?

@LearnExplore 3 жыл бұрын

Yes exactly what u think. The vertices will be exported in sequence

@ashutoshsharma3189 4 жыл бұрын

Can we do this same practice with blocks?

@LearnExplore 4 жыл бұрын

For blocks video is already uploaded.... Please check in playlist.

@md.mustafizurrahman4628 3 жыл бұрын

thanks

@Humanityforworld 6 жыл бұрын

Wow very good

@oyediranoluwatobi6150 5 жыл бұрын

how do i copy easting, northing and depth in autocad drawing into a csv file

@engr.rashidiqbal237 3 жыл бұрын

save your file of excel as a csv file....in the save as option

@georgele6095 5 жыл бұрын

great video!!! do you have video show how to draw pline. from a xcel data (x,y) to autocad.. or take coord from xcel file and draw it on autocad... thanks you very much

@LearnExplore 5 жыл бұрын

Already video uploaded in this topic

@jinwang6985 4 жыл бұрын

may I ask are the coordinates extracted this way the exact position of the map. WHat I extracted is not the same, and i found out there is no correlation between this coordinates with the map's real coordinates i fund using photoshop

@LearnExplore 4 жыл бұрын

By this method u will get exactly the same coordinate. No correlation between data.

@jinwang6985 4 жыл бұрын

@@LearnExplore thank you for the reply. Sorry i didn't make myself clear. e.g. I got X=30891888.19 Y=29655181.89, and using paint, I got another coordinates for the same point as X=3290 Y=2882. And using thi method i ave obtained a lot. and im trying to find a way to see how these two sets of coordinates are related. So far they are not, but i think they should be related through some transformation aren't they?

@LearnExplore 4 жыл бұрын

Coordinates depend upon scale factor. May be you imported the image in autocad in larger scale

@tauseefcheema4952 5 жыл бұрын

Great

@ramavtartirdhiya2235 3 жыл бұрын

WHAT ABOUT Z CORDINATES

@chamd6310 6 жыл бұрын

THANK YOU VERY MUCH :)

@LearnExplore 6 жыл бұрын

u r welcome! :)

@malikarfan3597 2 жыл бұрын

Points from Autocad to excel please make video

@LearnExplore 2 жыл бұрын

Select points and use list command

@SHAHRUKHkhan-rw6cq 6 жыл бұрын

Hello in this video how to take Z cordinate bcz its showing only 000 so plz help

@LearnExplore 6 жыл бұрын

Hi Actually the data I have choosen for the example there was no Z value because it is a 2D polyline. If you have the Z value in your data then use 3D POLYLINE COMMAND. I think the shortcut for the command is 3PL then list the 3D POLYLINE and extract coordinates.

@viswagarb9455 6 жыл бұрын

if you want export xyz your poly line should be 3d poly (3Dpoly) then only you can get Z value. thanks you Viswagar

@sivamwprasanth 3 жыл бұрын

Malayalee analle

@kamleshkumar-dv9ts 4 жыл бұрын

I want nothing eating nd code convert to auto CAD how please give guide

@LearnExplore 4 жыл бұрын

Watch this your problem may solved kzfaq.info/get/bejne/d6uVjLSQs93YomQ.html

@tutorial-teknik-drawing 5 жыл бұрын

Plis subtitle Indonesia bro

@AbdulWahab-kg3gm 8 ай бұрын

Plz send lisp

@nazirkhan8128 6 жыл бұрын

How we can get z in same method

@LearnExplore 6 жыл бұрын

To get the Z value u have to apply the same method

@BIM-Infrastructure 6 жыл бұрын

Data extraction (autocad command “DX” ) more easy than this method.

@LearnExplore 6 жыл бұрын

Could you please tell me what the DX command is? And in which version of AutoCAD this command is used?

@BIM-Infrastructure 6 жыл бұрын

Thank you for asking me about AutoCad Data extraction. Data extraction can export all Autocad drawing entities (poly line, circle, text, point etc...) details which is coordinates, layer name, block name, attribute value and line length, etc.. as Excel table or we can insert as a table in same drawing. I'm using Data extraction since 2010. you can access data extraction by typing "DATAEXTRACTION" or "DX" in AutoCAD command bar. for more details please subscribe my channel I'll upload a video about DATA EXTRACTION soon. Kind Regards, Saifudheen Pottoor

@BIM-Infrastructure 6 жыл бұрын

I have added a video about DataExtraction please watch the link below. kzfaq.info/get/bejne/er1-fd2cqri7YKc.html

@2005panka 2 жыл бұрын

You can use this command in 2016 or latest version .. DX ( Dataextraction )

@ShahzadAhmad-cl8gu 6 жыл бұрын

What about z?xy very easy please tell also about z

@LearnExplore 6 жыл бұрын

Z can be exported like the same way what is shown in this video. Just you have to use LIST command from the TOP view. And u hav to apply some filters in excel. And If the same is requested by more friends here then we will upload a video on exporting z values .

@LearnExplore 6 жыл бұрын

As per your question kzfaq.info/get/bejne/gqqfityV18_GpY0.html