How to import X Y Z coordinates from Excel to AutoCAD

It is my excel sheet where I have already stored TS data that is the Easting, Northing and RLs of the various points with the help of this video you can import thousands of Coordinate points just at a minute ok, now I am going to create the formula for the coordinate that is =CONCATENATE (that is join several text strings into one text string.) ok. You have to double click on it that we have to provide the text separately for first text I have just select the easting point you have to press comma(,) second text that is select the northing value sorry, I have to select this one the comma(,) northing value comma(,) into again and the last one that is RL. So here I am providing all the points and now this is my easting northing and RL and am just simply drag , draw and drag it now here all my coordinates are here ok , you just have to simply copy it by right click and copy going to AutoCAD here no points is here you just have to choose your layer ok, your respective layer for your respective points of respective codes right now here you have you don’t have use the PO command , do not use the PO command because you have to put only multiple points comment here for that you have to go the Draw Menu select, select Point and multiple point, then you have to go the command bar right click on it and paste ok you can see with just within a second the whole coordinate points are pasted here so, now I am going to draw the 3D Poly Line which will join all this points together ok , with a simple command , you can also change the whole point format for that you just have to go the format point style , before that you have to select , Format > Point style and any one you want to that format you have to change , you can change according to your choice ok. Now I am going to draw 3D PolyLine over this all coordinate points for that I am again going to my Excel sheet here already copied the coordinates and RLs now I am going to my autocad sheet here you have to type 3P in command bar you have to type 3P for 3d PolyLine and Enter and paste all the coordinate here so you can see with the help of this command how easily all the coordinate points are joints together by this 3D PolyLine and you can Check here , you have to press CTRL+1 , you can check the vertices of the respective RLs for the respective coordinates in this way you can easily draw the 3D PolyLine and Import the X, Y, Z Coordinates from the Excel Sheet to AutoCAD interface, hope you are understand and please Comment how the video is and please LIKE and Subscribe our Channel. Thanks for watching. [MUSIC] Watch our other free tutorials

Channel: Learn & Explore

Views: 104,518

Keywords: import, xyz, x y z, coordinates, points, easting, northing, rl, excel to autocad, direct, batch, excel, autocad, 3D Polyline, CONCATENATE formula in excel, Multiple points draw in autocad

Id: qXKpHZG9aug

Length: 4min 38sec (278 seconds)

Published: Fri Jul 06 2018