CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products []
CZ | EN | DE
Login or
  Visitors: 6423
Plex.Earth connects AutoCAD and Google Earth

CAD tip CAD tip # 9814:

Question CAD 
 %  platform  category 
Q - question

Export text from DWG drawings to Excel.

A - answer Using the free AutoLISP utility CADstudio Click2XLS with its added command Text2XLS you can easily transfer picked AutoCAD drawing texts to a MS Excel sheet (automatically created or pre-prepared). All types of drawing text objects are supported - single-line and paragraph texts, block attributes (incl. nested), attribute definitions, dimensions, leaders, tables (except table cells written in TrueType fonts). If MText texts are formatted, Excel will receive cleaned up, pure text.

The "Paragraph" mode will write clicked MText paragraphs to individual cells.

Sample video:

You can download the Click2XLS utility from

100% *  CAD 
8.5.2014    26603×  
Prices - CAD eShop:
applies to: AutoCAD ·

See also:
Tip 13683:Limitations of the LISP language (AutoLISP, VisualLISP) in AutoCAD LT - what to watch out for
Tip 9594:Click2OO - export of AutoCAD coordinates to OpenOffice Calc.
Tip 8030:Click2XLS - click points to export from AutoCAD to Excel.
Tip 7258:Export of point- and curve coordinates to Excel.

Back   All CAD Tips

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   

Use Google Earth images in your AutoCAD projects with the Plex.Earth Tools More info

Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.