Updating AutoCAD Block Attributes using Microsoft Excel

Block Attributes are an integral component of nearly every AutoCAD-based project I’ve worked on. Beyond the ubiquitous title block, Block Attributes are commonly used for Room Tags, to display calculations, and more. Whilst it isn’t too difficult to update a couple of Block Attributes, when the blocks to update ventures beyond that – the task quickly becomes as tedious as it is time-consuming.

I’ve long wished AutoCAD had a command that would let you link a block to something like an Excel spreadsheet. Although that wish has never been granted, the next best thing exists in the form of AutoCAD’s Express Tools. Two of my favorite Express Tool commands are ATTIN and ATTOUT. Put simply, the commands will export Block Attribute values to a Tab-Delimited text file (ATTOUT), and update Block Attribute values from a Tab-Delimited text file (ATTIN). In the video above I demonstrate how to use these commands in tandem with Microsoft Excel to quickly renumber the room tags in a floor plan.

Tips for Updating Attributes with Excel

Whislt the blocks can be anything you wish, there are a few tricks to using this method in production:

  1. Blocks are updated based on their Handle ID: Every object (including blocks) are assigned a unique Handle ID. No two objects in an AutoCAD drawing will have the same Handle ID, and the ID itself is designed to function as a unique identifier in the DWG database. This means you can move a block anywhere you wish in the drawing (even a different Layout tab), but you cannot erase the block. Erasing the block will change the Handle ID for the object, and thus break this method.
  2. You may combine multiple TXT files: The ATTOUT command will generate a separate TXT file each time you run the command. Especially if you’re updating the same block (not to be confused with block insertion), you can combine multiple TXT files into a single TXT file if you wish. Using the example in the video, you may export the Room Tag block attribute values for each floor in your design – thus resulting in a TXT file for each floor. You can combine these TXT files into a single TXT file to simplify things a bit.
  3. Save as Tab Delimited Text File in Microsoft Excel: I will typically create an Excel spreadsheet that performs various calculations. When exporting your data from Excel, be sure to select tab delimited as the file type.
Donnie Gladfelter
Donnie Gladfelter

Donnie is author of the book and Autodesk Official Press, AutoCAD and AutoCAD LT: No Experience Required, a columnist for AUGIWorld Magazine, Autodesk University speaker, and former member of the AUGI Board of Directors.

9 Comments

  1. Hello,
    It looks like a great tool, just what I’m after. However when I try to modify the data and import the attributes the following messages appear:
    ‘One or more records of data could not be matched to block inserts within this drawing.
    Do you want to select the block inserts and assign this data interactively?’
    I can modify the blocks one by one but not do it in batch.
    Any ideas of how I could overcome this?

    • the same thing here, did you get it solved somehow? please let me know if you did, I have the same issue and pulling my hair out too!!! please help

  2. Hi
    I followed all steps above and in even created new blocks with attributes from blank drawing.
    when I import from excel, I get the following message:
    “One or more records of data could not be matched to block inserts within this drawing”.
    ACADE 2018 & Excel 2016
    I’m pulling my hair out already and I would really appreciate any advice.
    Thanks

  3. I followed the steps instructed in the video. But while import attribute, i get the values in ” “. While is there in the excel file or autocad before import

    • The Export Attributes command creates a tab delimited text file. You’ll need to import it into Excel as that type of text file. Likewise, you need to be sure to export to a tab delimited text file from Excel. No other format, including the more common comma separated former, will work.

      • I saved it as a tab delimited text file, and I think I’m having the same issue. When I save the spreadsheet as a tab delimited .txt, it puts quotation marks around certain values. Then, when importing the attributes into autocad, it keeps those new quotation marks. Any idea how I can prevent this from happening?

  4. Very nice tip, I will definitely put this to work when the boss finally upgrades us to a full version of AutoCad. I sure do miss my express tools when using LT.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from The CAD Geek

Subscribe now to keep reading and get access to the full archive.

Continue Reading

%d bloggers like this: