Categories

AutoCAD 2013 & AutoCAD LT 2013 Bible

The most comprehensive AutoCAD book around!

AutoCAD 2012 Bible

Insert data from an Excel worksheet

A reader asked how he could display data that was linked to an Excel spreadsheet. It might be easier to update the data in the spreadsheet or you might be keeping the data there anyway for other purposes. For whatever the reason, it can be very efficient to create a data link and display the data in a drawing.

Here you see a table with a revision history.

autocad-tips-link-to-excel-data-1

You can do this in a table fairly easily. Here are the steps. Below is a video tutorial of the same procedure.

  1. On the Home tab, in the Annotation panel, click Table.
  2. In the Insert Table dialog box, choose the From a Data Link option in the Insert Options section.
  3. Click the Launch the Data Link Manager Dialog button to the right.
  4. Click Create a New Excel Data Link option.
  5. Give the data link a name and click OK.
  6. Wait a couple of seconds until the New Excel Data Link dialog box opens. At the top, click the Browse button to browse for a file. Navigate to the Excel file and click Open.
  7. Back in the New Excel Data Link dialog box, choose which sheet you want to link to and also choose Link Entire Sheet, Link to a Named Range, or Link to Range. If you choose the latter, enter the range in the format A1::B12. As long as the Preview checkbox is checked, you’ll see a simple preview at the bottom.
  8. Click OK 3 times to return to your drawing.
  9. At the Specify insertion point: prompt, pick a point.

You can then select the table and make adjustments or format it.

Watch the video to see how these steps work. In the video, I also show you what happens when you change the data in Excel.

 

4 comments to Insert data from an Excel worksheet

  • John Kerr

    I liked the table process, but using the OLE seems a fewer number of steps (for me), unless . ., and I really should just try it, but, is there a case where for example the table in excel is updated the night before by the night shift (for example), and when I open the AC file the next day, the data (in the dwg file) automatically updates upon opening? I think this would be the real bonus.

  • Gabriel852

    Really good news for us. If anybody want to open AC file easily they must need to follow this rules.Because its a great tips for a excel sheet formation. Now a day it use everywhere.I got some more important tips for learning this site http://www.itmashable.com/2012/09/promote-your-business-with-3d.html

  • Eileen Irwin

    Hi Ellen. I had emailed you an issue I was having here at work concerning autocad and you had suggested I post it on your blog as a comment. So here it is. We do drawings in autocad and we do up the table of contents in Excel in a spreadsheet using tables and then export it into Autocad. We were having some spacing problems in our spreadsheet and so we fixed them up and fixed the spacing the way we wanted it but when we export those changes to autocad, they aren’t reflecting in autocad.

    We did a test spreadsheet in excel. We moved the data within a table we created over by using 3 different methods. We moved the text over simply by using the space bar, we used the increase indent icon on the home taskbar and then we used ctrl+alt+tab which is another command to move text over from the left margin. Then we tried exporting those three methods into autocad and the only method that was reflected was when we used the space bar. Using the increase indent icon and using ctrl+alt+tab didn’t work between excel and autocad. We don’t want to have to manually move every line over in a table by using the space bar, that takes too much time. Do you know how we can move everything in our table over at the same time using either the increase indent icon on the home taskbar or by using the ctrl+alt+tab and then have it be reflected in autocad when we export the spreadsheet over?

    Thank you for your time and happy new year.

  • Karel Groesbeek

    Thank you, I found this quite helpful.
    I always just copy the excell spreadsheet straight over but as soon as you print a pdf from Layout in AutoCAD the Excel file seems to dissapear.
    Using your method the data always stays current and you don’t loose it when printing a PDF from Layout space.

    Thanks

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>