How to import x,y,z coordinate from Excel to AutoCAD

Sdílet
Vložit
  • čas přidán 25. 08. 2024
  • Learn AutoCAD for free using this step-by-step AutoCAD tutorial series containing nearly 40 videos with lesson files sourcecad.com/...
    In this video, we have explained two different ways of importing coordinate data from excel to AutoCAD.
    Method 1: Import data using the script file
    Method 2: Importing data using excel formulas.
    The excel file used in the video is provided by Ajay Anand from XL n CAD CZcams channel. He has also explained the second method of importing the data from excel to AutoCAD.
    To learn more about Excel, CAD and other tools head over to his channel here / @ajayanandxlncad
    Don't forget to subscribe to his channel to receive updates when he uploads new videos.
    Download the Excel file used in the video using this link bit.ly/3W2Bbnr

Komentáře • 89

  • @sourcecad
    @sourcecad  Před 3 lety +1

    Learn AutoCAD for free using this step-by-step AutoCAD tutorial series containing nearly 40 videos with lesson files sourcecad.com/courses/autocad-essentials-course/

    • @dakariluca6577
      @dakariluca6577 Před 3 lety

      You prolly dont give a damn but does anybody know a tool to log back into an instagram account??
      I was stupid forgot my password. I appreciate any assistance you can give me!

    • @maxmack2150
      @maxmack2150 Před 3 lety

      @Dakari Luca Instablaster =)

    • @dakariluca6577
      @dakariluca6577 Před 3 lety

      @Max Mack I really appreciate your reply. I found the site on google and Im in the hacking process now.
      Seems to take a while so I will get back to you later when my account password hopefully is recovered.

    • @dakariluca6577
      @dakariluca6577 Před 3 lety

      @Max Mack it did the trick and I now got access to my account again. Im so happy!
      Thanks so much, you really help me out!

    • @maxmack2150
      @maxmack2150 Před 3 lety

      @Dakari Luca no problem xD

  • @mesuttasar21
    @mesuttasar21 Před 3 lety +9

    Is there any way for adding to drawing the point number too?

  • @paolofogaccia9455
    @paolofogaccia9455 Před 5 lety +2

    Lots of thanks for your video. Every step is clear.

  • @annac6086
    @annac6086 Před 2 lety +1

    Thanks so much for this! My first script file and it worked!

  • @christopherfairfowl5521
    @christopherfairfowl5521 Před 4 lety +1

    Excellent, very useful, works well with pline command for pipeline routs.

  • @shawn8181
    @shawn8181 Před 2 lety +1

    Wow! So easy. Thank you

  • @birtukankefyalew8935
    @birtukankefyalew8935 Před 3 lety +1

    Thank you very much, it is really helpful and has clear steps.

  • @josehernandez-rx2sz
    @josehernandez-rx2sz Před rokem +1

    great video, very useful, THANKS !! for the effort to share knowledge and skill !!! :)

  • @ramkandregula7241
    @ramkandregula7241 Před rokem

    So Helpful brother. Thank you

  • @Jackson_jpb
    @Jackson_jpb Před rokem

    Cara me ajudou demais, procurei muito por esse video. Havia achado somente com script e no meu programa não estava funcionando devidamente esse comando. Espero que agora de certo.

  • @oOTBONE77Oo
    @oOTBONE77Oo Před 2 lety +2

    Any chance you could show how to add a cord value at the side of a point as a easting, northing, height?.. thanks great vids 👍🏼

  • @RogerRiverson
    @RogerRiverson Před 5 měsíci

    Can this be used for inserting multiple block coordinates as well as attribute definitions?

  • @leebishop418
    @leebishop418 Před rokem

    Thanks very much for the clear solution

  • @ghaliahadhoud
    @ghaliahadhoud Před 2 měsíci

    Bravo 👏 👏 👏

  • @kameldachraoui6621
    @kameldachraoui6621 Před 2 lety +1

    super, thank you very much. Just a question, is it possible to make a label with the point.

  • @irushiama1681
    @irushiama1681 Před 3 měsíci

    thank you

  • @kherbachmohamed3270
    @kherbachmohamed3270 Před 4 lety +1

    Amazing ! So easy & simple

  • @josephsikandar1809
    @josephsikandar1809 Před 2 lety

    Thanks for help us

  • @rahmanrahmani2896
    @rahmanrahmani2896 Před 5 lety +2

    Fantastic and thankyou!

  • @zian.2493
    @zian.2493 Před 3 lety +1

    Thanks to this bro.

  • @awilliams6828
    @awilliams6828 Před 2 lety

    Fantastic this helped me today

  • @mohammadmoaaz9385
    @mohammadmoaaz9385 Před rokem

    very good lecture.

  • @alaiamalaina313
    @alaiamalaina313 Před 3 lety

    You saved my live

  • @rams0116
    @rams0116 Před 2 lety

    Excellent work brother

  • @OveranalyzingEverything
    @OveranalyzingEverything Před 3 lety +3

    What if i have only x and y coordinates and when i try to import script, it asks to specify insertion point

  • @dontletmedown4896
    @dontletmedown4896 Před 3 lety +2

    Can we add point no also

  • @sisurang
    @sisurang Před 5 lety +1

    many thanks

  • @para6205
    @para6205 Před 2 lety

    Thankyou so much!

  • @surveyingengineeringdesigninfo

    Informative video

  • @hansbegonia8540
    @hansbegonia8540 Před 3 lety

    big help..thanks!

  • @mr.sksharma
    @mr.sksharma Před 2 lety

    THANK YOU

  • @rocky8004
    @rocky8004 Před rokem

    Excellent

  • @randheermeerwal
    @randheermeerwal Před 3 lety

    Thanks very much dear

  • @surveyingengineeringdesigninfo

    Good working

  • @prabagara.s9705
    @prabagara.s9705 Před 2 lety

    Thanks useful one

  • @eraarif1847
    @eraarif1847 Před 3 lety

    Thanks so much sir

  • @madelinegile5700
    @madelinegile5700 Před 3 lety

    Thank you pp🥰♥️😄

  • @skamash1
    @skamash1 Před 4 lety +1

    Thanks but , whats happen to the point numbers, which they run fron one decimal to five decimals
    so the spacing is not equal, so what you do

  • @djpansetasthegreat2560

    hello! thanks a lot! What if i want to load and the ID column?

  • @malikjedda
    @malikjedda Před 5 lety +1

    wow ! Amazing.
    carry on.

  • @kato_emmanuel
    @kato_emmanuel Před 3 lety

    Thanks alot

  • @kuksiBG
    @kuksiBG Před 2 lety +1

    Does anyone know how to add also attributes to those points? i.e size: Lentgh: 2 m; Width: 3m?

  • @awgichewdagne8341
    @awgichewdagne8341 Před 4 lety

    Thanks alot.

  • @mohammedalsaqi2919
    @mohammedalsaqi2919 Před 3 lety

    thank to you bro it is assume

  • @kuksiBG
    @kuksiBG Před 2 lety

    Legend!

  • @mujahidawan8402
    @mujahidawan8402 Před 5 lety +1

    If I want too convert the point codes plz I can I perform

  • @Dee-kb3vw
    @Dee-kb3vw Před 2 lety

    Amazing! Can i import point label?

  • @zeabah952
    @zeabah952 Před 3 lety

    Awesome !

  • @muhhammedashifkhan1507
    @muhhammedashifkhan1507 Před 3 lety +1

    Coordinates links is not opening

  • @randheermeerwal
    @randheermeerwal Před 3 lety

    Please also help.. How i georeference a raw autocad data

  • @SuperGurumoorthy
    @SuperGurumoorthy Před 4 lety

    can I do this importing points or text into multiple layouts at one stretch?

  • @douglastranghese7270
    @douglastranghese7270 Před 4 lety

    What did this grouping of points represent?

  • @sebastienhouyoux4073
    @sebastienhouyoux4073 Před 2 lety

    very useful

  • @nabamanina
    @nabamanina Před 3 lety

    I don't have the scr file when I follow your step idk help me, please

  • @StrateOutdoors
    @StrateOutdoors Před 3 lety +2

    Second method works, the first method didn't carry over the data properly

  • @vikashkandula9730
    @vikashkandula9730 Před 4 lety

    If surveying points are given before and after excavation, how to take the qty of that excavation????

  • @markdanielmonton4373
    @markdanielmonton4373 Před 2 lety

    Can you help me, why keep staying at one point all corrdinates please help me

  • @thatnicebee
    @thatnicebee Před 5 měsíci

    Why it shows invalid point

  • @franciscoortega2045
    @franciscoortega2045 Před 4 lety

    HOW CAN I DO THIS FUCTION WITH A LOT OF BLOCK THAN HAVE HIS OWN CORDINATES X, Y AND A DIFERENNT OR VARIOS ATRIBUTES?,
    IS LIKE THE REVERSE PROCEDURE OF EXTRACTION BLOCK IN EXCEL
    HELP ME PLEASE

  • @AjayAnandXLnCAD
    @AjayAnandXLnCAD Před 5 lety +1

    👍

  • @daniyalmunawar1177
    @daniyalmunawar1177 Před 5 lety

    You are the best

  • @tesnaigan8381
    @tesnaigan8381 Před 2 lety

    it wont appear the script file upon searching at my Autocad

  • @eldarhusovic8646
    @eldarhusovic8646 Před 3 lety

    Why I cannot download the Excel file ?

  • @EARTHLING1977
    @EARTHLING1977 Před 2 lety

    ajay malayali thanne

  • @millivanilli4825
    @millivanilli4825 Před 2 lety

    Why do I get message: ''Invalid point'' even after following same procedures ? ☹

  • @rathodbaswaraj2300
    @rathodbaswaraj2300 Před 4 lety

    Hello sir i don't understand how do this
    when i paste in autocad then not showing points

    • @walternaz21
      @walternaz21 Před 3 lety +1

      You need to press "esc" to get out of command & zoom to extent of the drawing.

    • @asharjaulani8361
      @asharjaulani8361 Před 3 lety

      @@walternaz21 kind of stuck can l have your email please

  • @ppascasl
    @ppascasl Před 4 lety

    Te amo! haha

  • @RahulDas-wp6zn
    @RahulDas-wp6zn Před 10 měsíci

    What is x,y,z please help 😢

  • @paulnewton8938
    @paulnewton8938 Před 4 lety

    it takes half a day to sort this out when you should be setting out!!

  • @rathodbaswaraj2300
    @rathodbaswaraj2300 Před 4 lety

    please solve this problem

  • @hoolio7462
    @hoolio7462 Před 2 lety

    says invalid points

  • @villavan
    @villavan Před rokem

    Actually where is this useful?

    • @Dominic_2110
      @Dominic_2110 Před 8 měsíci

      While making profiles it is very useful