May 12, 2014

Tip : Convert Autocad Text to Excel

The following procedure allows you to copy text from AutoCAD and paste it in excel as a text.






Autocad:

First copy and stack the text in a column. Go to “express tools” and select convert text to mtext. now select all the text and click enter. All the texts are now a single entity and a multiitext. 

Copy the text file and paste it in an excel sheet. The text will be in one cell and in a horizontal line.

Excel:



This is how the text will appear when pasted in a excel sheet in order to arrange the text in separate rows ,go to DATA tab and click on TEXT TO COLUMNS icon and select DELIMITED option.



Tick on “Space” and then select next. Then finish




Now all text will be in separate horizontal cells (row)

Now in order to arrange the text in a column, select the entire row 1 and then select COPY.
Click on any other cell and then right click to select PASTE SPECIAL



In the dialogue box select TRANSPOSE  as shown and then OK






Repeat this procedure as required.



Note: When Text to column once selected in a cell (cell 1a) and the contents in that cell is deleted and another content is pasted in the same cell, it is not required to repeat the procedure (sorting of text in different cells) again.

31 comments:

  1. Hello Mr. Bijoy, i have lisp for export Coordinates points to Excel directly.
    http://www.cadstudio.cz/en/download.asp?file=Click2XLS.

    ReplyDelete
  2. Working good. I have used this to export Drawing List From Autocad

    ReplyDelete
  3. KUDOS!!! I lost my lisp and I found this technique very helpful. Thanks!!!

    ReplyDelete
  4. CAN YOU SENT ME LISP FILE
    abhilashvava@gmail.com

    ReplyDelete
  5. CAN YOU SENT ME LISP FILE
    abhilashvava@gmail.com

    ReplyDelete
  6. if there any LISP file will helpful.

    ReplyDelete
  7. please send the lisp file on
    mustafa@fsa.com.sa

    ReplyDelete
  8. if you have lisp routine,plz send it

    ReplyDelete
  9. Please can you send me lisp bharathimanickam@yahoo.in

    ReplyDelete
  10. Please can you send me lisp bharathimanickam@yahoo.in

    ReplyDelete
  11. Thanks Lot, This information very good

    ReplyDelete
  12. Keep posting the good work. Some really helpful information in there. Bookmarked. Nice to see your site. microsoft excel automation

    ReplyDelete
  13. where button express tool? i cant found it... please help me

    ReplyDelete
  14. Can u send me the lisp file , shefionline@gmail.com

    ReplyDelete
  15. Can u send me the lisp file , shefionline@gmail.com

    ReplyDelete
  16. can u send me that lisp file on jty@live.in

    ReplyDelete
  17. Please send me lsp file for export text with northing easting nileshmohite73@gmail.com

    ReplyDelete
  18. Can u send me the lisp file
    srgloriayu@yahoo.com

    ReplyDelete
  19. Can you send me the lisp file
    johnluoca@gmail.com

    ReplyDelete
  20. Hi,
    thanks for the valuable information can you please send this lisp to roshansanjeewa1@gmail.com

    ReplyDelete
  21. Hi,
    Thanks, very helpful tip even without lips

    ReplyDelete
  22. PLEASE SEND THE LISP TO MY MAIL
    rraaghqtr@gmail.com

    ReplyDelete
  23. PLEASE SEND THE LISP TO MY MAIL

    tushar.mhaskar@gmail.com

    ReplyDelete
  24. Very informative and impressive post you have written, this is quite interesting and i have went through it completely, an upgraded information is shared, keep sharing such valuable information.
    microsoft office malaysia

    ReplyDelete
  25. Hi! Can you please send it to me. joaldrintantengco@gmail.com
    Thank you

    ReplyDelete
  26. mohammednisar847@gmail.com

    ReplyDelete
  27. please send the lisp file on
    h.abbasi2012@gmail.com

    ReplyDelete