Importing Excel spreadsheet tables into AutoCAD®-based products
You want to import a spreadsheet table, such as a Room Finish Schedule, created in Microsoft Excel into an AutoCAD®-based product.
You do not want to import the Excel table into AutoCAD using OLE because of the size limitations and/or other factors.
You can bring an Excel spreadsheet into AutoCAD® as an AutoCAD table object. Follow these steps:
In Microsoft Excel, select the spreadsheet area that you want to import, and copy it to the clipboard.
In AutoCAD, on the Edit menu, click Paste Special.
In the Paste Special dialog box, select the AutoCAD Entities option. This will create an AutoCAD table that can be formatted to match the linetype and text style.