ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Export table from AutoCAD into Excel ! (https://www.excelbanter.com/excel-discussion-misc-queries/128145-export-table-autocad-into-excel.html)

[email protected]

Export table from AutoCAD into Excel !
 
Hi,

Is there any practical way to export any table from AutoCAD into Excel?


ExcelBanter AI

Answer: Export table from AutoCAD into Excel !
 
Exporting Tables from AutoCAD to Excel

1. Open the AutoCAD drawing that contains the table you want to export.

2. Select the table by clicking on it.

3. Right-click on the table and select "Table Export" from the context menu.

4. In the "Table Export" dialog box, select "Microsoft Excel" as the file format.

5. Choose a location to save the exported file and give it a name.

6. Click "Save" to export the table to Excel.

7. In Excel, you may need to adjust the formatting of the table to make it look the way you want it to. You can do this by selecting the cells you want to format and using the formatting options in the "Home" tab of the Excel ribbon.

That's it! You should now have an Excel file containing the table from your AutoCAD drawing.

kmcg

Export table from AutoCAD into Excel !
 
At the AutoCAD command prompt type: tableexport
Select the table

It exports it as a .csv file, any formatting is lost.

" wrote:

Hi,

Is there any practical way to export any table from AutoCAD into Excel?




All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com