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

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ธ.ค. 2024

ความคิดเห็น •

  • @LearnExplore
    @LearnExplore  7 ปีที่แล้ว +12

    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
    @engr.rashidiqbal237 4 ปีที่แล้ว

    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

  • @a.person8514
    @a.person8514 ปีที่แล้ว

    THANK YOU! 🎉

  • @travel4work
    @travel4work 2 ปีที่แล้ว

    huge help thanks for this!

    • @LearnExplore
      @LearnExplore  2 ปีที่แล้ว

      Welcome. Thank You for your valuable feedback 😊

  • @qwerty62902
    @qwerty62902 2 ปีที่แล้ว

    Thank you so much 🙏

  • @rumelian
    @rumelian 2 ปีที่แล้ว

    thank you! God bless U

  • @abdulazizibrahim7529
    @abdulazizibrahim7529 2 หลายเดือนก่อน

    Good explanation

  • @Wasiqpathanking
    @Wasiqpathanking 3 ปีที่แล้ว

    Perfect 👌🏻 video

  • @rajashekar7452
    @rajashekar7452 5 ปีที่แล้ว

    Really thank u very very very much for u channel

  • @pradyumnabehera3676
    @pradyumnabehera3676 ปีที่แล้ว

    Thankyou very much sir

  • @kalyanmaity2021
    @kalyanmaity2021 2 ปีที่แล้ว

    Awesome learning sir 🙏

  • @ginoongboyong
    @ginoongboyong 4 ปีที่แล้ว

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

  • @akhtarhussain3263
    @akhtarhussain3263 5 ปีที่แล้ว

    Thank you very much for uploading this video

  • @jamal6015
    @jamal6015 6 ปีที่แล้ว

    Good, I will try it tomorrow as you shown us

  • @debobratapatra9247
    @debobratapatra9247 3 ปีที่แล้ว

    Very good explain

  • @surveyingengineeringdesigninfo
    @surveyingengineeringdesigninfo 3 ปีที่แล้ว +1

    Good Working

  • @Hitngan
    @Hitngan 4 ปีที่แล้ว

    Thanks very useful

  • @ZuzaCuban
    @ZuzaCuban ปีที่แล้ว

    Thank you

  • @ba-dum_tss
    @ba-dum_tss 2 ปีที่แล้ว

    Thanks a lot

  • @hamizanfakhri5898
    @hamizanfakhri5898 5 ปีที่แล้ว

    Thank you very much.

  • @prakashreddyk6317
    @prakashreddyk6317 2 ปีที่แล้ว

    thank you so much

    • @LearnExplore
      @LearnExplore  2 ปีที่แล้ว

      You are welcome sir. Please share our video

  • @salmanyounis
    @salmanyounis 4 ปีที่แล้ว

    thank you. this video really helped me a lot.

  • @ayoubdoughmi9415
    @ayoubdoughmi9415 4 ปีที่แล้ว

    Thank you so much, you're the best 🙏

  • @nizamuddin8418
    @nizamuddin8418 5 ปีที่แล้ว

    Thanks bro, relay I have benefited.

  • @civilengineering1410
    @civilengineering1410 ปีที่แล้ว

    Good video

  • @ahamedsabryac4951
    @ahamedsabryac4951 7 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  7 ปีที่แล้ว

      Thank you for ur support ☺️

  • @mocanumihai8023
    @mocanumihai8023 4 ปีที่แล้ว +3

    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
      @LearnExplore  4 ปีที่แล้ว

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

    • @2005panka
      @2005panka 2 ปีที่แล้ว

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

    • @derkaffeeistlangweilig
      @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

  • @tousifsayyed7
    @tousifsayyed7 5 ปีที่แล้ว

    Usefull video ...Greater job bro..

  • @Mostafa20268
    @Mostafa20268 6 ปีที่แล้ว

    Thank you so much..liked and subbed.

  • @Humanityforworld
    @Humanityforworld 7 ปีที่แล้ว

    Wow very good

  • @ashutoshsharma3189
    @ashutoshsharma3189 4 ปีที่แล้ว +1

    Can we do this same practice with blocks?

    • @LearnExplore
      @LearnExplore  4 ปีที่แล้ว +1

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

  • @md.mustafizurrahman4628
    @md.mustafizurrahman4628 4 ปีที่แล้ว

    thanks

  • @AshokTiwari-ti8iw
    @AshokTiwari-ti8iw 6 ปีที่แล้ว

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

  • @jinwang6985
    @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
      @LearnExplore  4 ปีที่แล้ว

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

    • @jinwang6985
      @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
      @LearnExplore  4 ปีที่แล้ว

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

  • @waqassiraj8599
    @waqassiraj8599 ปีที่แล้ว

    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

  • @tauseefcheema4952
    @tauseefcheema4952 6 ปีที่แล้ว

    Great

  • @pberezowski4630
    @pberezowski4630 2 ปีที่แล้ว

    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)

  • @chamd6310
    @chamd6310 7 ปีที่แล้ว

    THANK YOU VERY MUCH :)

  • @oyediranoluwatobi6150
    @oyediranoluwatobi6150 5 ปีที่แล้ว +1

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

    • @engr.rashidiqbal237
      @engr.rashidiqbal237 4 ปีที่แล้ว

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

  • @kimonas70
    @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
      @LearnExplore  3 ปีที่แล้ว +1

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

  • @georgele6095
    @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
      @LearnExplore  5 ปีที่แล้ว

      Already video uploaded in this topic

  • @mdzamirulhaque3345
    @mdzamirulhaque3345 3 ปีที่แล้ว

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

  • @malikarfan3597
    @malikarfan3597 2 ปีที่แล้ว

    Points from Autocad to excel please make video

    • @LearnExplore
      @LearnExplore  2 ปีที่แล้ว

      Select points and use list command

  • @SHAHRUKHkhan-rw6cq
    @SHAHRUKHkhan-rw6cq 6 ปีที่แล้ว

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

    • @LearnExplore
      @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
      @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

  • @kamleshkumar-dv9ts
    @kamleshkumar-dv9ts 4 ปีที่แล้ว

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

    • @LearnExplore
      @LearnExplore  4 ปีที่แล้ว

      Watch this your problem may solved th-cam.com/video/AEeYQ_Nwtr0/w-d-xo.html

  • @BIM-Infrastructure
    @BIM-Infrastructure 6 ปีที่แล้ว +1

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

    • @LearnExplore
      @LearnExplore  6 ปีที่แล้ว +2

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

    • @BIM-Infrastructure
      @BIM-Infrastructure 6 ปีที่แล้ว +4

      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
      @BIM-Infrastructure 6 ปีที่แล้ว +1

      I have added a video about DataExtraction please watch the link below.
      th-cam.com/video/DWNJzkERW0s/w-d-xo.html

    • @2005panka
      @2005panka 2 ปีที่แล้ว

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

  • @sivamwprasanth
    @sivamwprasanth 4 ปีที่แล้ว

    Malayalee analle

  • @ramavtartirdhiya2235
    @ramavtartirdhiya2235 3 ปีที่แล้ว +1

    WHAT ABOUT Z CORDINATES

  • @densherpa
    @densherpa 3 ปีที่แล้ว

    Its ok but where is level,is there any formula to get level

    • @LearnExplore
      @LearnExplore  3 ปีที่แล้ว

      Use command 3P instead of PL to draw the line and then apply the same process

  • @nazirkhan8128
    @nazirkhan8128 6 ปีที่แล้ว

    How we can get z in same method

    • @LearnExplore
      @LearnExplore  6 ปีที่แล้ว

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

  • @tutorial-teknik-drawing
    @tutorial-teknik-drawing 5 ปีที่แล้ว

    Plis subtitle Indonesia bro

  • @ShahzadAhmad-cl8gu
    @ShahzadAhmad-cl8gu 6 ปีที่แล้ว

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

    • @LearnExplore
      @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
      @LearnExplore  6 ปีที่แล้ว

      As per your question
      th-cam.com/video/LDoWydribuY/w-d-xo.html

  • @raops-u4y
    @raops-u4y 21 วันที่ผ่านมา

    bro your audi is not at all clear, it is very difficult to understand what you are saying. I wish, you, to improve the clarity of your audio while recording. Thank you. You got a very good concept of subject.

  • @civillearnertamil4597
    @civillearnertamil4597 4 ปีที่แล้ว

    Sir suddenly list comment dissappears

    • @LearnExplore
      @LearnExplore  4 ปีที่แล้ว

      Press F2 then you will find text box and then copy your desired data

  • @tamilselvan4079
    @tamilselvan4079 4 ปีที่แล้ว

    Sir column coordinator I'd number command please sir

  • @AbdulWahab-kg3gm
    @AbdulWahab-kg3gm ปีที่แล้ว

    Plz send lisp

  • @debasishmaity9496
    @debasishmaity9496 ปีที่แล้ว

    Plz translate for hindi

  • @AbdulWahab-kg3gm
    @AbdulWahab-kg3gm ปีที่แล้ว

    Plz send lisp