Updating AutoCAD Block Attributes using Microsoft Excel

No video

Updating AutoCAD Block Attributes using Microsoft Excel

Рет қаралды 98,060

Күн бұрын

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).
----------
Subscribe to AutoCAD LT: thecadgeek.com...
Subscribe to AutoCAD: thecadgeek.com...
For the latest AutoCAD Tips, Tricks, industry insights, and more visit thecadgeek.com

Пікірлер: 49

@PK-wh7cc 2 ай бұрын

My solution is here, thanks.

@rahulgautam1893 6 жыл бұрын

Awsome you just saved my half hour for every sheet

@fabianaldama7395 4 жыл бұрын

Thank you Donnie, grettings from Mexico

@connorfitzgerald640 7 жыл бұрын

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!

@MihdiCaballero 2 жыл бұрын

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

@nscantling 5 жыл бұрын

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.

@willynakada7046 3 жыл бұрын

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

@georgekhabaze6619 3 жыл бұрын

thank you..... that is such a time saver

@nefertiri1106 7 жыл бұрын

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!

@thecadgeek 7 жыл бұрын

Glad the video was helpful.

@Unknown.Userrr Жыл бұрын

Very helpful video😊

@MrMosanu 7 жыл бұрын

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

@shaunwright3719 3 жыл бұрын

Thank you!!

@Lowend3550 Жыл бұрын

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?

@AI-vm7nt 7 жыл бұрын

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!

@rt69gaming44 3 жыл бұрын

Can we mark what we've changed into different color?

@muhamadrifaiarif4389 4 жыл бұрын

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.

@khucxua894 3 жыл бұрын

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

@ashish13ful 4 жыл бұрын

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

@achelini1 5 жыл бұрын

is there a way to associate a block to a excel file or excel list within the drawing that could act as a bill of materials as I draw? I hope that makes sense. Is there a video or tutorial I can be directed to?

@thecadgeek 5 жыл бұрын

Hi Joshua. I think my video on Combining Excel and Data Extraction Tables in AutoCAD might help you with the scenario you outlined. kzfaq.info/get/bejne/h7J3ott5ss2ciqs.html

@Az1m10 2 жыл бұрын

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

@marioalejandrovilla8831 7 жыл бұрын

Thank you so much. It was amazing.

@treiter86 7 жыл бұрын

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?

@cad2knowsbyprasart783 8 жыл бұрын

WOW! Very Very Very Supper Trick , Thank a lot

@munaaljonaidy571 3 жыл бұрын

LOVE LOVE LOVE

@Pensa-ho 4 жыл бұрын

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?

@fuckyknet 5 жыл бұрын

hi how to mirror a block but the text not mirror?

@SangNguyen-bg6oi 8 жыл бұрын

great video! Many thanks.

@NgocNguyen-cw1in 8 жыл бұрын

ok baby. very good

@syatirmuhammad1518 8 жыл бұрын

super video, thanks a lot

@gaminxden11 4 жыл бұрын

thanks.

@DHRUVPATEL-ho4sk 5 жыл бұрын

How to Create Similer Block or Attributes for all rooms??? Can you help me?? I need to do same things.

@johnnyboy606 2 жыл бұрын

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.

@NodesAutomations Жыл бұрын

You have to write custom code to do this using VBA or C#

@carlinoplissken4521 6 жыл бұрын

Great! Thx a lot!

@forgeservicos7637 Жыл бұрын

Buddy, I tried to find your email but I couldn't find it. Can you help me? I intend to make a drawing in autocad and replace the value of the dimensions/dimensions of the drawing by searching in excel. Can you help me?

@maheshpatil2017 5 жыл бұрын

how to link cad drawing to excel so that changes in cad drawing will change the drawing in excel sheet where we have copied the views.

@thecadgeek 5 жыл бұрын

While there are some third-party tools that promise such functionality, AutoCAD does not natively have the ability to write to Excel - only read from it. This video where we complete manual export/import steps is the closest we get to AutoCAD writing to Excel.

@dwaynecadguy1897 7 жыл бұрын

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

@Tom_Hadler 4 жыл бұрын

dwayne cad guy Just xref one drawing into the other