The table we made in AutoCAD can be exported in an external file format such as CSV, which you can open with Microsoft Excel. The following steps will show you the method of doing just that:
- To export the table, select it from the drawing area and then right-click and select Export... from the context menu, as shown in Figure 7.22:
Figure 7. 22: The Export... option in the right-click menu of the table
- Specify a location in the next Export Data window, give your file a name, and then click the Save button.
- You will notice that the table is now saved at your specified location in CSV format. Double-click on the CSV file and the table will open in Excel in a simple text-only format with no formatting.
- The table we have made in this example, when exported to CSV format, looks like Figure 7.23 in Excel:
Figure 7. 23: Table exported from AutoCAD to Excel in CSV format
So, as you can see, we can export AutoCAD tables in an Excel-compatible format, with the only disadvantage being the loss of the formatting settings. Just like exporting a table from AutoCAD to Excel is possible, the reverse is also possible, which is explained in the next section.