Updating AutoCAD Block Attributes using Microsoft Excel

Block Attributes play a critical role in many AutoCAD drawings, yet updating more than a couple attributes at a time is as tedious as it is time-consuming. In this video, Donnie "The CAD Geek" Gladfelter shares a simple tip for batch updating Block Attributes using Microsoft Excel and a couple lesser known Express Tool commands (ATTOUT, and ATTIN).

----------

[connorfitzgerald]

You're an excellent teacher - efficient, to the point and highly enthusiastic. Your workflow is also pleasant to observe. Subscirbed and look forward to browsing your other videos. Thank you!

[nefertiri]

thank you sooo much!!! I had to do it one by one but now I know that Icould do it in just seconds!! Thank yousooo much!! you're amazing!

[MrMosanu]

Thank You, very professional tool, that will save me time!

[fabianaldama]

Thank you Donnie, grettings from Mexico

[rahulgautam]

Awsome you just saved my half hour for every sheet

[MihdiCaballero]

This is what I was looking for!! Thank you!

[willynakada]

OMG, what a awesome tip. Thank you very much. It made my day

[cadknowsbyprasart]

WOW! Very Very Very Supper Trick, Thank a lot

[nscantling]

Oh my gosh, to think all of the Electrical Schematics landmarks I've updated in the past because a page needed added at the beginning. This would have been so helpful to know.

[muhamadrifaiarif]

Hello Master, thank you for sharing this tips.
I have a big question in my head regarding make field/text in autocad, but I can update them only through Excel (data linked). How do I do this? Would you mind to show us the way for this? many thanks to you.

[Pensa-ho]

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?

[ashishful]

I am curious though if we can import block attribute values from excel into Autocad for multiple field??

[AI-vmnt]

What kind of block is that? could you please tell, how to make that blocks you had(with numbers increasing)? (if you refer me to any video it would be also great). Thanks!

[Lowend]

so I did as you said, I even went back and verified that I saved as a text tab delimited before I issued the attin...I get " quotes " around the data that I import. Can you help with this?

[treiter]

I am wondering, can you do the same thing with blocks? I.E. a square, can you use excel to input the size of the square and get AutoCAD to update that size?

[DHRUVPATEL-hosk]

How to Create Similer Block or Attributes for all rooms???

Can you help me??


I need to do same things.

[dwaynecadguy]

Can this be done across two cad drawings? My cad drawing 1 is a floor plan with block attributes. My cad drawing 2 is a schemetic drawing riser of the blocks in the floor plan. When i make a change to a few blocks in the floor plan, i need the same changes done in drawing 2

[khucxua]

I want to do this with many sheets in Excel and save the Excel file for future use. Is it OK? Thanks advance!

[johnnyboy]

Hey @the CAD Geek - I was wondering if there was a way to incorporate excell with attribute blocks across multiple files/layouts. I am trying to updated my attributes which note revisions/issue dates. Thanks in advance.

[Azm]

Is there a way to update block attributes on multiple dwg files with this excel trick?