Importing X, Y, Z Coordinates to AutoCAD from Microsoft Excel

In this video, you will learn how to import X, Y and Z coordinates to AutoCAD as points from Microsoft Excel.
For this tutorial, we are using an example dataset which consists of more than 100,00 rows of data. Each row consists of longitude, latitude and elevation information. Prior to importing the dataset to AutoCAD, it is required to save the dataset as a CSV (comma separated value) file using Microsoft Excel, which can then be opened using a text editor like Notepad.
We are using MULTIPLE and POINT commands of AutoCAD to prepare the AutoCAD Script (.SCR) file.
Once the script file is created, you will be able to use the SCR command in AutoCAD to run the aforementioned script file, and in no time, you would be able to import the data into AutoCAD as a point dataset.
You can double click your scroll wheel to swiftly zoom into the extents of the point objects, and if you would like to inspect the points individually, you can right click on any point, go to properties, and you would be able to access the corresponding X, Y and Z values.
#autocad #xyzcoordinates #geodeltalabs

[@donnabethune2454]

Love your tutorials! Always learning something new. Thank you so much!!!

[@daisyflemington9371]

Thank you for your clear tutorials. I appreciate the step by step explaining even minor details that seem obvious but not to a newbie. Whilst attempting this on my own project I had a problem importing the script, i types 'SCR', selected the file and it didn't automatically upload the points it told me 'invalid point. Specify new point'. i tried just pressing enter or putting 0,0 in the coordinates boxes attached to my cursor , I also rewatched your video and made changes to my excel but no luck. Would be very greatful for advice from anyone on this platform and keep up the good work xx

[@ganessh8160]

same issue

[@caetanocostadossantos6867]

Thank you. I'm from Brazil. You save my day

[@geodeltalabs]

You are welcome

[@diogenesferreira2841]

Hey mate, thank you very much! You saved me tons of time haha! Greetings from Brazil.

[@geodeltalabs]

Glad to hear that!

[@jasonolobo3395]

Thank you very much.

[@franziskasommer6058]

great work man

[@LadyAmethyst100]

I recently discovered your channel and have been binge watching your videos. Your content is so informative and well presented ❤️……btw you sound alot like one of my fave KZbinrs J.M lol will just use the initials😅…..but J.M is that u 😂

[@CajunYankee88]

I need to be able to create a 3D model out of this though. My life would be heavenly right now if I was able to do so!

[@geodeltalabs]

Hi, i have a couple of videos that might be helpful for this, however using the free and open source QGIS software. Check out the following videos; 1. Creating a continuous raster using a point dataset using interpolation methods (kzbin.info/www/bejne/f4OwpqOfoM-LpMk) 2. Creating a 3D model using QGIS (kzbin.info/www/bejne/jZ7Sk4F4o7NkosU) Another similar tutorial that might be helpful: kzbin.info/www/bejne/qJipemiNnr2Copo I am also planning to publish a similar tutorial in a couple of days time, which might be useful for you. So you can keep an eye out for that as well. Hope this helps.

[@Fshah1]

Very useful and informative video. I have save the all co-ordinate as explained by you. But it is saying a specifty the point instead of importing whole SCR file. Please advise.

[@ererenererime5104]

The tutorial was helpful thanks. how to make the z values to be seen on the autocad page

[@rajabwawa7802]

Thanks for tutorial I would like to know how to connect points and produce contour map ...

[@muhammadsudarman8940]

How to display value Z as label text ?

[@qwesyowusu-ansah5419]

Thanks. Is it possible to add labels and attributes to the points?

[@ryouichibukayo6843]

Hey Geo, just asking how can i draw the conture lines from this, the 3d map?

[@AdamQ-qn4yv]

hi, thanks for the video. why when I repeat all the process u showed in my case it enters multiple and point commands but doesn't import point? It just enters these multiple and point commands and allows me to create points but doesn't import my points from scr file

[@ganessh8160]

same problem

[@rajendra.n596]

wonderful

[@charliechaplin9942]

Thanks

[@orinamicedric5733]

Thanks for the intention to teach but it isn't working. I tried it on 2017, 2021. It just returns the multiple point command and It's waiting for me to enter the points or possibly click on the screen. You could verify. Thank you

[@zedsump]

it asks for SPECIFY POINT after running .SCR file....... I'm at Slitting Wrists stage now....!!...Autocad is such an UN-USER-FRIENDLY software. Needs some AI integrated within.

[@user-bd7mv4bb5p]

Cool

[@britzeynatzey9319]

Why when am tryna open the scr file it says invalid points?

[@rajendra.n596]

AFTER COMPLETION OF PROCESS, WHEN I LOAD SCR FILE, ITS ASKING SPECIRY A POINT. EVERY POINT ITS ASKING, PLEASE GET ME THE SOLUTION

[@aldobruno712]

what is the purpose of this? pasting so many points? I'm a beginner

[@christianasonye1942]

To create a map

[@gnrslash1987]

DOES NOT WORK, INVALID POINT.

[@bwowekeith4472]

It worked for me