How to import and export a table from AutoCAD to Excel

In this article, I will explain methods by which you can import and export a table from AutoCAD to Excel. Let’s first start with importing a table.

Importing the 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. In this article, I will use this sample table made in MS- Excel to demonstrate how this process works.

import and export table from AutoCAD to Excel

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.

import and export table from AutoCAD to Excel

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.

import and export a table from AutoCAD to Excel

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 and 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.

import and export a table from AutoCAD to Excel

Table exported from AutoCAD does not retain its formatting which means cell color, cell merging, and border styles are not retained in CSV format and after exporting you need to again add formatting to the table if required.

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.

Do you have questions related to this tip? let us know in the comments below.

Get access to all Courses, eBooks and Downloads on SourceCAD

See details
2018-09-25T03:16:24+00:00

About the Author:

I am a mechanical engineer and I have worked with Design, Manufacturing and Training industries but now SourceCAD is my full-time work and I use it to train students all over the world. I also train corporate clients and help them develop the skill set of their workforce. I am Autodesk AutoCAD Certified Professional and an Autodesk expert elite member. I am a regular contributor of AUGI World magazine and apart from SourceCAD I also develop AutoCAD video courses for Pluralsight and other E-Learning businesses.

18 Comments

  1. Logeshwaran December 14, 2018 at 10:18 am - Reply

    i want know if any methods to convert AutoCAD Multi text to Excel format.

  2. Kavita April 25, 2018 at 6:57 pm - Reply

    Hello Sir,

    If we want to export all the tables in the drawing in one shot in one excel sheet, is there any method for this?

  3. walaa February 19, 2018 at 6:29 pm - Reply

    hello.I have Autocad 2017.It does not work.When I export the table, it show only dwxf format.What is the solution.thank you

  4. Pandiarajan January 13, 2018 at 10:25 am - Reply

    Hai Jai sir…
    In Autocad, we can define a line?
    For example: In Nx Cad, if we draw a line means it will Define as P1 =10 or D1=10.
    Like that can we define in Autocad?

  5. kavita September 5, 2017 at 5:03 pm - Reply

    Hi Jai….i am in a great need of exporting multiple tables from Autocad to a single spreadsheet. Is this possible in Autocad 2017? Also do you know any lisp routines which will work for this

  6. James December 6, 2016 at 9:20 am - Reply

    can you export to a specific and existing excel spreadsheet?

    • Jaiprakash Pandey December 7, 2016 at 1:15 am - Reply

      No James It can’t be done, but you can obviously copy the exported contents to the desired spreadsheet.

  7. Anonymous October 29, 2015 at 2:48 pm - Reply

    ITS WORKING FROM WHICH VERSION?????

    • Jaiprakash Pandey October 29, 2015 at 5:17 pm - Reply

      Its hard for me to tell exactly from which version tables are supported but if you are using any version after AutoCAD 2013 then all these tips should work fine.

  8. F.J October 27, 2015 at 2:45 am - Reply

    Thank you to share this information. How can use Autocad table to excel same as like Excel table edit able. i hope you understand my point.

    • Jaiprakash Pandey October 27, 2015 at 11:12 am - Reply

      Yes AutoCAD table can be used as an excel table with most of its features directly derived from MS excel, once you select any cell in a table a table editor ribbon appears with tools which are very much similar to Excel. For more about AutoCAD table see this tutorial video https://www.youtube.com/watch?v=OE-VLZzh_r8

  9. projektowanie cad September 21, 2015 at 1:05 pm - Reply

    nice tutorial

    • Jaiprakash Pandey September 27, 2015 at 5:58 pm - Reply

      Thanks

  10. Manuel E. Lopez September 18, 2015 at 8:00 am - Reply

    I normally do the excel first, then print as pdf, then pull it fron Autocad.

    • Jaiprakash Pandey September 27, 2015 at 6:00 pm - Reply

      Excel does provides great formatting tools and its often quick too

  11. Lily September 16, 2015 at 8:30 pm - Reply

    Thank you to share this information. But when use it, only work at AutoCAD word condition. if UCS changed, How you make Excel table rotate with UCS condition

    • Jaiprakash Pandey September 27, 2015 at 6:01 pm - Reply

      AutoCAD tables are 2D entities and you can’t rotate it in 3D plane using normal rotate tools.

Leave A Comment