Cart

No products in the cart.

Bringing Excel Spreadsheets into AutoCAD

Bringing Excel Spreadsheets into AutoCAD

  • 1 Min Read

AutoCAD 2005 brought us the long awaited Table object, and later versions have improved it to support more advanced features including formulas. The Table object allows you to create a table in AutoCAD that has rows, columns, and cells that can be formatted with a table style. You can also create a table with a copy and paste directly from Excel. You may have done this in previous versions and created an OLE object, which is still an option. But if you prefer not to use the OLE object, or if you have had problems with it in the past, you can now use the Paste Special command to create a Table object. After copying the desired data in Excel, in AutoCAD select Edit >> Paste Special.

16

Choose the option to Paste as AutoCAD Entities. Then click <<OK>>. This will create a table in AutoCAD populated with the data you copied from Excel. The table can be formatted by grip editing, using the Properties command, or editing the Table Style with the Format >> Table Style command.

Author

  • Rick Ellis, president of CADapult Software Solutions, Inc, has worked with and taught Autodesk Civil 3D, along with Map 3D and other Autodesk products since the mid-90s. He is the Author of several critically acclaimed books on Autodesk Civil 3D, AutoCAD Map 3D, Land Desktop and Carlson Software; including the Practical Guide  series.

    Rick continues to use Autodesk Civil 3D on projects in a production environment, in addition to teaching classes to organizations both large and small around the country, helping them get the most out of their design software investment.

    This practical background and approach has made him an award winning speaker at Autodesk University and a sought after instructor by organizations around the world.

Leave a Reply