CAD tip # 8559:

Question

CAD

% platform category

How to export AutoCAD drawing texts to Excel?

You can use the DATAEXTRACTION command to export contents of selected texts to XLS. Much simpler method is the Txt2XLS utility downloadable from Download.

Just AppLoad the VLX file and start the TXT2XLS command. All selected text are directly copied to a table in an Excel sheet (or to a CSV file in AutoCAD Lt). It will either launch Excel and create a new table, or insert the texts to the currently opened Excel sheet (starting in the select cell).

Use fence-select to keep the desired order of selected texts.

Since V1.3, MTexts are exported as pure texts, without the formatting codes. If you want to keep the full format, with formatting codes, set the LISP variable:

(setq _TXT2XLSfullMtext T)

ACADACADMPlantCivil3DACADEACLT

*CAD

1.4.2012 85697×

Comments Tell a friend

applies to: AutoCAD · AutoCAD Mechanical · AutoCAD Plant 3D · Civil 3D 3D · AutoCAD Electrical · AutoCAD LT ·

See also:
Tip 14361:	Extended ATTOUT/ATTIN for block attribute management in Excel (also for LT).
Tip 14304:	How to generate a report of used blocks including their visibility status in AutoCAD LT?
Tip 14218:	Does Inventor support Sensitivity Labels in MS Excel tables?
Tip 14059:	Import coordinates from CSV files into Fusion profiles.
Tip 13855:	DBXscanLayers and DBXscanBlocks - bulk report content of DWG files in a folder.

Selected tip: Are there any games for AutoCAD?

Back All CAD Tips

Concurrent editing of a DWG file from two remote PCs. « | » Marking menu on electrical objects in AutoCAD Electrical 2013.

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:

Text:

FAQ

Featuring:
Automatic nesting of 2D parts on rectangular sheets in AutoCAD
AutoNEST 2008 More info

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

CADforum

Tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion, Forma, 3ds Max and other Autodesk software (community support by ARKANCE). See About CADforum.

ARKANCE CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner

CONTACT:
webmaster.cz@arkance.world | tel. +420 910 970 111



Visitors now: 8902