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

CAD tip CAD tip # 6713:

   
Question CAD 
 %  platform  category 
Q - question

How to export AutoCAD tables to international CSV or TXT files?

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

ACADADT
100% *  CAD 
29.5.2009    17563×  
Prices - CAD eShop:
applies to: AutoCAD · AutoCAD Architecture ·

See also:
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?
Tip 13757:Bulk editing of drawing properties (DWGprops) from Excel.
Tip 13531:Thumbnails have incorrect size after exporting the BOM to Excel.
Tip 13522:LookupXLS - populating DWG texts from Excel spreadsheets.


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