AutoCAD to Excel - DataExtraction

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 มี.ค. 2018
  • In this video, I'm demonstrating how to export AutoCAD entities information to MsExcel or else how to show as a table in the same drawing by using most powerful AutoCAD command DATAEXTRACTION.
    you can download exercise files from the links below.
    goo.gl/DCR3Ld
    goo.gl/oQygxf
    Automated AutoCAD Sheet Layout Creation Program: • AutoCAD Sheet Layouts ...
    Please Subscribe this channel for more useful tips and tricks.
    Website: www.BIM-Infra.net

ความคิดเห็น • 55

  • @jkkumaran9310
    @jkkumaran9310 5 ปีที่แล้ว +1

    Thanks for this video, very use full...

  • @sweatersweater1234
    @sweatersweater1234 6 ปีที่แล้ว +1

    excellent video thank you

  • @Thobyias1
    @Thobyias1 5 ปีที่แล้ว +1

    Thanks for ur video

  • @winstonfernandez1764
    @winstonfernandez1764 5 ปีที่แล้ว +1

    Tnx 👍🏿

  • @karthikeyankrishnan7689
    @karthikeyankrishnan7689 4 ปีที่แล้ว +1

    Thank you brother.for this video.

  • @reshad4890
    @reshad4890 3 ปีที่แล้ว +1

    Thanks bro very useful

  • @josecarlosdemoraespires8032
    @josecarlosdemoraespires8032 3 ปีที่แล้ว +1

    Man, THANK TOU VERY MUCH!!!!!

  • @cubanito650403
    @cubanito650403 4 ปีที่แล้ว +1

    thank you very much!!!!!!

  • @nhusssin3713
    @nhusssin3713 3 ปีที่แล้ว +1

    Very helpful

  • @anilyadav-zi2yh
    @anilyadav-zi2yh 2 ปีที่แล้ว +1

    Hi sir
    Can you upload the video for attributes command bcs i want to creat multiple block for coordinates

  • @dubaicouplevlogs8295
    @dubaicouplevlogs8295 4 ปีที่แล้ว +1

    thanks for the video... one question... if you change the points in cad will it change in the excel automatically ?

    • @BIM-Infrastructure
      @BIM-Infrastructure  4 ปีที่แล้ว

      There is no live connection between excel and Cad. If there is any changes needs to export it again.

  • @EveryThingChangeOneDay
    @EveryThingChangeOneDay 5 ปีที่แล้ว +1

    can you give me the example for the poly line drawing same as you given in above video?

    • @BIM-Infrastructure
      @BIM-Infrastructure  5 ปีที่แล้ว

      You can download it from this video description.

  • @sumairbalouch9769
    @sumairbalouch9769 3 ปีที่แล้ว +1

    Hi Buddy , hope you are well. could you please make a short video how to put points/ coordinates from cad to excel only one click , i think there is software call cad2excle but i am not sure which one is. one of my friend he was doing in autocade he was just clicking points and coordinates are automatically saved in excel . no list formula.

  • @SuperGurumoorthy
    @SuperGurumoorthy 4 ปีที่แล้ว +1

    is this possible to import the same data by changing the data in the excel and import into AutoCAD in multiple sheets?layouts

    • @BIM-Infrastructure
      @BIM-Infrastructure  4 ปีที่แล้ว

      Yes, you can copy from Excel and paste into Layouts, it'll come as an OLE object.

  • @parthasaradhivadduri3639
    @parthasaradhivadduri3639 ปีที่แล้ว +1

    Very importent video

  • @Praveenkumar-jb3wd
    @Praveenkumar-jb3wd 5 ปีที่แล้ว +1

    Bro I need one help.. I have cad drawing can we extract the areas and other datas from autocad file to xls or csv format? plsguys help me

    • @BIM-Infrastructure
      @BIM-Infrastructure  5 ปีที่แล้ว

      Praveen kumar yes you can export by using data extraction

    • @Praveenkumar-jb3wd
      @Praveenkumar-jb3wd 5 ปีที่แล้ว

      @@BIM-Infrastructure Thanks, Can you send me any video about that sir.

  • @fernandastaut6790
    @fernandastaut6790 ปีที่แล้ว +1

    I have an issue, can anyone help me out? This is the situation: I've changed (manually) a cell of my table (generated with Data Extraction). After that, I updated the drawing by adding a block that, when the data extraction updates too, my table adds a line befone the cell I've changed before. The problem is that the cell I've changed stays in the wrong line - it doesn't move to the line below as it was supposed to (since a line was added before)...

  • @Thobyias1
    @Thobyias1 5 ปีที่แล้ว +2

    Can you post a video of electrical lights extract separate from the cad drawing

    • @BIM-Infrastructure
      @BIM-Infrastructure  5 ปีที่แล้ว

      Dear Thoby, You can export Lights blocks name and it's counts to excel by using data extraction. If you can send your drawing to "saifudheen@me.com" I could make a specific video for that.

  • @civillearnertamil4597
    @civillearnertamil4597 3 ปีที่แล้ว +1

    How to extract whole building wall coordinates polyline

    • @BIM-Infrastructure
      @BIM-Infrastructure  3 ปีที่แล้ว

      Padmanaban Nagarajan you can use any lisp program for that or else Explode pline into Line then use data extraction.

  • @isazmy
    @isazmy 5 ปีที่แล้ว +1

    i had try, but after open by excel, the coding is not working follow column/table

    • @isazmy
      @isazmy 5 ปีที่แล้ว +1

      @@adityachristiandi843 thanks btw, solved after few minutes i commented here by another ways.

  • @ashutoshsharma3189
    @ashutoshsharma3189 4 ปีที่แล้ว +1

    I have Autocad LT 2016. This command "DX" doesn't work. please guide for alternate way.

    • @BIM-Infrastructure
      @BIM-Infrastructure  2 ปีที่แล้ว

      LT won't support advance comments, alternative is you should upgrade to full version.

  • @muhammadsofian8000
    @muhammadsofian8000 5 ปีที่แล้ว

    is this only available for autocad that you use..?i can try use for autocad 2007 but,your file can't be open file because i'm use autocad 2007...

    • @BIM-Infrastructure
      @BIM-Infrastructure  5 ปีที่แล้ว

      Data extraction command will work Autocad 2007 and later versions. The file I saved in earlier version so it cannot open 2007. I recommend you to update your Autocad.

    • @muhammadsofian8000
      @muhammadsofian8000 5 ปีที่แล้ว +1

      @@BIM-Infrastructure ow yeah,i think do...and now I instal a new version autocad...I hope it can go as expected

  • @daglimilap4516
    @daglimilap4516 4 ปีที่แล้ว +1

    what is the meaning of start angle and Total angle while exporting arc data to excel ??

    • @BIM-Infrastructure
      @BIM-Infrastructure  4 ปีที่แล้ว

      dagli milap those are the geometric properties of the Arc. Also you can find this in arc properties.

    • @daglimilap4516
      @daglimilap4516 4 ปีที่แล้ว

      Can I identify the curve start point, end point from this data??

  • @targutanmongol3953
    @targutanmongol3953 4 ปีที่แล้ว +1

    hello i need SS file ? acad plzz

    • @BIM-Infrastructure
      @BIM-Infrastructure  4 ปีที่แล้ว

      targutan mongol could you please explain more clearly?

  • @RahulKumar-pr3ye
    @RahulKumar-pr3ye 2 ปีที่แล้ว +1

    Any alternative for this in AutoCAD LT

  • @jhumanandi7993
    @jhumanandi7993 6 ปีที่แล้ว +1

    louder sound plzzzz

    • @BIM-Infrastructure
      @BIM-Infrastructure  6 ปีที่แล้ว

      Jhuma Nandi I’ll consider this my next videos.

  • @b.london33
    @b.london33 3 ปีที่แล้ว

    Do you teach online?

  • @mohamedansarithajudeen9867
    @mohamedansarithajudeen9867 4 ปีที่แล้ว +1

    Do you have WhatsApp Group?

    • @BIM-Infrastructure
      @BIM-Infrastructure  4 ปีที่แล้ว

      mohamed ansari chat.whatsapp.com/Dpcg3kToUggEIf2EpQKsUV

  • @user-vd1fz6vi1m
    @user-vd1fz6vi1m 5 หลายเดือนก่อน

    THE DC AND SS FILES CAN NO LONGER BE DOWNLOADED. THANK YOU

  • @Driftedfuel
    @Driftedfuel 5 ปีที่แล้ว +3

    slowww down. You did 50 different things in the last 5 seconds. Explain what you are doing next time.