Export Selected Text to excel

Export Selected Text to excel

Muthya
Advocate Advocate
1,540 Views
2 Replies
Message 1 of 3

Export Selected Text to excel

Muthya
Advocate
Advocate

I have an AutoCAD Classic drawing file. It contains a table of text. (Schedule). I want to export this to a spread sheet file like Excel as it is. What is the best way to do it. Is there any App available?

What are the disadvantages of using the OLE command to get the texts in the CAD file?

I attach the relevant files.

Thanks.

0 Likes
Accepted solutions (1)
1,541 Views
2 Replies
Replies (2)
Message 2 of 3

Alfred.NESWADBA
Consultant
Consultant

HI,

 

>> It contains a table of text.

Nope, it does not contain a table, not an AutoCAD object "Table".

These are just text-, mtext- , line- and polyline-objects, sometimes 2, sometimes 3 (m)text-objects in one "virtual" cell, so not well structured.

If you have a bit knowledge of programming you might write your tool to get that first in a well structured table, or maybe to a CSV. But I don't know any tool AutoCAD has OOTB that can export this geometry to a (structured) Excel spreadsheet.

 

>> What are the disadvantages of using the OLE command

>> to get the texts in the CAD file?

Do you mean "to use OLE objects in AutoCAD"? ... The biggest disadvantage is that sometimes it makes it hard to print (either invisible on print, sometimes 90° rotated, sometimes fonts destroyed).

My personal opinion is that I avoid OLE as long as possible.

 

Sorry, - alfred -

------------------------------------------------------------------------------------
Alfred NESWADBA
ISH-Solutions GmbH / Ingenieur Studio HOLLAUS
www.ish-solutions.at ... blog.ish-solutions.at ... LinkedIn ... CDay 2026
------------------------------------------------------------------------------------

(not an Autodesk consultant)
0 Likes
Message 3 of 3

3wood
Advisor
Advisor
Accepted solution

Please try TEXT2CSV.

Here attached the conversion result of Telephone ducts details.

You need explode all Mtexts to Texts and Polylines to Lines first - Just explode everything before using TEXT2CSV.

Capture.PNG