Can I bring in an excel table and keep it linked to the original file in AutoCAD?

Short Answer

Yes — in AutoCAD, you can import an Excel table and keep it linked to the original spreadsheet by using DATALINK and then creating or updating a linked table from that data link. This is the most common professional method for Excel-to-AutoCAD tables. The limitation is that formatting and formulas do not always display exactly like Excel.

What You Need to Know Before

Warning: A linked Excel table in AutoCAD depends on the original XLS/XLSX file path staying valid. If the spreadsheet is moved, renamed, or on an unavailable network drive, the data link can break or stop updating correctly.

How to Link an Excel Table in AutoCAD

• Command: DATALINK

• Shortcut: No default shortcut

• Quick Steps:

  1. On the Ribbon > Annotate tab > Tables panel, click Link Data, or type DATALINK.
  2. In the Data Link Manager, create a new data link, browse to the Excel file, and select the worksheet or named range you want to use.
  3. Insert the linked table with the TABLE command, choose From a data link, select your link, and enable the appropriate update option if prompted.

Variables & Settings

• Key Setting: Allow writing to source file

• Expert Setting: This option controls whether edits made in the AutoCAD table can be pushed back to the Excel file. In most professional workflows, this is left off unless there is a controlled bidirectional editing process.

Why it Fails

• Cause 1 (Geometry): The selected Excel range includes merged cells, hidden rows, or inconsistent formatting, which can import poorly into an AutoCAD table.

• Cause 2 (layers/Locks): The table may be placed on a locked layer, preventing updates, edits, or repositioning after insertion.

• Cause 3 (Command/Logic): Users paste Excel data instead of using a true data link, so the table becomes static and no longer updates from the source file.

Quick Fix & Best Practice

• Quick Fix: Run DATALINKUPDATE and select Download changes from source file to refresh the AutoCAD table from Excel.

• Manager’s Verdict: Use linked Excel tables when schedules or tabular data change regularly and must stay coordinated. Avoid them for archived deliverables or files sent outside your network, where broken paths are a common problem.

FAQ

Can AutoCAD automatically update a linked Excel table?

Yes, but only if the data link is still valid and the source file is accessible.

Can I edit the linked table directly in AutoCAD?

Yes, but whether changes go back to Excel depends on the data link write settings.

Is pasting from Excel the same as linking?

No, pasted tables are usually static and do not maintain a live link to the original Excel file.

.