How to Import Texts from Excel to AutoCAD! (English)
HTML-код
- Опубликовано: 27 июл 2017
- For your practice DOWNLOAD this EXCEL file
Download Link: goo.gl/bhzaeB
Best offer Today: fkrt.it/jcNGpTuuuN
SUBSCRIBE us if it helps you
In this video You will learn how to import texts with respective labels (Codes and RL s) from an excel data sheet to AutoCAD.
import text from excel to autocad directly in batch.
SUBSCRIBE us (Its FREE)
Watch Part-I : • How to import X Y coor...
(How to import Points/X,Y Co-ordinates)
Watch Part-III : • How to Create a Topo M...
(How to import Lines from excel to AutoCAD)
Excel is a very important tool for the engineers to make any drawing fast and
easy in AutoCAD.
I have applied the same here. I have used some easy commands and formulas that will make you
understand and you will be able to import texts with just a single click !
And if you think this tutorial is helpful and if it relates to you in any way ghen pls
Like & Share and SUBSCRIBE our channel
Visit our blog: learnmoreexplo...
With best wishes
L&E Team!
For your practice and clear understanding i have given the download link of the file bellow
Donate us here: www.paypal.me/learnxplore
Download link:
drive.google.com/open?id=1G6kOv5E51raHZUPeR7rX1zf2qa2Nh-gP
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!)
1 SUBSCRIBE = 10 Thank You to me :-)
Keep exploring
thanks a lot. I couldn't find anything about importing text to auto cad, except your tutorial. thank you so much. you solved my problem
we will try to give you more helpful videos.. thanks for like our tutorials videos..
Taught in a very simple way. Many Thanks to you..
Thank You for your valuable feedback 😊
In AutoCAD Layout sheet , important difference text in different positions, in change in Excel sheet and automatic change in cad layout file
I wish I could like this video 1million times. What you just taught in this video took me about 4hours last week at the office because I was putting the point labels one by one. Now I have done it in less than 5minutes. Thank you
Thanks for your valuable feedback. Don't forget to watch our latest videos.
Hope we will serve more to you
Amazing
too Good its very useful for new workers
God Bless You and May you Live long
Really Good - Thanks!! I searched for hours for instructions that are useable... Thanks Thanks Thanks!!
You're welcome!
Excelent tutorial sir.I have been looking forward and searching extensively for this kind of tutorial.Thank you very much
You are welcome sir
YOURS IS A EXCELLENT WAY OF TEACHING.
I WILL REGULARLY WATCH.
Evabei amader pase thakben. 😊
@@LearnExplore do you have any video recording of how to reference a drawing in coordinate drawing?
Yes we already have uploaded. Pls check
You are a Genius! Thank You
Thank you, very nicely explained, easy to understand. All the best in your further videos.
Mannnn. You hit it . Thanks for this awesome tutorial.
I tried it out and it works! Thank you!
If the points could be sorted out in layers would be awesome. ( example concrete slab layer)
To import points layer wise use this
ruclips.net/video/AEeYQ_Nwtr0/видео.html
When I'm pasting Rl and text in AutoCAD it is showing only some co-ordinate points , it's not showing on every coordinates points , how can we fix it ?
Wonderful and simple lectures, you're just so good.
Regards, ad
Thank you
THANK YOU SOOOOOOOOOOOOOOOOOOOOOOOOOOOO MUCH
sir why you did plus 0.5 in B5 i could not under stand this point please describe
+imtiaz ahmed
Dear Imtiaz
I have added 0.5 with B5 to shift the Text Label at a distance of 0.5 m to right side. otherwise the text may overlap with the point.
Since B5 represents Easting value if we add 0.5 then the text will move 0.5m towards the east side. U can add 1m also.
Same if we add 1m wiith C5 i.e. Northing then the text will move 1m upside.
I think u understood now.
If any question then feel free to share.
Thank you
Superb job ! already pressed Bell Icon .
very cool and helpful, thanks!
can you give any softwear for ,this text and cordinet and elivation , just a clik can enter in autocad
+Nath Nityananda
I have attached the excel file EXCEL file (which I used in the video). Download it in order to draw the text or elevation in AutoCAD directly.
Thanks
Superb. Sir How can i import levels as a text at specified offset in a straight line instead of co ordinates? I have to draw a longitudinal section of a canal.
YES you can!
same procedure is applicable.
keep Y coordinate value as same and change X coordinate value.
I will make a video on L Section by excel and autocad.
THANKS FOR THIS GOOD TRICK AND TIPS.
Thank you... i learn somthing new..
Md. Aslam Ansari thank you for your kind words
VERY HELPFUL
Thank you so much
Very Helpful. Thank You
I learned something on this video ....& waiting for next....
Thank you and support us
SUBSCRIBE our channel to get updates
superb job sir. but this Text formulas not working in draft sight. can you help me draft sight matter
What is draft sight? Can u explain?
Hello sir. Thank you for this very helpful video. May you please make a video about how to insert dimensions in AutoCAD from Excel. Highly appreciated thank you.
Use this
DAL E1,N1 E2,N2 E3,N3
Where E1,N1 & E2,N2 are coordinates of two points of the dimension
and E3,N3 is the coordinate of placing of dimension usually above the line.
THANK U THIS TUTO REALLY HELPS ALOT!
Thank you Soo much for this..
Also would you clarify if you want to use integer instead of text, which command will you use?
Same command.
If you want to plot interger as 23.430
Then apply this in text column
Text(B2,"0.000")
Where B2 is the cell id of the integer
you are great. God bless you.
Did you remove the Part 3 from RUclips? I want to learn how to plot the lines automatically. Please help with a link. Thank you.
Never Mind, I have found it here ruclips.net/video/9UF6mvyM6AY/видео.html
Good. Have a good day 😊
love you sir, thank very much. im enjoy good joob
Thank you sir. Very useful.
Superb Video Mam.............
Thank You SOOOOOOO Much....
Hi, thank you for very useful movies. I have a small problem. When I copy text from excel to AutoCAD (as you advised) only every second line is copped. Can you support me in this? Thank you in advance.
apply ST command and set text height first. Then apply copy and paste in autocad
Thanks for such a complete "how-to" video. How do you make these videos?
Thnx for the feedback.
I make videos by simple screen recorder.
Now I am using little bit White Board animation in my videos. Please watch our latest video
Wonderful job I hope to learn that I am a newbie.
Please I need to know an irregular shape drawing
composed of lines and curves connected together.
So that the coordinates are entered by form and
the drawing is on the default drawing
Thanks
Use POLYLINE command
You can draw both LINE and ARC continuously.
Res.Sir
mai ne ye excel try kiya lekin isme agar 5 point leta hu to 4 point run hote hai
aur mai ne khud k coordinate sheet liye the jo pahela coordinate hota hai na o run nahi hota hai aur bich me kuch coordinate k text b missing hota hai
Thank you so much ❤️
Bro thanks a lot for the video pls make a video on landscape layout planning in autocad and exporting coordinates to total station pls sir its my request btw keep up your good work sir
U r Welcome.
Regarding exporting data to TS pls refer this video ruclips.net/video/YeVmfUyz9Dw/видео.html
Very useful thank you so much....
Hey buddy, it helped a lot. Is it possible that every point has height coordinate (e.c. when i click on point it says E, N coordinate and Z iz 0.00)
Yes possible. Just creat E,N,Z format and apply the same procedures
@@LearnExplore i did it, works like a charm. Thanks a lot :))
I can't find the video for importing lines from an excel data sheet to autocad. Can you send me the link?
Here it is ruclips.net/video/9UF6mvyM6AY/видео.html
Thanks. very helpful
Use SW-DTM. Its totally free. It does what he is doing in an easy manner!
Sir may job text copy korka auto cad may paste korraha to text alg alag height say porta hay code aysha kiu ho raha hay
Command: ST
Change the text height and click APPLY
Ushme text hight change nahi horaha he
Width change kor na por thora chota ho rahi hay
Aysha kyu problem ho raha hay
Text option hoga...thik se dekho...
Screenshot whatsapp karo iss no me 9093833802
Learn & Explore ok
HOW CAN I IMPORT A LOT OF BLOCK WITH HIS OWN ATRIBUTES AND X,Y CORDINATES??????
HELP ME PLEASE
so careful & helpful
Great job
Very useful
good practice
Thank you
nice tutorials bro, only thing you need to adjust is the audio, we cant barely hear what you are saying.
I agreed. Please watch our latest videos
Thanks bro
Where i get Next video of exporting line and features ?
Hi, Please search for how to create topo map. And thank you for your support. Welcome to LE family
Hi bro can u send road x section script or lisp file and video many x sections at same time
Plz provide me very help ful to me
Dear sir
Currently I'm working on that.
Need some time to complete.
Thank u sir
Thanks for your efforts, just one note the voice is too low
Actually this video is the 2nd one whem we hav created our channel. I agre with u that the voice is very low. And it happens because that time i was inexperienced about making video.
SUPER BRO..
thank you sir
Zabardast bhai
Thank You
Welcome!
I want open traversing calculation
Stay tuned
Sir text select karny se pehly ap kya likty he cell me last waly cell me
"=(cell ID of text)"
Good job
Thanks
sir send how to import lines from an excel data sheet to autocad part 3 excil link and video
Watch our 3rd part of this video.
Good job..
Thanks for your support
Tanx bro
Good
Sm process kiya but autocad may all code nahi a raha hay plz help me sir
ST command apply karna mat vuliye
CONTOUR LINES VDO SIR
Where is vedio for importing lines 3 Rd part
Find this video in our channel "How create a Topo map from excel to autocad"
Thank you so much dear
Unable to hear -text format
Sorry for the inconvenience
Nice
Hello sir
I need to lecture 3
Its available in our channel...named 'How to Create Topo Map'
its not working for me..im using autocad 2020
Use ST command before applying it
Not working after applying ST command
Use ST command and set text height
@@LearnExplore thanks its working
Good but layers are not coming
Only one layer is there
Create layer first then paste it
No sir not getting layers
I am asking that different codes are different layer
For example ETP for one layer
Boundaries for one layer
For now you have to do it manually.
We have another video for automatic layer. Which is similar and for import points. You can watch this
ruclips.net/video/AEeYQ_Nwtr0/видео.html
Bro full video updates me
How to enter _ TEXT PLEASE HELP ME
Type single inverted comma before -TEXT
EXAMPLE: '-TEXT
Круто!!!
Text column not clearly
1st class
Plz speak loud
Extremely sorry. Please watch latest videos
Ur sound is not effective
Actually that was my 2nd video on RUclips. I was feeling nurveous
@@LearnExplore How do you make these videos?
Sound slow..
Sorry for the inconvenience caused
The Tutor is giving you something free in a second language...just move on and keep quiet!
@@LearnExplore Don't apologise. Thanks for your help
Nice video, #trustplatform