• Home
  • Training Books
  • Subscribe to Our Email Newsletter
  • About
    • Contributors
    • Feedback
    • Contact
    • Privacy policy
    • Cookie Policy

CADnotes

CAD Tutorials and Best Practices for professionals and students

  • Featured
  • AutoCAD
    • AutoLISP
  • Revit
    • Revit Architecture Basic
    • Revit MEP Basic Tutorial
  • Inventor
  • MicroStation
    • MicroStation Basic Tutorial
You are here: Home / AutoCAD / How to: Edit block attributes in Microsoft Excel

How to: Edit block attributes in Microsoft Excel

May 16, 2013 by Edwin Prakoso 19 Comments

In this Article...

  • Export the attributes data
  • Editing the attributes
  • Importing the values

Block attributes is a great way to store information. You can give blocks an ID or specification. Let’s see the example below.

This is a floor plan. The exhaust block has specification information. They all are stored in attributes.

object_specification

 

By having the information stored in block, we can extract the data later. Using data extraction, you can create schedule very quickly.

Now if you already have many blocks in AutoCAD drawing, editing the attributes can be tedious and prone to error. It would be easier to edit the attributes in table, isn’t it?

Export the attributes data

You can edit the attributes in Microsoft Excel. To do that, first you need to export the data from AutoCAD. You can use ATTOUT command.

Or you can access it in express tools tab, blocks panel.

export_import_attributes

ATTOUT and ATTIN are part of express tools command. If you don’t have it installed on your computer, then you can’t use it.

export attributes will ask you to define a file name (in .txt format) and select objects to export.

Editing the attributes

You can edit the file using notepad. But it may not be convenient. It would be more convenient to edit it in Microsoft Excel. And further more, you can use formula if the attribute should be calculated value.

You can open txt file in Excel and edit there.

Open Microsoft Excel, then open file. You can’t double click from Windows Explorer.

Change the file type to Text Files or All Files to see your exported file.

 

open_text_file

 

Click open. You will see import wizard. You can click Next to review the import settings. Or just click finish to accept default settings.

Usually default settings would be fine. Now you can edit the values.

DO NOT edit the handle column. It’s the block ID. If you change it, it might not imported properly.

editing_in_excel

 

After you finished, save the file. You may see warning because you are working in txt format. Just click yes, because we want to keep it in that format.

Importing the values

You might already guess the next step. Yes, you can import the value after finish editing.

You can use import attributes or ATTIN.

Command: ATTIN

Reading the input file… Done.
10 Block inserts modified.

This is very handy if you work with many blocks in your drawing. Editing block attributes in drawing would take a lot of time.

Now, what do you think you can do with it?

About Edwin Prakoso

I work as a Sr. Consultant in PT Cipta Satria Informatika. I've been using AutoCAD since R14 and Revit since Revit Building 9. I occasionally write for AUGIWorld magazine and I am also active in Autodesk discussion forum. I'm a member of Autodesk Expert Elite, an appreciation for individuals who give contributions to the Autodesk community.
Connect with me on twitter or LinkedIn.

Filed Under: AutoCAD Tagged With: ATTIN, ATTOUT, attributes, autocad tips, block

0 0 votes
Article Rating
Subscribe
Login
Notify of
guest

guest

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

19 Comments
Inline Feedbacks
View all comments
Symoin
Symoin
4 years ago

Is there any way of getting the insertion point of the blocks(main block and not the nested block) along with the attributes?

0
Reply
kendra
kendra
8 years ago

Luar biasa , sy banyak membaca tulisan anda , itsgreates , tapi sayang kenapa tidak menulis dalam bahasa indonesia , untuk bangsa indonesia , itu juga kalo niat.
sorry ya saya salut angkat topi untuk anda , tapi tolong permudah kami.
tq

0
Reply
Edwin Prakoso
Edwin Prakoso
Author
Reply to  kendra
8 years ago

Kendra,

Banyak blog, website dan buku yang sudah berbahasa Indonesia. Anda bisa cari di toko buku terdekat atau beli di toko online.
Atau lebih baik cobalah biasakan membaca tulisan berbahasa Inggris, karena anda dapat belajar dari lebih banyak sumber.
Alasan saya menulis dalam bahasa Inggris adalah agar dapat membantu lebih banyak orang lagi, tidak hanya untuk orang Indonesia.

0
Reply
Peter
Peter
9 years ago

using ATTIN results in extra “” at the beginning and end of the attribute
like this 6″-LP3344 in Excel becomes “6”-LP3344″ in AutoCAD.

Any solutions?

0
Reply
Edwin Prakoso
Edwin Prakoso
Author
Reply to  Peter
9 years ago

There are some macros available if you search on internet. But the easiest way is to select all cells, copy to clipboard. Then open notepad and paste there. Save the txt file and use it instead.

0
Reply
Vicente
Vicente
9 years ago

Very interesting and useful tip Edwin. Thank you …

0
Reply
Jude
Jude
11 years ago

Hi Edwin,

Great info. Thank you.

Could you guide me in this issue which I am currently struggling with please.

I’ve created an attribute block of a Electronics hardware and there is cable connects to it which labelled as V1000 (example). Hoe can i extract the attribute along with the cable label into the excel please?

Thank you.
Jude

0
Reply
harish kumar
harish kumar
11 years ago

Hi, thanks for this. Works great for single sheets ,if it has to extract the data on multiple sheets how can we get the information

0
Reply
kiva
kiva
11 years ago

Hey everyone…. this is a great tool but im having some issues with it.

I can't figure out how it defines the handle of the attribute in the drawing.

I'm using one block about 200 times in my drawing and that block has 7 defined attributes.

I want to make changes to the attributes in that block in excel file and only in excel file and then import it back to my drawing.

What I can't figure out is if i have that one block with its default attributes 200 times in my drawing, how can I know which is which in excel file.

I noticed that if i put it in an order along the x coordinate then i can sort it in order. But if i forget to place it somewhere and i correct that, it completely messes up my system and i dont know what is what anymore.

Anybody have an idea?

0
Reply
Edwin Prakoso
Edwin Prakoso
Author
Reply to  kiva
11 years ago

Kiva,

You need to add an attribute to let you know which attribute you need to change. You can add an ID attribute.

0
Reply
kiva
kiva
Reply to  Edwin Prakoso
11 years ago

Thanks for the reply Edwin.

I need to change them all. I figured it out in a roundabout way, where i number the blocks (one of the attributes gets numbered) then extract the attribute information to excel, sort it how i need it, change the attribute values then import it back.

I hoped there could be a faster/simpler way where i could somehow have the blocks numbered automatically as i put them in the drawing (found a LISP for that now).

For what I need it this is okay for now.

0
Reply
Symoin
Symoin
Reply to  kiva
4 years ago

Could you share the lisp – please. ??

0
Reply
Vlatko
Vlatko
Reply to  kiva
8 years ago

Block selection order by “picking” results in wished order in excel. What block you pick second, in excel it’s data will be in second place.

0
Reply
Phuongduc
Phuongduc
11 years ago

Hello Edwin Prakoso!

Thanks for shared.

I can’t used ATTOUT and ATTIN with Autocad 2013 on Mac OS X

http://farm4.staticflickr.com/3665/9341249888_325…

Please answer me, thanks you very much!.

0
Reply
Phuongduc
Phuongduc
11 years ago

Hello Edwin Prakoso!

Thanks for shared.

I can't used ATTOUT and ATTIN with Autocad 2013 on Mac OS X

http://www.flickr.com/photos/76595808@N07/9341249…

Please answer me, thanks you very much!.

0
Reply
Edwin Prakoso
Edwin Prakoso
Author
Reply to  Phuongduc
11 years ago

Hi Phoungduc,

AutoCAD for Mac doesn't have express tools. ATTOUT and ATTIN are part of express tools, that's why you don't have them.

0
Reply
Phuongduc
Phuongduc
Reply to  Edwin Prakoso
11 years ago

Hi Edwin Prakoso!

Thanks for your answer,

But i'm working on my Mac. So, do you have another tools like "ATTOUT, ATTIN" in AutoCad for Mac?

Thank you.

0
Reply
Edwin Prakoso
Edwin Prakoso
Author
Reply to  Phuongduc
11 years ago

No, there is no ATTIN and ATTOUT in AutoCAD for Mac.

0
Reply
Johncoqs
Johncoqs
12 years ago

Like

0
Reply
wpdiscuz   wpDiscuz

Featured

What’s New in Revit 2021 – part 1: General Enhancements

Revit 2021 has been released! See what’s new in part 1. More to come!

Recent Articles

  • Autodesk Construction Cloud Activity Log
  • Exporting AutoCAD Plant 3D Model to Navisworks
  • Autodesk Data Connector for Power BI is Now Available

Advertisement

New on CADnotes

  • Autodesk Construction Cloud Activity Log
  • Exporting AutoCAD Plant 3D Model to Navisworks
  • Autodesk Data Connector for Power BI is Now Available
  • Autodesk Forma Design Contest
  • Revit 2025: Toposolid Enhancements

Meet the Authors

avatar for
avatar for
avatar for
avatar for
avatar for
avatar for

Get Connected

CADnotes on FacebookCADnotes on InstagramCADnotes on TwitterCADnotes on YouTube

© 2009 – 2025 CADnotes · Feedback · Privacy Policy · Become an affiliate

wpDiscuz