CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 18559

CAD tip CAD tip # 8559:

   
Question CAD 
 %  platform  category 
Q - question

How to export AutoCAD drawing texts to Excel?

A - answer 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. 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.

ACAD
100% *  CAD 
1.4.2012    75640×  
Prices - CAD eShop:
applies to: AutoCAD ·

See also:
Tip 14059:Import coordinates from CSV files into Fusion profiles.
Tip 13855:DBXscanLayers and DBXscanBlocks - bulk report content of DWG files in a folder.
Tip 13826:Overview of a document history in Autodesk Docs.
Tip 13784:Export block coordinates to a table. How to use the DATAEXTRACTION command in AutoCAD LT?
Tip 13766:Edit the Fusion 360 CAM tool library using 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   



Featuring:
Increase your productivity with our set of BIM add-on functions for Autodesk Revit
CADstudio Revit 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.
TOPlist