Import Text from Excel to AutoCAD

This session is about creating Text in AutoCAD using data present in an Excel sheet. Using a simple Excel formula we can create 1000s of Text Objects within no time.
Topics Discussed are :
1. Excel Formula for creating Text in AutoCAD
2. Controlling Height and Rotation using Cell References
3. Importing Finished Roads and Original Ground Levels into an AutoCAD drawing
4. A macro for extracting details of all those Text Objects (X,Y,Z Coordinates and Text) present in an AutoCAD drawing
Join my course on VBA for AutoCAD
🔵 www.udemy.com/...
🟢 www.udemy.com/...
Follow the link to download AutoCAD Macros
🟡 xlncad.com/mac...
Subscribe to the channel for more
/ ajayanandxlncad
🟠 Books on Excel xlncad.com/exc...
🟡 Get Office 365 Subscription microsoft-us.e...
🔵 Download my free ebook on Excel Macros eepurl.com/gpT0RD
🟢 Read my articles on Excel xlncad.com/
🟣 Join my free course on Excel Tables www.udemy.com/...
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!
#AutoCAD #AutoCADVBA #AutoCADMacro

[@AjayAnandXLnCAD]

Join my course on VBA for AutoCAD 🔵 www.udemy.com/course/programming-in-autocad/ 🟢 www.udemy.com/course/scripting-in-autocad/

[@sarfrazahmed249]

I tried this. 100 percent working. Thanks

[@sarfrazahmed249]

Assalam alaikum Aap Ka samjhane Ka style bahut achchha hai. Today I practice 100% success May God bless you

[@AjayAnandXLnCAD]

Glad to hear that

[@1963cacalo]

Very good! Clear and comprehensive. Thank you!

[@AjayAnandXLnCAD]

Thank you for that awesome feedback ☺️

[@servenmasankay9129]

very Good,Nice

[@AjayAnandXLnCAD]

Glad to hear that. Please check my video on inserting points into AutoCAD

[@manjunathg2652]

Love you Ajay .... Thanks for your VIDEO

[@tarnpreetsinghgill3906]

nice approach and great explanation

[@AjayAnandXLnCAD]

Glad to hear that ☺️

[@jihadabdulhaq]

thanks a lot >> easy clear steps to follow

[@meenakshijena6500]

Thanku so much.. Very Helpful.

[@AjayAnandXLnCAD]

Most welcome 😊

[@mimpianakadam]

great thanks from indonesia.. very hopefull ... :)

[@AjayAnandXLnCAD]

My pleasure

[@thepositiveartist7279]

Thank u sir....this helped me a lot

[@SuperJaice]

Informative...

[@AjayAnandXLnCAD]

Thank you ☺️

[@MechScience]

Very helpful video, thanks!

[@mohammedsaifullah6437]

very much informative

[@cholmonurejai..........9892]

Thank you

[@InsideMyWall]

Can you make a video for quantity takeoff from autocad and exporting it to excel. Also how to use count feature to count objects

[@pari111nk9]

It is great, also can you show how to add chainage like 0+000.00 from excel to AutoCAD

[@KetanNagre]

Can I make tables too in same format?

[@jpnfsu]

Thanks!!!

[@AjayAnandXLnCAD]

My pleasure. I recommend you to check out my videos on programming in AutoCAD

[@abdallahal-qutaishat952]

Thank you, it was really helpful :) But I was wondering if I can add more restrictions to the text, such as the layer type, color ...etc. And does this work with the multileader?

[@topocadtechnicianmaster5176]

SIR, IF I WANT MTEXT INSERT WITH LEADER AND TEXT BOX THEN WHAT TO DO ?

[@Gandharpn]

In version 2021, after specifying rotation angle, the cursor moves out of the command line and doesnt take further commands. How to fix it?

[@ROHITKUMAR-qu6si]

but in the case of mtext everything ok but in last (after content) CAD is demanding for an empty cell, not space, any other option?

[@tusherkhan6488]

Thankyou... But autocad to excel data is not update...pls solve this problem

[@AjayAnandXLnCAD]

Glad to see that you like it. Can you please explain what you mean by AutoCAD to Excel data is not update?

[@tusherkhan6488]

@@AjayAnandXLnCAD suppose i import excel table in autocad & write data in excel table & it is autometic transfer autocad. But this problem is when i input autocad table this is not autometic transfer excel table or sheet.... Pls explain how to transfer autocad input data to excel randomly pls pls pls

[@AjayAnandXLnCAD]

@@tusherkhan6488 Sorry to say that I don't understand your issue. If you are looking for Macros that will bridge AutoCAD and Excel, watch my videos on programming in AutoCAD.

[@nocturnalplayer571]

Thanks can u create a data entry for autocad

[@AjayAnandXLnCAD]

Can you be more specific?

[@piotrpiotrowski3986]

works greit tank u mate

[@AjayAnandXLnCAD]

My pleasure friend. Please check my videos on programming in AutoCAD.

[@mdjewelahammed1935]

Thanks

[@koushikghosh9480]

thanks for this useful video. but how can I plot or export chainage with "+" symbol instead of point?

[@AjayAnandXLnCAD]

Can you please explain the question with an example?

[@shujath9176]

I need some hundreds of text in my construction drawing. But how can I get the coordinates for those locations where I want my text to fit in the drawing..?

[@AjayAnandXLnCAD]

Do you have AutoCAD points or any other AutoCAD object at those locations?

[@shujath9176]

@@AjayAnandXLnCAD We have Architects Xrefs where we will add circuit numbers as text on it. Can we get coordinates by running a polyline over that paths.

[@NimishP]

@@shujath9176 can you provide a sample drawing. Or generate a video of your screen activity to have a better understanding of your workflow.