How to import Excel table to AutoCAD, and export it

Updated on October 23, 2023 by Jaiprakash Pandey, Affiliate Disclosure

In this article, I will explain methods by which you can import and export a table from AutoCAD to Excel.

200 AutoCAD Commands PDF eBook

Get our free PDF eBook containing a collection of 200 AutoCAD 2D and 3D commands

Let’s first start with importing a table.

Importing excel table in AutoCAD

In AutoCAD, you can import excel table as OLE object which is linked to its original source or as an independent AutoCAD table where it is not linked to its parent table.

For this example, I will use this sample table made in MS- Excel to demonstrate how this process works.

We will start by linking table as data link.

Importing as a data link

Open excel file downloaded from the link above and select table completely then right click and select copy from the contextual menu.

You can also use CTRL+C to copy table. 

Now open AutoCAD and click on paste special from clipboard panel of the home tab as shown in the image below.

Paste special window will pop up, in this window select Paste Link radio button and click on the Microsoft Excel Worksheet option and click OK.

Now specify a location in the drawing area to paste this table.

The table will now appear in drawing area just like any other Excel table.

This table will retain its formatting like line width and cell merges and it will also remain linked with its parent table from where it is copied.

Now open MS-Excel table and make any change in it and save it.

Then go to AutoCAD window and type REA to regenerate your drawing and you will see that table is updated in AutoCAD too with changed value.

Importing as AutoCAD entity

You can also import table in AutoCAD as a standalone entity so that it remains completely isolated from excel table.

Repeat the whole process of copying table from MS-Excel and select paste special again from clipboard panel of the home tab.

But this time select AutoCAD entities option from the Paste Special window and click OK.

Now specify a location to paste your table in the drawing area. The table will be inserted as an AutoCAD entity and it will retain its formatting too.

In this case, you will observe that table has no relation to its parent MS-Excel table.

Any change made to that parent table will no longer be reflected in the AutoCAD table.

Exporting table from AutoCAD

You can export a table from AutoCAD in a format like CSV which can be read by the MS office application.

Table exported from AutoCAD does not retain its formatting which means cell color, cell merging, and border styles are not retained in CSV format.

You can however add formatting in the excel file after exporting it from AutoCAD.

To export a table select it completely then right click and select Export from the contextual menu, Export data window will pop up.

Now name your table and provide a location where you want to save it and click save.

A new table in CSV format will be saved at the specified location.

This table can now be opened with MS-office and other CSV compatible applications.

Summary

Apart from importing table from excel you can also import coordinates from excel to AutoCAD.

If you have questions related to this article, let me know in the comment section down below.


Disclosure: On this site, we have placed some recommended products and services from which we get an affiliate commission for every purchase you make without any extra cost to you. Learn more about our affiliate process here.

Get SourceCAD free courses

Start learning your CAD and engineering tool for free with our free courses and eBooks. Get a certificate of completion on finishing the courses.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>