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

Поделиться
HTML-код
  • Опубликовано: 1 дек 2024

Комментарии • 96

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

  • @qwerty62902
    @qwerty62902 Год назад

    Thank you so much 🙏

  • @travel4work
    @travel4work 2 года назад

    huge help thanks for this!

    • @LearnExplore
      @LearnExplore  2 года назад

      Welcome. Thank You for your valuable feedback 😊

  • @rumelian
    @rumelian 2 года назад

    thank you! God bless U

  • @a.person8514
    @a.person8514 Год назад

    THANK YOU! 🎉

  • @rajashekar7452
    @rajashekar7452 5 лет назад

    Really thank u very very very much for u channel

  • @abdulazizibrahim7529
    @abdulazizibrahim7529 Месяц назад

    Good explanation

  • @surveyingengineeringdesigninfo
    @surveyingengineeringdesigninfo 3 года назад +1

    Good Working

  • @ginoongboyong
    @ginoongboyong 4 года назад

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

  • @kalyanmaity2021
    @kalyanmaity2021 2 года назад

    Awesome learning sir 🙏

  • @debobratapatra9247
    @debobratapatra9247 3 года назад

    Very good explain

  • @jamal6015
    @jamal6015 6 лет назад

    Good, I will try it tomorrow as you shown us

  • @Wasiqpathanking
    @Wasiqpathanking 3 года назад

    Perfect 👌🏻 video

  • @salmanyounis
    @salmanyounis 4 года назад

    thank you. this video really helped me a lot.

  • @ahamedsabryac4951
    @ahamedsabryac4951 7 лет назад

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

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

  • @pradyumnabehera3676
    @pradyumnabehera3676 11 месяцев назад

    Thankyou very much sir

  • @akhtarhussain3263
    @akhtarhussain3263 5 лет назад

    Thank you very much for uploading this video

  • @Hitngan
    @Hitngan 4 года назад

    Thanks very useful

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

  • @ayoubdoughmi9415
    @ayoubdoughmi9415 4 года назад

    Thank you so much, you're the best 🙏

  • @ba-dum_tss
    @ba-dum_tss 2 года назад

    Thanks a lot

  • @ZuzaCuban
    @ZuzaCuban Год назад

    Thank you

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

  • @tousifsayyed7
    @tousifsayyed7 5 лет назад

    Usefull video ...Greater job bro..

  • @civilengineering1410
    @civilengineering1410 Год назад

    Good video

  • @nizamuddin8418
    @nizamuddin8418 5 лет назад

    Thanks bro, relay I have benefited.

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

  • @mdzamirulhaque3345
    @mdzamirulhaque3345 2 года назад

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

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

  • @Mostafa20268
    @Mostafa20268 6 лет назад

    Thank you so much..liked and subbed.

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

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

  • @malikarfan3597
    @malikarfan3597 2 года назад

    Points from Autocad to excel please make video

    • @LearnExplore
      @LearnExplore  2 года назад

      Select points and use list command

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

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

  • @Humanityforworld
    @Humanityforworld 6 лет назад

    Wow very good

  • @md.mustafizurrahman4628
    @md.mustafizurrahman4628 4 года назад

    thanks

  • @ramavtartirdhiya2235
    @ramavtartirdhiya2235 3 года назад +1

    WHAT ABOUT Z CORDINATES

  • @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 ruclips.net/video/AEeYQ_Nwtr0/видео.html

  • @chamd6310
    @chamd6310 7 лет назад

    THANK YOU VERY MUCH :)

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

  • @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.
      ruclips.net/video/DWNJzkERW0s/видео.html

    • @2005panka
      @2005panka 2 года назад

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

  • @tauseefcheema4952
    @tauseefcheema4952 6 лет назад

    Great

  • @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
      ruclips.net/video/LDoWydribuY/видео.html

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

  • @tamilselvan4079
    @tamilselvan4079 3 года назад

    Sir column coordinator I'd number command please sir

  • @sivamwprasanth
    @sivamwprasanth 4 года назад

    Malayalee analle

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

  • @tutorial-teknik-drawing
    @tutorial-teknik-drawing 5 лет назад

    Plis subtitle Indonesia bro

  • @AbdulWahab-kg3gm
    @AbdulWahab-kg3gm Год назад

    Plz send lisp

  • @debasishmaity9496
    @debasishmaity9496 Год назад

    Plz translate for hindi

  • @AbdulWahab-kg3gm
    @AbdulWahab-kg3gm Год назад

    Plz send lisp