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: 2976

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    61385×  
Prices - CAD eShop:
applies to: AutoCAD ·

See also:
Tip 13531:Thumbnails have incorrect size after exporting the BOM to Excel.
Tip 13522:LookupXLS - populating DWG texts from Excel spreadsheets.
Tip 13485:Multi-line keynotes in Revit.
Tip 13091:3DSolSz - list of dimensions of selected 3D solids.
Tip 12926:How to import point coordinates from Excel to AutoCAD?


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:
Add .CIT raster format support to AutoCAD and Map and Civil 3D
CITin 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