CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz] ARKANCE | CONTACT - CZ | SK | EN | DE

CAD tip CAD tip # 6713:

Question

CAD 
 %  platform  category 
A
By default, AutoCAD offers table export only to a comma-separated CSV file. The CADstudio TAB2XLS utility adds more commands with options for export of AutoCAD table objects (requires MS Excel).

The TAB2XLS command exports the selected table(s) from your drawing directly to the Excel application, where it creates a new sheet and saves it to the XLS format (single-click export).

The TAB2CSV command exports a drawing table(s) to a text file in the CSV format (comma separated values) in the international format - depending on your Windows locale settings (in many European countries this means using semicolons as value separators and decimal commas instead of points). The CSV file is created in the drawing's folder.

The TAB2TXT command exports data of the selected table(s) to a tab-delimited text file. The TAB2HTM command exports data of the selected table to a HTML table.

Version 1.4 (for 2021 and higher) adds Unicode export, plain text without formatting codes.

Version 1.5 adds the option Multiple for selecting multiple DWG-tables, exported to a single Excel-table.

You can download the TAB2XLS utility from DL Download.

ACADADT
100% *CAD
29.5.2009   22907×  
   
this tip shared by ARKANCE experts applies to: AutoCAD · AutoCAD Architecture ·

See also:
Tip 14681:How to quickly convert XLS tables to CSV format without opening Excel?
Tip 14361:Extended ATTOUT/ATTIN for block attribute management in Excel (also for LT).
Tip 14218:Does Inventor support Sensitivity Labels in MS Excel tables?
Tip 13855:DBXscanLayers and DBXscanBlocks - bulk report content of DWG files in a folder.
Tip 13784:Export block coordinates to a table. How to use the DATAEXTRACTION command in AutoCAD LT?


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
  





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.
TOPlist