How to link an Excel file to AutoCAD

Here is a quick way How to link an Excel file to AutoCAD.

The TABLE command in AutoCAD allows you not to only import your data from excel to AutoCAD but it also allows you to link both files together. That will make any change from excel to be having a possibility to being updated in AutCAD.


cad exercises

To link an excel file to your dwg file:

step 1

Click on TABLE


Step 2

Select FROM A DATA LINK and click on B to launch the data link manager dialog box


Step 3

Click on Create a new excel data link


Step 4

Type a name in the following window and hit the OK button


Step 5

Click on […] button to browse to your Microsoft excel file in your computer


Step 6

Press ok as many as you need to close all windows, and position the table in the drawing area. You will observe that all data in your table are similar to the one in your excel file.

Every time you change data in the excel file, AutoCAD will notify you about the change of data in the linked file and will ask you if you would like to update the table in AutoCAD.


Clicking on the link Update tables using the data link: will update the content in AutoCAD.



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.