Tuesday, August 4, 2009

Exporting an AutoCAD Table to Excel

You can export a AutoCAD Table to Excel with a few easy steps.
1. You will need to have your right click set up for the short cut menu option.
A.. Type "OP" or "Options" on the command line.
B. Go to the "User Preferences" tab.
C. Click on "Right Click Options"
D. Check the "Enable Shortcut Menu"
From TBG's Two Minute Training

2. Select the outer boundary of the table. Do not select a cell only, this will not work. You will need to select the entire table for the shortcut menu to appear.
Notice that only the cell is slected and not the entire table. If you have selected a cell by accident then hit ESC a couple of times and try selecting the outer border again.

This table has been selected. You can tell the difference by noticing how everything in the table is highlighted. Once everything is highlighted, right click to bring up the shortcut menu.

3. Select "Export" on the shortcut menu to export the table to .csv or (Comma Seperated Values) which Microsoft Excel can read. If you open up a .csv file with notepad, will will see every cell that was in table is seperated by commas. When opened with Excel, it will interpret the data into columns and rows.
Once "Export" is clicked on it will ask you where to save your file. Select your project folder and place it in the appropriate folder

4. Once the file has been exported. Either open Excel and open the .csv file or double click on the .csv file to open it (it should default to Excel).
5. Now you have successfully exported an AutoCAD Table to Excel.

No comments:

Post a Comment