Тёмный

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

Learn & Explore
Подписаться 59 тыс.
Просмотров 661 тыс.
50% 1

Опубликовано:

 

20 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 235   
@LearnExplore
@LearnExplore 7 лет назад
[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! ru-vid.com Learn & Keep exploring!
@ஜேசுஇன்னாசிபிரபு
Very nice & useful sir Tnk u
@pavancivil6757
@pavancivil6757 3 года назад
Very good information. please tell how to calculate area from excel sheet(using formula) in auto cad drawing...
@dulaldas7308
@dulaldas7308 2 года назад
。。。。
@teodolfojuanezajr.446
@teodolfojuanezajr.446 10 месяцев назад
As beginner I will apply what I had learned from you. God bless Boss
@teodolfojuanezajr.446
@teodolfojuanezajr.446 10 месяцев назад
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
@kceewong
@kceewong 2 года назад
Thank you, easy understanding, very useful for a surveyor or draftsman.
@LearnExplore
@LearnExplore 2 года назад
You are welcome. Thanks for the feedback
@engr_qt7093
@engr_qt7093 4 года назад
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
@charlessutherland5572 4 года назад
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.
@kolaalade2200
@kolaalade2200 3 года назад
You are a life saver. Thank you!
@LearnExplore
@LearnExplore 3 года назад
Happy to help!
@harisali4003
@harisali4003 2 года назад
Thank you Sir. Allah Bless you
@borabean8271
@borabean8271 Год назад
Thank you very much
@CharnwootK
@CharnwootK Год назад
It's helpful. Thank you Sir.😀😀😀
@priyakrishnaswamy1428
@priyakrishnaswamy1428 4 года назад
Very useful video. You made many people life easy :) Guys dont forget to download his excel sheet..
@LearnExplore
@LearnExplore 4 года назад
Thank you 😊
@tanyaradzwajimu5426
@tanyaradzwajimu5426 7 месяцев назад
Wooow thank you so much, Really helped a lot. Be blessed.
@LearnExplore
@LearnExplore 7 месяцев назад
Most welcome
@engabdiwaliahmed7717
@engabdiwaliahmed7717 2 года назад
thank you very much indeed this video helped me
@LearnExplore
@LearnExplore 2 года назад
You are most welcome
@aleksandarxbundalo
@aleksandarxbundalo 8 месяцев назад
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!
@shakernsour6889
@shakernsour6889 4 года назад
Thank You So Much, you saved a lot of time for me!!
@theodoretshiswakatshibangu6431
Very helpful.
@Mostafa20268
@Mostafa20268 3 года назад
Thank you man !
@biniamkibru5292
@biniamkibru5292 2 года назад
THANK YOU !!
@LearnExplore
@LearnExplore 2 года назад
Thank You for your valuable feedback 😊
@brianzimbiru7095
@brianzimbiru7095 3 года назад
Thank you genius. I've learnt a lot
@LearnExplore
@LearnExplore 3 года назад
You are welcome
@georgealhassan536
@georgealhassan536 4 года назад
thanks very much
@mimpianakadam
@mimpianakadam 4 года назад
thanks from indonesia .. very helpfull :)
@LearnExplore
@LearnExplore 4 года назад
Thanks for your valuable feedback 😊
@khaleelrahman9586
@khaleelrahman9586 6 месяцев назад
THATS GREAT..MAM..BUT HOT TO SHOW THE LEVELS, COORDINATES AND THE POINT ON THE AUTOCAD FILE
@gearaff
@gearaff 4 года назад
Thanks a lot. You save my time!
@engineeringtechnologist2299
@engineeringtechnologist2299 3 года назад
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
@LearnExplore 3 года назад
Yes it is possible. Can you give me the data to make this tutorial? Please send us the dwg and excel data to contact@learnnexplore.com
@AbdulWahab-kg3gm
@AbdulWahab-kg3gm Год назад
Surveyor report ka tarika ENZ BATAO BAHI
@GIFT19JOY23
@GIFT19JOY23 3 года назад
Very useful
@mrsunknown875
@mrsunknown875 4 года назад
bro u the great u solve my biggest problem and that's why i subscribed your Chanel
@pradipsantra2304
@pradipsantra2304 4 года назад
Excellent sir
@subashgovin6114
@subashgovin6114 4 года назад
valueable vedio bro ,so much thanks you bro.....
@khalidaliabdalla
@khalidaliabdalla Год назад
Fantastic, a quick question though, how do I plot gps coordinate point on autocad?
@lokmanhossainshohag4196
@lokmanhossainshohag4196 3 года назад
Tnx sir....this is so good and easy...
@LearnExplore
@LearnExplore 3 года назад
Thank you for your valuable feedback
@baskarpriya9667
@baskarpriya9667 Год назад
THANKS
@asbewalmaw4261
@asbewalmaw4261 2 года назад
How can I get the supportive videos' to import lines from excel data sheet part 3
@LearnExplore
@LearnExplore 2 года назад
Please search for "how to draw topo map"
@ayyanarm9178
@ayyanarm9178 3 года назад
thanks bri
@dariush-2024
@dariush-2024 6 лет назад
thank you for your useful and handy instructions on autocad ,
@gangadharababung982
@gangadharababung982 4 года назад
Thank you
@YashSingh-so7iq
@YashSingh-so7iq 6 лет назад
Dhanyawad (thanku very much)....
@КонстантинПеров-х4у
СПАСИБО!!!Очень полезная информация.
@LearnExplore
@LearnExplore 4 года назад
пожалуйста.
@arifpashaMmk
@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
@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
@autocadplantcivilmech2705
@autocadplantcivilmech2705 3 года назад
Nice good job
@teodolfojuanezajr.446
@teodolfojuanezajr.446 10 месяцев назад
Ty
@AamirKhan-tb2sn
@AamirKhan-tb2sn 4 года назад
thanks alot sir for helping
@fredrickmae6680
@fredrickmae6680 5 лет назад
Amazing, thank you very much.
@markdanielmonton4373
@markdanielmonton4373 2 года назад
Hi good day! I just follow your instruction but after that the 5 coordinates just position in one location
@LearnExplore
@LearnExplore 2 года назад
Please retry. Method is same
@sakthiaiyathurai9831
@sakthiaiyathurai9831 5 лет назад
Oooo wonderful bro, thank you verymuch. Recently I done 900 points plotting by entering each points. Now I got it. Thanks again.
@mdalislam3174
@mdalislam3174 6 лет назад
It is very very very veryyyyyyyyyyyyyyyyyyyy helpful, grateful to you, sir...
@sajjadofficial3893
@sajjadofficial3893 5 лет назад
Recently I done 425 points plotting by entering each points. Now I got it. Thanks again.
@khalandarshaik5010
@khalandarshaik5010 3 года назад
Can we import two set of coordinates in one file
@LearnExplore
@LearnExplore 3 года назад
Sure u can
@drvlive2023
@drvlive2023 3 года назад
Can I move the axis to a point that would not change the value of the coordinates?
@LearnExplore
@LearnExplore 3 года назад
No
@drvlive2023
@drvlive2023 3 года назад
@@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
@SirsenduRoy
@SirsenduRoy 6 лет назад
thank you sir, this will help me in doing survey.
@mikkellhope146
@mikkellhope146 2 года назад
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
@LearnExplore 2 года назад
Pl Follow the steps thoroughly
@babusonachaudhuri
@babusonachaudhuri 5 лет назад
sir, please give more video with different examples for the learners
@wonderlandsurvey
@wonderlandsurvey 4 года назад
Thanks sir
@sampathreddy6159
@sampathreddy6159 5 лет назад
ThanQ for the Video 👍🙏
@umerdraz4452
@umerdraz4452 4 года назад
great job sir, carry on.
@asharjaulani8361
@asharjaulani8361 3 года назад
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
@LearnExplore 3 года назад
Use Z enter E enter or change point style
@murugalingammanoharaj5240
@murugalingammanoharaj5240 5 лет назад
thanks a lot sir, really helpful
@ashokkumaryadav7586
@ashokkumaryadav7586 5 лет назад
Thank You Sir
@SunMusic844
@SunMusic844 2 года назад
Very nice appreciable 👏👏 Can u please tell how to find RL
@LearnExplore
@LearnExplore 2 года назад
Thank you. You mean how to import RL?
@SunMusic844
@SunMusic844 2 года назад
No how to find RL in excel (formula)
@LearnExplore
@LearnExplore 2 года назад
You can get RL from field or from Google Earth. Actually I couldn't understand your question.
@SunMusic844
@SunMusic844 2 года назад
Ohk thank u that means X Y and RL are already given
@LearnExplore
@LearnExplore 2 года назад
Yes
@sajjadofficial3893
@sajjadofficial3893 5 лет назад
THANK YOU BROTHER
@carlodigma5128
@carlodigma5128 4 года назад
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
@LearnExplore 4 года назад
Use PDSIZE command in AutoCAD and reduce point size as per your convenient.
@bubaibhuinya1782
@bubaibhuinya1782 3 года назад
How to Convert Higher version autocad file to Lower version more then 2 one time?
@gearaff
@gearaff 4 года назад
Do You know how to do the same with pline from coordinates?
@LearnExplore
@LearnExplore 4 года назад
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.
@rizamaun3466
@rizamaun3466 4 года назад
TNX Bhai!
@tpardesi7775
@tpardesi7775 5 лет назад
Good video
@shamseerm404
@shamseerm404 5 лет назад
thank you sir
@tapanchattopadhyay1415
@tapanchattopadhyay1415 5 лет назад
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
@LearnExplore 5 лет назад
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
@nasarulkhan6678
@nasarulkhan6678 4 года назад
Sir normal excel se hoga... Na alagse export to excel bolke kuch excel hay plzzz help me sir... Plz
@LearnExplore
@LearnExplore 4 года назад
Normal excel se hi hoga
@nasarulkhan6678
@nasarulkhan6678 4 года назад
Thnx sir..... I'm done sir
@hamidullahnoori7032
@hamidullahnoori7032 5 лет назад
sir if we have a theodolite data that be in degree minute and second can we import it from excel to auto cad
@LearnExplore
@LearnExplore 5 лет назад
Yes...u can
@subhashpatil8630
@subhashpatil8630 5 лет назад
Yes. First convert it in UTM and go for this procedure
@gersonryansumampong3125
@gersonryansumampong3125 3 года назад
What does RL and S.L. in the file means? Please help
@LearnExplore
@LearnExplore 3 года назад
Reduced level
@suguruvimalteja
@suguruvimalteja 6 лет назад
How could u get specifically these points while google earth gives lot many coordinates.Would u tell me how did u do that?
@LearnExplore
@LearnExplore 6 лет назад
By DGPS Surveying
@dennisriziki7836
@dennisriziki7836 2 года назад
VERY HELPFUL BUT THE PROBLEM WHEN I COPY AND PASTE TO AUTOCAD ONLY ONE POINT IS SEEN. PLEASE HELP
@LearnExplore
@LearnExplore 2 года назад
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.
@shermuhammad1672
@shermuhammad1672 6 лет назад
sir any vidu about area divission in equl parts in auto cad please will make
@LearnExplore
@LearnExplore 6 лет назад
+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.
@Ghost-xn6kk
@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
@LearnExplore Год назад
Thanks for the suggestions
@senaysew8231
@senaysew8231 6 лет назад
INTERESTING
@yadavmt-1586
@yadavmt-1586 2 года назад
Please send me the topo surveying points. I will try my auto cad.
@LearnExplore
@LearnExplore 2 года назад
Link already given
@roddaraghu5499
@roddaraghu5499 5 лет назад
Thank sir
@prasadambujalapu4584
@prasadambujalapu4584 3 года назад
How to set point id
@radhars4333
@radhars4333 6 лет назад
Please upload a tutorial in autocad about latitude and longitudinal and easting and northing wgs84
@LearnExplore
@LearnExplore 6 лет назад
+radha rs I'm not clear with your queries. Pls tell in details
@FORDANDNINA
@FORDANDNINA 2 года назад
I can't snap the centerline is there a way to snap it?😭
@LearnExplore
@LearnExplore 2 года назад
Use SE command and on object snap mode
@babumaitra1713
@babumaitra1713 7 лет назад
nice video.
@LearnExplore
@LearnExplore 7 лет назад
Its Great to hear that
@engr.hishamkhan9267
@engr.hishamkhan9267 2 года назад
how to enter XY and Z also in CAd?>???????????? Pls Help
@LearnExplore
@LearnExplore 2 года назад
Make format of x,y,z in excel and follow same step as shown. In case of polyline using x,y,z Use 3P command instead of PL
@engr.hishamkhan9267
@engr.hishamkhan9267 2 года назад
Pls I need your help....can I get your number???
@engr.hishamkhan9267
@engr.hishamkhan9267 2 года назад
Pls help me brother....
@mothernature1992
@mothernature1992 5 лет назад
Thank you very much .
@wonderlandsurvey
@wonderlandsurvey 4 года назад
Excel sheet is not opening plz help me to open/download
@LearnExplore
@LearnExplore 4 года назад
Download it and open. and click enable
@kannanp3933
@kannanp3933 3 года назад
Bro fist point only inside the put autocad another point can't past bro
@LearnExplore
@LearnExplore 3 года назад
Watch the video carefully
@yvng.ary25
@yvng.ary25 2 года назад
send you the link of it
@LearnExplore
@LearnExplore 2 года назад
See description
@manthansharma6041
@manthansharma6041 5 лет назад
Sir can you send the link of final drawing of these coordinates.
@LearnExplore
@LearnExplore 5 лет назад
Link already given...pls check in the comment section
@LearnExplore
@LearnExplore 5 лет назад
Do U need autocad drawing?
@manthansharma6041
@manthansharma6041 5 лет назад
yes sir the final drawing of these coordinates so that I can practice check my drawing.
@LearnExplore
@LearnExplore 5 лет назад
Share ur email id
@manthansharma6041
@manthansharma6041 5 лет назад
manthansharma144@gmail.com
@zainihasan5072
@zainihasan5072 7 лет назад
thanks
@LearnExplore
@LearnExplore 7 лет назад
U r welcome ☺️
@amadusarjohbah1440
@amadusarjohbah1440 7 лет назад
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
@LearnExplore 7 лет назад
Happy to hear from u..and Give ur mail id i will send the file
@amadusarjohbah1440
@amadusarjohbah1440 7 лет назад
amadusarjohbah@gmail.com
@amadusarjohbah1440
@amadusarjohbah1440 7 лет назад
amadusarjohbah@gmail.com
@LearnExplore
@LearnExplore 7 лет назад
I have sent you ..check your mail box
@amadusarjohbah1440
@amadusarjohbah1440 7 лет назад
i have checked my inbox and i have not seen any message from you. Kind Regards
@tarmiziridwan7264
@tarmiziridwan7264 5 лет назад
Can't paste the file. Still ask specify a point. Help me please
@fernandostephen2449
@fernandostephen2449 4 года назад
Someone pls explain
@sandipdarji3552
@sandipdarji3552 5 лет назад
how to do import point to volume finder in autocad
@nasirmehmood5908
@nasirmehmood5908 5 лет назад
nice
@imtiazahmed1013
@imtiazahmed1013 7 лет назад
sir apki attach file se ma jab point ki copy kerta hun tu mukamal copy nahy hoti while apkay 143 points hn aur meray pass 94 points aatay hn please describe thanks
@LearnExplore
@LearnExplore 7 лет назад
Download the file. Otherwise send your mail id I will send you the original file Apna mail id vejo
@LearnExplore
@LearnExplore 7 лет назад
+imtiaz ahmed App ka question me samjha nahi..pls decribe in detail
@Humanityforworld
@Humanityforworld 6 лет назад
Sir plzz send me my mail I'd Khanmahbub655@gmail.com
@LearnExplore
@LearnExplore 6 лет назад
Check the file I have sent in your email
@Humanityforworld
@Humanityforworld 6 лет назад
Learn & Explore thank you sir
@suguruvimalteja
@suguruvimalteja 6 лет назад
Is it from google earth u took coordinates?
@manojsable8482
@manojsable8482 6 лет назад
hi,pls muze village map ka data auto level bearing se exel sheet to cad me kaise convert karte hai guide kare pls
@LearnExplore
@LearnExplore 6 лет назад
For this I will suggest a video to u...watch in detail ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-e1_gRaY-xFs.html
@jonhy720
@jonhy720 6 лет назад
it keeps on asking to specify a point, what to do?
@LearnExplore
@LearnExplore 6 лет назад
+jonhy720 Copy the PO and (E,N) column and paste that in the white command bar
@rajata2819
@rajata2819 5 лет назад
How to import RL of that point
@LearnExplore
@LearnExplore 5 лет назад
Another video uploaded for this
@sacprasanna
@sacprasanna 7 лет назад
Use Civil 3D to import points . It is very easy
@LearnExplore
@LearnExplore 7 лет назад
+Chamara Prasanna Thats right sir But when you don't have civil 3D then it will help you to work with.
@HamzaKhan-rc5gt
@HamzaKhan-rc5gt 3 года назад
How to import data Excel form AutoCAD with description
@LearnExplore
@LearnExplore 3 года назад
Please See our videos in 'Excel & AutoCAD' playlist
@subhadipmondal2198
@subhadipmondal2198 2 года назад
sir ami jokhn paste korchi tokhon kintu amar hocche na
@subhadipmondal2198
@subhadipmondal2198 2 года назад
ki problem aktu bolben
@LearnExplore
@LearnExplore 2 года назад
Command bar e left click then right click kore paste korte hbe. File ta download kore nau. Pinned comment e link deoa ache
@subhadipmondal2198
@subhadipmondal2198 2 года назад
@@LearnExplore ok sir
@f4gaming62
@f4gaming62 5 лет назад
bhai mere pass na autocad me copy hi nhi hore baqi ka pura hora process hora
@LearnExplore
@LearnExplore 5 лет назад
Don't use Ctr+C to copy. Just right click and select copy.
@shanu9245
@shanu9245 3 года назад
Coordinate unit should be meter
@LearnExplore
@LearnExplore 3 года назад
It is unitless
@ԹԹԺԹՌ-լ7ճ
@ԹԹԺԹՌ-լ7ճ 6 лет назад
You Can see on the following video about coordinates using lisp ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J1GK5tIzR7w.html
@merkur5606
@merkur5606 4 года назад
My autocad doesnt understand the "PO" command
@LearnExplore
@LearnExplore 4 года назад
Then just copy the x,y column and in AutoCAD click "Multiple Point icon" and paste the data in command bar
@LearnExplore
@LearnExplore 4 года назад
By doing this you can able to import points in AutoCAD
@merkur5606
@merkur5606 4 года назад
@@LearnExplore it works! thanks!
@LearnExplore
@LearnExplore 4 года назад
@@merkur5606 Nice to hear that!
Далее
How to Import Texts from Excel to AutoCAD! (English)
14:23
How to import x,y,z coordinate from Excel to AutoCAD
11:26
ЧТО Я ПОСТРОИЛ 11? | CLEX #shorts
1:00
Просмотров 588 тыс.
Extract coordinates from Google Earth Pro to Excel
6:20
Creating Easting and Northing Coordinates in AutoCAD
4:21
how to Import survey data from excel into autoCAD
3:42
Import coordinates into autocad
7:22
Просмотров 10 тыс.
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
How to Export Survey Points from Excel to AutoCAD
7:12