AutoCAD How To: Edit Block Attributes in Excel: Import/Export Attributes – 2 Minute Tuesday

Brandon

Hey Everybody

Brandon here and I’m back with another super helpful 2 Minute Tip!

This week I wanted to share a really cool tool in Autocad, the Export, and Import Attribute tools. By using these commands we can quickly and easily export any or all of the block attributes in a drawing, saving them out to a .txt file that can easily be edited in programs like Excel.

The greatest part is that once all of the changes have been made in the excel file, simply saving it and then using the Import Attributes tool will automatically update the attribute of any block that has changed! This can be a huge time saver, especially when working with drawings that have a large number of blocks in them.

Another great use for the exported .txt file is to use the data for material take-offs, quantity checks or simply record keeping. Having an itemized spreadsheet of every block in the drawing is invaluable and certain to save you time.

Check out the video below for a complete walkthrough:

 

That’s all for today’s quick Autocad Tip, I hope you all were able to take something away from it and able to add a new tool to your CAD toolbox!

Be sure to subscribe and follow on Twitter @cadintentions to keep up to date and be the first to get updates on the newest videos, posts, and downloads.

 As always, thank you so much for reading and watching, I am super excited to be back and posting regularly on the blog and hope you all will follow along.

Cheers and happy drafting!

 

PS: don’t forget to check out the link to the Productivity Webinar for more details and to take advantage of the blog reader’s deal! Get 20% off right now: https://gumroad.com/l/oPLLa/CIBLOG1

PPS. Thank you again for visiting and don’t forget to subscribe to the newsletter to keep up to date on new CAD news, tutorials and tricks: Subscribe here

The following two tabs change content below.
My Twitter profileMy Facebook profileMy YouTube channel

Brandon

Brandon is a Civil Designer, Aspiring Blogger/Creator, Husband, Father to two Amazing Kids and Tech Aficionado from a small town in Canada. He has been obsessed with design and technology since he can remember and working as a Civil Designer for nearly as long. Brandon’s blog and Youtube channel, CADIntentions.com has been his outlet and excuse for keeping up with new tech and trends in the CAD design world for the last 10 years growing to more than 60,000 subscribers and over 15,000,000 views, while also being the source of many great friendships and unique opportunities. If you would like to Sponsor CAD Intentions or Work together in some way, Please visit my About Page and send me an email: http://cadintentions.com/about-me/

Related posts:

  1. AutoCAD Tutorial: Search & Group Layers – How to Find and Organize Your Layers Quickly – 2 Minute Tuesday
  2. Round-Up: 2 Minute Tuesday x Tuesday Tip Videos and Articles!
  3. AutoCAD: How to Open .BAK Files and Using Them – 2 Minute Tuesday
  4. AutoCAD Tutorial – How to Link a North Arrow to a Viewport Dynamically – 2 Minute Tuesday