[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_cta admin_label=”Call To Action” title=”Post Updated” button_url=”http://thecadgeek.com/blog/2016/01/excel-block-attributes/” url_new_window=”off” button_text=”Read the Updated Post” use_background_color=”on” background_color=”#00a8ff” background_layout=”light” text_orientation=”left” header_font_size=”26″ body_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid” custom_button=”off” button_text_size=”20″ button_border_width=”2″ button_border_radius=”3″ button_letter_spacing=”0″ button_use_icon=”default” button_icon_placement=”right” button_on_hover=”on” button_border_radius_hover=”3″ button_letter_spacing_hover=”0″]
We’ve authored an updated version of this post using AutoCAD 2016. The updated post includes a video demonstration of the process discussed in this post.
My post titled “Quickly Link Excel Tables to AutoCAD” from last August continues to be one of my most popular posts to date. As a result I have received a number of e-mails from readers such as you asking about other ways to link Excel data with AutoCAD data. A popular variation has been asking about a way in which you can link Excel data with AutoCAD Block Attributes. Since Block Attributes function much like a database form, it seems logical that we should be able to use Excel as a data source for those Block Attributes. Sadly there is not a true “Link Block to Excel” command (to my knowledge) within AutoCAD. That however does not mean there’s no workaround to the situation!
I originally developed this workaround back in the days before Sheet Set Manager. At the time I was working on a two-part project, each of which consisted of more than 100 sheets. The kicker was that we had to include the station range of the alignment being illustrated on each plan and profile sheet. Of course, as luck would have it, our road alignments were constantly changing in the early phases of design, consequently making our sheet titles incorrect. I thought to myself – there has to be a better way!
After a little digging around I found two Express Tool Commands which caught my eye; ATTIN and ATTOUT. Using these commands in conjunction with one another I was able to export a text file containing my attribute values, bring that text file into Excel to change and manage values, finally importing that text file back into AutoCAD. Admittedly the process is a little rough around the edges, but at the end of the day – it works!