Data Linking: Exploring the Features and Benefits of AutoCAD

Learning
AutoCAD Data Linking

AutoCAD tables are great — however, in some cases, using Excel is just the better way to edit spreadsheet-like information. That’s where data linking comes in. Data linking is the ability to link a Microsoft Excel spreadsheet or CSV (Comma Separated Value) file to an AutoCAD table. You will have to make sure you have Microsoft Excel installed on your machine for data linking to work, but the end result is worth that (pretty small) hassle. Why? Because the best thing about data linking is that any changes that you make to the Excel spreadsheet or .CSV file will update the AutoCAD table. Plus, if you set it up this way, you can edit the AutoCAD table and it can write back to the spreadsheet (now come on, that is cool).

AutoCAD Data Linking

AutoCAD provides you a one-stop shop for linking Microsoft Excel or CSV files with its Data Link Manager. The Data Link Manager allows you to create, manage, and edit your data links.

You can easily create data links in AutoCAD by launching the Data Link Manager tool, or from within the Create Table command.

AutoCAD Data Linking

AutoCAD Data Linking

Updating Your AutoCAD Table (From Excel)

With a data-linked table, any changes made to your spreadsheet can update. After edits are made to the file in Excel and you hit save, AutoCAD will notify you with a balloon notification in the AutoCAD system tray that the data link has changed. With a simple click on the hyperlink provided, the table will be updated to reflect the changes made in the spreadsheet.

AutoCAD Data Linking

Changing the Look of the Table

When you initially data link an Excel spreadsheet, the formatting comes from Excel. However, if you need to have your table (or even just specific cells in your table) look a certain way, don’t worry; you can define your own cell styles and select them individually, or as a group, and change any aspect of your cells with the convenient Table Cell contextual ribbon.

AutoCAD Data Linking

Updating Your Excel Spreadsheet (From AutoCAD)

So, let’s say you notice something is wrong with the table when you bring it in to your AutoCAD drawing, but you just don’t feel like opening up the spreadsheet in Excel. Well, you don’t have to, because you can change the Excel data without leaving AutoCAD! You can unlock the cells by selecting them and choosing the Unlock option. Once you have edited the cells, a simple right-click and your Excel file is updated.

AutoCAD Data Linking

AutoCAD makes it very easy to collaborate and share data between CAD and Excel, so link away!

More on Data Linking

About Linking a Table to External Data

About Linking Excel Spreadsheets

AutoCAD Excel Data Link (Video)

Creating A Data Link With An Excel Table

Keep Exploring

Want to learn more? Check out all the benefits of AutoCAD on our Features page; troubleshoot and get the details on previous software versions over on the Autodesk Knowledge Network; or take a look at all entries in our series, ExploringtheFeaturesand BenefitsofAutoCAD.

Try AutoCAD free for 15 days
The AutoCAD Blog is all about helping you get the most out of AutoCAD. It's also the best way for you to connect with the makers of AutoCAD. Subscribe to keep up with AutoCAD

______
icon-svg-close-thick

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

icon-svg-close-thick

THIRD PARTY SERVICES

Learn more about the Third-Party Services we use in each category, and how we use the data we collect from you online.

icon-svg-hide-thick

icon-svg-show-thick

Strictly necessary – required for our site to work and to provide services to you

Qualtrics
W
Akamai mPulse
W
Digital River
W
Dynatrace
W
Khoros
W
Launch Darkly
W
New Relic
W
Salesforce Live Agent
W
Wistia
W
Tealium
W
Upsellit
W
CJ Affiliates
W
Commission Factory
W
Google Analytics (Strictly Necessary)
W
Typepad Stats
W
Geo Targetly
W
SpeedCurve
W
Qualified
#

icon-svg-hide-thick

icon-svg-show-thick

Improve your experience – allows us to show you what is relevant to you

Google Optimize
W
ClickTale
W
OneSignal
W
Optimizely
W
Amplitude
W
Snowplow
W
UserVoice
W
Clearbit
#
YouTube
#

icon-svg-hide-thick

icon-svg-show-thick

Customize your advertising – permits us to offer targeted advertising to you

Adobe Analytics
W
Google Analytics (Web Analytics)
W
AdWords
W
Marketo
W
Doubleclick
W
HubSpot
W
Twitter
W
Facebook
W
LinkedIn
W
Yahoo! Japan
W
Naver
W
Quantcast
W
Call Tracking
W
Wunderkind
W
ADC Media
W
AgrantSEM
W
Bidtellect
W
Bing
W
G2Crowd
W
NMPI Display
W
VK
W
Adobe Target
W
Google Analytics (Advertising)
W
Trendkite
W
Hotjar
W
6 Sense
W
Terminus
W
StackAdapt
W
The Trade Desk
W
RollWorks
W

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.