AutoCAD Excel Data Links: Insert and Update Tables

How-to basics · Updated November 18, 2026

To insert Excel data in AutoCAD as a linked table, run TABLE, choose From a data link, create an Excel data link, select the workbook and cell range, then place the table in the drawing. The link lets you refresh the AutoCAD table when the source spreadsheet changes; it does not automatically update the drawing every time you edit Excel.

What an AutoCAD Excel data link does

An Excel data link connects a table in a DWG drawing to a selected part of an Excel workbook. The DWG stores a named link definition and a reference to the source file. The table displays the linked spreadsheet data, while the workbook remains a separate file. This is different from copying and pasting cells as plain text: a linked table can be refreshed from its source without rebuilding it cell by cell.

Data links are useful for schedules, equipment lists, room finish tables, quantity summaries, and other drawing information maintained in a spreadsheet. For example, a project team might keep an equipment tag, description, and model number in Excel, then place those columns in an AutoCAD drawing. When a model number changes in the workbook, updating the link can bring that changed value into the table.

Think of the link as a controlled connection, not a live two-way synchronization service. You choose when to update, and the link depends on the drawing being able to find the workbook. If the file is renamed, moved, or unavailable, the table may show older data until you restore or repair the reference.

How to create and insert the linked table

On AutoCAD for Windows, the table workflow is generally available from the TABLE command. Ribbon labels and dialog details can differ by AutoCAD release, but the essential sequence is to define the spreadsheet link and then place the resulting table.

  1. Save the Excel workbook in its intended project location. Close or save changes in Excel before linking so the file contains the latest values you want AutoCAD to read.
  2. In AutoCAD, run TABLE. In the Insert Table dialog, select From a data link under the insert options.
  3. Choose the option to create a new Excel data link. Give the link a meaningful name, such as EquipmentSchedule, and browse to the workbook.
  4. Select the worksheet and specify either a cell range, such as A1:C18, or the sheet option offered by the dialog. A defined range keeps the table focused on the relevant cells.
  5. Review the available cell and formatting options. These control how spreadsheet values and appearance are brought into the AutoCAD table. Choose settings that suit the drawing rather than assuming the Excel layout will transfer exactly.
  6. Complete the link setup, select the new link in the table insertion dialog, configure table options as needed, and place the table in model space or a layout.

You can also use the DATALINK command to open Data Link Manager and create or manage a link before inserting a table. This is useful when you want to define the connection first or inspect links already stored in the drawing.

Choosing the worksheet, range, and file location

The cell range determines what AutoCAD brings into the table. Include the header row if you want column labels, and avoid selecting unrelated notes or empty columns. For example, if A1:C18 contains a header and 17 equipment records, linking that range should produce a compact three-column schedule. If the source range later grows, check whether the link definition covers the new rows; do not assume every range automatically expands like an Excel Table.

Give the source workbook and the named data link clear, stable names. A drawing called Level-02.dwg linked to a generically named Sheet1 connection can be difficult to maintain when a project contains many files. A name that identifies the drawing purpose or schedule makes Data Link Manager easier to use.

Plan the path before sharing the drawing. A link that points to a workbook on one person’s desktop may work only on that computer. For a team, put the DWG and workbook in an agreed project folder or shared location, and preserve their relative arrangement when moving or issuing the files. When paths change, use Data Link Manager to locate the workbook again. Sending only the DWG does not necessarily send the Excel source with it.

Updating the table after Excel changes

After editing and saving the workbook, update the table in AutoCAD to retrieve the source data. Run DATALINKUPDATE and select the linked table or tables when prompted, then choose the update direction offered by the command. In many workflows the needed action is to download changes from the source file into the drawing. AutoCAD may also report that linked data has changed and prompt you to update.

Updating is usually a deliberate step rather than a keystroke-by-keystroke connection. That separation is helpful: you can review spreadsheet changes first and refresh the drawing when they are ready to appear on the plan or sheet. It also means a plot can contain stale data if the workbook was changed but the table was not refreshed. Before issuing drawings, save the workbook, update the link, and review the table in the drawing.

A link can support changes being written back to the spreadsheet when the relevant write-back option is enabled, but this should not be mistaken for unrestricted editing of Excel from AutoCAD. Availability and behavior depend on the link and table settings. Treat Excel as the data authority unless the project specifically uses and tests write-back; otherwise, edits made in the drawing may not be reflected in the workbook.

Formatting and what transfers from Excel

AutoCAD tables have their own table styles, text styles, cell formatting, row heights, and column widths. Link setup includes choices that affect whether formatting is taken from Excel or controlled by AutoCAD. The best choice depends on whether the spreadsheet’s appearance is important or whether the drawing must follow office CAD standards.

  • Use spreadsheet formatting when the Excel layout carries meaningful emphasis, such as number formats or selected font and fill choices. Check the result in AutoCAD because spreadsheet and drawing units, fonts, and layout behavior are not identical.
  • Use an AutoCAD table style when the table must match drawing standards for text height, borders, and plotting. A CAD style can make several schedules more consistent, though it may not preserve every Excel visual detail.
  • Review widths and heights after insertion. Long descriptions, wrapped text, and different fonts can make a table wider or taller than the source sheet suggests.

Formatting is not the same as data. A cell can contain a value that displays differently in Excel because of number formatting, or a formula whose displayed result changes after recalculation. AutoCAD is intended to show linked table content, not reproduce the full spreadsheet experience: do not expect Excel formulas, charts, conditional formatting rules, or interactive controls to become equivalent AutoCAD objects.

Common problems and practical fixes

If AutoCAD cannot find the workbook, first check that the source file still exists at the saved path and that you have access to its folder. Open Data Link Manager, select the link, and correct the source location if necessary. Then update the table and save the DWG. When handing work to another person, check the link on the recipient’s project setup rather than assuming a path that works locally will work for everyone.

If the table does not show recent edits, save the workbook, confirm the intended sheet and range, and run DATALINKUPDATE. Also check that you updated the correct table and that the edited cells lie inside the linked range. A changed row outside the chosen range cannot appear just because the rest of the table updated.

If the table looks different from Excel, inspect the link’s formatting choices, the AutoCAD table style, text height, column widths, and font availability. A missing font or a CAD style overriding imported appearance can change line wrapping and table size. If text appears clipped, enlarge the relevant column or row and confirm that the cell content is not being limited by the chosen table settings.

If a link is broken after a project folder is reorganized, avoid deleting and recreating the table as the first response. Repair the existing link’s file reference where possible, update it, and verify that the displayed cells correspond to the intended worksheet and range. Keeping a backup DWG before major link changes makes recovery easier.

Data link compared with copy and paste

A data link is suited to information expected to change and requiring a repeatable refresh. It retains a connection to a workbook and can reduce manual re-entry errors. It also introduces a dependency: the source file must remain available, the right range must be selected, and someone must update the drawing at the appropriate time.

Copying and pasting as ordinary AutoCAD table content is simpler for information that is final or unlikely to change. It avoids a source-file path issue, but later spreadsheet edits will not flow into the drawing; changes must be copied again or entered manually. A pasted OLE object is another distinct approach: it can display spreadsheet content as an embedded or linked object, but it is not the same as a native AutoCAD table whose cells are associated with a data link. Choose based on the required appearance, editability, and update process.

Version and collaboration considerations

The commands and dialogs described here refer to AutoCAD on Windows, where Excel data-link workflows are commonly documented. Exact labels and available options can vary with AutoCAD release, product edition, and installation. AutoCAD for Mac does not necessarily expose the same Excel integration or dialog choices as Windows, so check the help for the installed Mac release rather than assuming the Windows steps apply unchanged.

For collaboration, agree who maintains the workbook and who updates the drawing. Keep the workbook in a project-controlled location, avoid changing worksheet names or ranges without notifying CAD users, and include the source file when the drawing package requires it. Before plotting, verify both the visible table and the link status. A data link improves consistency only when the source, range, and update procedure are managed consistently.

Frequently Asked Questions

Can AutoCAD link an Excel spreadsheet to a table?
Yes. Create an Excel data link through the TABLE workflow or Data Link Manager, choose the workbook and cell range, then insert a table that uses the link.

Does an AutoCAD Excel table update automatically?
Not every time a spreadsheet cell changes. Save the workbook and refresh the linked table in AutoCAD, commonly with DATALINKUPDATE, before relying on the drawing’s displayed values.

Can I link only selected Excel cells?
Yes. Specify a worksheet and a cell range when creating the data link. Include the headers and all intended records, and revise the link if the data later extends beyond that range.

Why is my AutoCAD data link not updating?
Check that the workbook is saved and accessible, the link points to the correct file, and the edited cells are inside the linked range. Then run the update command and confirm the intended table was selected.

Can I edit the Excel values from AutoCAD?
Some link settings allow changes to be written back to the source, but that behavior depends on configuration and should be verified before use. For a predictable workflow, make spreadsheet edits in Excel and update the drawing from the source.

Does the DWG contain the Excel workbook?
Usually, the DWG contains the table and a reference to the external workbook, not a self-contained copy of the source file. Keep or provide the workbook and repair the path if it is moved.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.