This week we are covering on how to batch change the attributes inside of AutoCAD blocks via Excel. This can be useful if you want to change a naming convention inside of the blocks (for example a numbering system) or to update information that was missing but is the same in all blocks.
Step By Step
1.Select the blocks that require the update in your drawing.
2.Use the ATTOUT command to export the attributes of the blocks.
3.Import that .txt file into Excel.
4.Modify the needed information.
5.Save as ‘tab delimited txt file’ – remember that hidden columns will not show up in this file.
6.In your drawing use the ATTIN command to import the changed .txt file.
7.Observe how the blocks get updated.
Should you have any comments or questions please don't hesitate to write to us - firstname.lastname@example.org