How to Import Texts from an Excel data sheet to AutoCAD! (English)

You know that excel is a very important tool for the engineers to make any drawing fast and
easy in AutoCAD.
Basically for the survey and Civil engineers it works as a great tool for them.

In this post you will get an example for the same. I will show you how to import texts from an excel data sheet to an AutoCAD drawing easily.
I will apply some easy AutoCAD COMMANDs and Excel FORMULAs that will make you
understand and you will be able to import texts with just a single click !

Now I'm coming to the main topic.
To import the texts there is a formula of four columns that you have to type in excel.
The Formula used is : -TEXT | (E,N) | 0 | "TEXT"
See the bellow example:-

See there are four nos of columns I have mentioned in the formula

(1) In the first column there is "-TEXT"
"-TEXT" is an AutoCAD command
Note: If you type as -TEXT then it will show an error like #NAME?
 
 To avoid this you have to type like this '-TEXT (single quotation then -TEXT)

(2) In the second column there is (E,N) i.e. Easting,Northing or X,Y
To create E,N format the formula is
=[cell ID of Easting]&","&[cell ID of Northing]
for an example:   =B5&","&C5

=B5&","&C5

or CONCATENATE([Cell ID of Easting],",",[Cell ID of Northing]) this is also used
and

=CONCATENATE(B5,",",C5)

If you didn't understand the above formula then You can watch here for the formation of Easting,Northing format.

well lets come back to the main formula -TEXT | (E,N) | 0 | "TEXT"
after formation of (E,N) there is
(3) Rotation angle in the 3rd column i.e. 0
you can also give it as 90 also that is totally on your choice

and in the
(4) last column you have to put the text which you want to import.

so this is the four column formula drag the cells to your data end.
one more thing to keep in mind is that
Before applying the formula in AutoCAD you have to set the Text Style in AutoCAD first.
for that you can directly enter ST as a command or else go to Format menu in AutoCAD and then find Text Style and give an appropriate text height as your preference.

Now copy all the four columns and Paste into the command bar then you will see the successful result!
Voila!!

Here I have made a video for importing Texts data from excel to an AutoCAD drawing :
you can watch it to get more accurate knowledge. And please don't forget to comment your doubts and your suggestions.

Also SUBSCRIBE to our YouTube channel Learn&Explore to get more such updates about excel and AutoCAD!


watch the Part-I : https://youtu.be/9kSg8mpF6n0
(How to import Points/X,Y Co-ordinates)

watch the Part-III : https://youtu.be/9UF6mvyM6AY
(How to import Lines from excel to AutoCAD)

With best wishes

L&E Team!

Keep Supporting Thanks and a lot of Love! L&E Team