How to import X Y coordinates from Excel to AutoCAD direct! (English)

For your practice DOWNLOAD this EXCEL file
Download Link: goo.gl/kwUhmZ
SUBSCRIBE us if it helps you
In this tutorial you will learn how to import points (x,y) or Easting, Northing data from an excel data sheet to AutoCAD.
I have shown two methods to import points in autocad from an excel file.
Watch Part II : • How to Import Texts fr...
(How to import texts easily from excel to AutoCAD.)
Watch the Part-III : • How to Create a Topo M...
(How to import Lines from excel to AutoCAD)
You might know that excel is a very important tool for the engineers to make any drawing fast and
easy in AutoCAD.
I will apply the same here. I will use some easy commands and formulas that will make you
understand and you will be able to import points with just a single click !
SUBSCRIBE us (its free)
/ learnexplore
check our other tutorials below
How to import X Y Z Coordinates from Excel to AutoCAD
Import XY Coordinate From Excel Into AutoCAD
Import Excel points to AutoCAD
How to import X,Y Coordinates from Excel to AutoCAD
How to Import Texts from Excel to AutoCAD! (English)
• How to Import Texts fr...
How to Create a Topo Map by using Excel and AutoCAD (English)
• How to Create a Topo M...
Export X,Y,Z co-ordinates from AutoCAD to Excel [English]
• Export X Y Z coordinat...
Bearing and Distance Calculation from Easting, Northing | Excel
• Bearing Calculation fr...
[Surveying] Bearing Calculation in excel
• Convert Degree Minute ...
How to convert Lat, Long to UTM (Easting,Northing) | by QGIS Software (English)
• How to convert Lat Lon...
What's the difference between accuracy and precision?
• What's the difference ...
Land Survey data collection by Mobile Topographer Application (Mobile GIS)
• Land Survey data colle...
Coordinate System in Surveying (Calculation of Easting and Northing)
• Coordinate System in S...
If it relates to you please Like & Share this video and Subscribe our channel to get free updates
With best wishes
L&E Team!
Follow us on Blog: bit.ly/2w7cfze

[@LearnExplore]

[Download Link Inside] 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: rzp.io/l/payLE excel formula file download Link bellow: goo.gl/kwUhmZ Don't forget to SUBSCRIBE us! kzbin.info Learn & Keep exploring!

[@user-nd3vt8cf8n]

Very nice & useful sir Tnk u

[@pavancivil6757]

Very good information. please tell how to calculate area from excel sheet(using formula) in auto cad drawing...

[@dulaldas7308]

。。。。

[@teodolfojuanezajr.446]

As beginner I will apply what I had learned from you. God bless Boss

[@teodolfojuanezajr.446]

I hope you have the tutorial also for plotting both vertical and horizontal alignment showing element of curve. Example in vertical alignment shows pvi, pt, PC, K, etc. for simple road design using auto CAD Civil 3d

[@shakernsour6889]

Thank You So Much, you saved a lot of time for me!!

[@YashSingh-so7iq]

Dhanyawad (thanku very much)....

[@fredrickmae6680]

Amazing, thank you very much.

[@dariush-2024]

thank you for your useful and handy instructions on autocad ,

[@gearaff]

Thanks a lot. You save my time!

[@engr_qt7093]

Thank you my dear friend. You save me a lot of time because I was planning to put every point by "command circle = bearings of Eastings, Northings" 1 by 1 HAHAHAHA

[@charlessutherland5572]

Yeah, don't do that, technology is our friend lol Seriously though, I am a rookie on AutoCAD but coming from the Excel world and the sheer amount of tasks that can be automated by using scripts is staggering.

[@mdalislam3174]

It is very very very veryyyyyyyyyyyyyyyyyyyy helpful, grateful to you, sir...

[@user-eh7gh6ev5e]

СПАСИБО!!!Очень полезная информация.

[@LearnExplore]

пожалуйста.

[@kolaalade2200]

You are a life saver. Thank you!

[@LearnExplore]

Happy to help!

[@kceewong]

Thank you, easy understanding, very useful for a surveyor or draftsman.

[@LearnExplore]

You are welcome. Thanks for the feedback

[@sampathreddy6159]

ThanQ for the Video 👍🙏

[@SirsenduRoy]

thank you sir, this will help me in doing survey.

[@sajjadofficial3893]

THANK YOU BROTHER

[@mrsunknown875]

bro u the great u solve my biggest problem and that's why i subscribed your Chanel

[@habibghazi9974]

Thank you very much

[@murugalingammanoharaj5240]

thanks a lot sir, really helpful

[@sakthiaiyathurai9831]

Oooo wonderful bro, thank you verymuch. Recently I done 900 points plotting by entering each points. Now I got it. Thanks again.

[@CharnwootK]

It's helpful. Thank you Sir.😀😀😀

[@Mostafa20268]

Thank you man !

[@ershishaklivingstone7342]

Thanks Mate

[@servenmasankay9129]

Thank you sir,,

[@mahbubkhan8891]

Thank you sir

[@theodoretshiswakatshibangu6431]

Very helpful.

[@mimpianakadam]

thanks from indonesia .. very helpfull :)

[@LearnExplore]

Thanks for your valuable feedback 😊

[@brianzimbiru7095]

Thank you genius. I've learnt a lot

[@LearnExplore]

You are welcome

[@ashokkumaryadav7586]

Thank You Sir

[@priyakrishnaswamy1428]

Very useful video. You made many people life easy :) Guys dont forget to download his excel sheet..

[@LearnExplore]

Thank you 😊

[@kanthonkampanatsenakul6477]

thank you very much

[@mahbubkhan8891]

Thank you dir

[@umerdraz4452]

great job sir, carry on.

[@subashgovin6114]

valueable vedio bro ,so much thanks you bro.....

[@AamirKhan-tb2sn]

thanks alot sir for helping

[@sajjadofficial3893]

Recently I done 425 points plotting by entering each points. Now I got it. Thanks again.

[@harisali4003]

Thank you Sir. Allah Bless you

[@biniamkibru5292]

THANK YOU !!

[@LearnExplore]

Thank You for your valuable feedback 😊

[@georgealhassan536]

thanks very much

[@pradipsantra2304]

Excellent sir

[@GIFT19JOY23]

Very useful

[@gangadharababung982]

Thank you

[@senaysew8231]

INTERESTING

[@namgyeldorji]

thank you

[@milfardonutaarsada7083]

THANKS..

[@martin-xq7te]

Very useful. Thankyou

[@LearnExplore]

Glad it was helpful!

[@tanyaradzwajimu5426]

Wooow thank you so much, Really helped a lot. Be blessed.

[@LearnExplore]

Most welcome

[@baskarpriya9667]

THANKS

[@ayyanarm9178]

thanks bri

[@engabdiwaliahmed7717]

thank you very much indeed this video helped me

[@LearnExplore]

You are most welcome

[@roddaraghu5499]

Thank sir

[@teodolfojuanezajr.446]

Ty

[@babusonachaudhuri]

sir, please give more video with different examples for the learners

[@rizamaun3466]

TNX Bhai!

[@tpardesi7775]

Good video

[@autocadplantcivilmech2705]

Nice good job

[@lokmanhossainshohag4196]

Tnx sir....this is so good and easy...

[@LearnExplore]

Thank you for your valuable feedback

[@zainihasan5072]

thanks

[@LearnExplore]

U r welcome ☺️

[@mothernature1992]

Thank you very much .

[@babumaitra1713]

nice video.

[@LearnExplore]

Its Great to hear that

[@engineeringtechnologist2299]

This is a great tutorial! Would you do a tutorial how to insert dynamic blocks with visibility states into a specific coordinates? What I'm trying to accomplish is to export my dynamic block coordinates, (with different visibility states) to an excel file and then use excel to change the coordinates so that I can import it back into a new drawing file with the location of the blocks in different coordinates.

[@LearnExplore]

Yes it is possible. Can you give me the data to make this tutorial? Please send us the dwg and excel data to [e-mail]

[@AbdulWahab-kg3gm]

Surveyor report ka tarika ENZ BATAO BAHI

[@nasirmehmood5908]

nice

[@khaleelrahman9586]

THATS GREAT..MAM..BUT HOT TO SHOW THE LEVELS, COORDINATES AND THE POINT ON THE AUTOCAD FILE

[@khalidaliabdalla]

Fantastic, a quick question though, how do I plot gps coordinate point on autocad?

[@user-nq3tw9dp7m]

Hello, I’m currently working on a project where I need to import coordinates of power distribution network poles into AutoCAD from a CSV file. These poles vary in type (e.g., concrete, wooden, chestnut, etc.) and are defined by attributes in the CSV file. Is there a way to automatically assign different blocks or symbols to these points based on their attributes during the import process? Ideally, I’m looking for a solution that allows for the visualization of these different pole types directly in AutoCAD without manually changing the symbols for each coordinate. Any guidance or references to scripts and tools that could facilitate this would be greatly appreciated. Thank you!

[@shermuhammad1672]

sir any vidu about area divission in equl parts in auto cad please will make

[@LearnExplore]

+Sher Muhammad I understood your question But this not possible in AutoCAD with a command or any automatic method. If the shape in regular shape then it's somehow possible otherwise you have to divide any irregular shape manually in AutoCAD. Hope you understand.

[@radhars4333]

Please upload a tutorial in autocad about latitude and longitudinal and easting and northing wgs84

[@LearnExplore]

+radha rs I'm not clear with your queries. Pls tell in details

[@arifpashaMmk]

This video is very helpful full thanks a lot, Brother can you please show me how I can prepare an excel file based on the AutoCAD file in advance thanks.

[@LearnExplore]

Yes you can do that too. Use LIST command and export line vertex to Excel. We have a video on our channel. Please watch that too

[@sacprasanna]

Use Civil 3D to import points . It is very easy

[@LearnExplore]

+Chamara Prasanna Thats right sir But when you don't have civil 3D then it will help you to work with.

[@sandipdarji3552]

how to do import point to volume finder in autocad

[@amadusarjohbah1440]

very good tutorial, it really educative. please can you help me with your data(Coordinates so that i can use it to practice what i have learned from you. thanks

[@LearnExplore]

Happy to hear from u..and Give ur mail id i will send the file

[@amadusarjohbah1440]

[e-mail]

[@amadusarjohbah1440]

[e-mail]

[@LearnExplore]

I have sent you ..check your mail box

[@amadusarjohbah1440]

i have checked my inbox and i have not seen any message from you. Kind Regards

[@asbewalmaw4261]

How can I get the supportive videos' to import lines from excel data sheet part 3

[@LearnExplore]

Please search for "how to draw topo map"

[@suguruvimalteja]

How could u get specifically these points while google earth gives lot many coordinates.Would u tell me how did u do that?

[@LearnExplore]

By DGPS Surveying

[@carlodigma5128]

Hi, how to put text coordinate short cut because every point in need to type one by one the coordinate. Thanks and God bless.

[@LearnExplore]

Use PDSIZE command in AutoCAD and reduce point size as per your convenient.

[@tapanchattopadhyay1415]

HI, I HAVE A AUTOCAD 2014 INSTALLED. WHEN I AM TRYING TO COPY AND PASTE THE CSV FILE IN AUTOCAD IT IS NOT PASTING.TRIED ZOM AND EXTEND ALSO AFTER PASTE COMMAND. CAN YOU PLESE TELL ME WHAT IS THE PROBLEM? ASLO THE OTHER FORMULA YOU SHOWN TO MAKE CSV FILE ( OTHER THAN CONCATENATE) IS NOT ACCEPTING IN MY EXCELL FILE

[@LearnExplore]

Don't create csv file. Instead of that just copy the generated x,y format directly from excel and use right click on commnd bar in autocad and paste it. Don't use Ctrl+V for paste. Always use Right click and paste

[@markdanielmonton4373]

Hi good day! I just follow your instruction but after that the 5 coordinates just position in one location

[@LearnExplore]

Please retry. Method is same

[@suguruvimalteja]

Is it from google earth u took coordinates?

[@SunMusic844]

Very nice appreciable 👏👏 Can u please tell how to find RL

[@LearnExplore]

Thank you. You mean how to import RL?

[@SunMusic844]

No how to find RL in excel (formula)

[@LearnExplore]

You can get RL from field or from Google Earth. Actually I couldn't understand your question.

[@SunMusic844]

Ohk thank u that means X Y and RL are already given

[@LearnExplore]

Yes

[@bubaibhuinya1782]

How to Convert Higher version autocad file to Lower version more then 2 one time?

[@hamidullahnoori7032]

sir if we have a theodolite data that be in degree minute and second can we import it from excel to auto cad

[@LearnExplore]

Yes...u can

[@subhashpatil8630]

Yes. First convert it in UTM and go for this procedure

[@gearaff]

Do You know how to do the same with pline from coordinates?

[@LearnExplore]

Yes Just copy the X,Y,Z Column from excel and in autocad Type PL and simply right click on the command bar and paste For 3d Pline type 3P and simple paste. You will get the polyline. Watch Part 3 of this video.

[@prasadambujalapu4584]

How to set point id

[@khalandarshaik5010]

Can we import two set of coordinates in one file

[@LearnExplore]

Sure u can

[@manojsable8482]

hi,pls muze village map ka data auto level bearing se exel sheet to cad me kaise convert karte hai guide kare pls

[@LearnExplore]

For this I will suggest a video to u...watch in detail kzbin.info/www/bejne/m2LCmIWXjpKrfNU

[@asharjaulani8361]

Have tried coping the points from excel to autocad the points are not coming, but if l copy 10 points from a diffirent excel file the points are coming

[@LearnExplore]

Use Z enter E enter or change point style

[@drvlive2023]

Can I move the axis to a point that would not change the value of the coordinates?

[@LearnExplore]

No

[@drvlive2023]

@@LearnExplore So that's what would really happen then (I asked because I tried it earlier). Any tips on improving it? I've set the limits to 500000s and 2000000s, because it's that far

[@Ghost-xn6kk]

Your videos are helpful but please do some work on video quality and voice quality. Do not delete these videos but remake them in good quality

[@LearnExplore]

Thanks for the suggestions

[@rajata2819]

How to import RL of that point

[@LearnExplore]

Another video uploaded for this

[@jonhy720]

it keeps on asking to specify a point, what to do?

[@LearnExplore]

+jonhy720 Copy the PO and (E,N) column and paste that in the white command bar

[@mikkellhope146]

Hi. I'm a Civil engineering student and I just wanna ask in exporting the points to autoCAD. The result is different from urs.

[@LearnExplore]

Pl Follow the steps thoroughly

[@tarmiziridwan7264]

Can't paste the file. Still ask specify a point. Help me please

[@fernandostephen2449]

Someone pls explain

[@ramlakhanyadav2215]

Ram Lakhan Yadav

[@yvng.ary25]

send you the link of it

[@LearnExplore]

See description

[@gersonryansumampong3125]

What does RL and S.L. in the file means? Please help

[@LearnExplore]

Reduced level

[@yadavmt-1586]

Please send me the topo surveying points. I will try my auto cad.

[@LearnExplore]

Link already given

[@manthansharma6041]

Sir can you send the link of final drawing of these coordinates.

[@LearnExplore]

Link already given...pls check in the comment section

[@LearnExplore]

Do U need autocad drawing?

[@manthansharma6041]

yes sir the final drawing of these coordinates so that I can practice check my drawing.

[@LearnExplore]

Share ur email id

[@manthansharma6041]

[e-mail]

[@dennisriziki7836]

VERY HELPFUL BUT THE PROBLEM WHEN I COPY AND PASTE TO AUTOCAD ONLY ONE POINT IS SEEN. PLEASE HELP

[@LearnExplore]

Try again. Or try this method Copy the column of x,y in excel In AutoCAD use Multipoint command and then paste in command bar. Let me know if your problem solved.

[@DanieL_35]

Noice

[@wonderlandsurvey]

Excel sheet is not opening plz help me to open/download

[@LearnExplore]

Download it and open. and click enable

[@FORDANDNINA]

I can't snap the centerline is there a way to snap it?😭

[@LearnExplore]

Use SE command and on object snap mode

[@user-zm1eb4zu3j]

You Can see on the following video about coordinates using lisp kzbin.info/www/bejne/gGKqfGiqft-Fbdk

[@kannanp3933]

Bro fist point only inside the put autocad another point can't past bro

[@LearnExplore]

Watch the video carefully