AutoCAD to Excel - DataExtraction

Рет қаралды 107,881

6 жыл бұрын

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 5 жыл бұрын

Thanks for this video, very use full...

@sweatersweater1234 6 жыл бұрын

excellent video thank you

@fernandastaut6790 Жыл бұрын

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)...

@anilyadav-zi2yh 2 жыл бұрын

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

@Thobyias1 5 жыл бұрын

Thanks for ur video

@sumairbalouch9769 3 жыл бұрын

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.

@winstonfernandez1764 5 жыл бұрын

Tnx 👍🏿

@EveryThingChangeOneDay 5 жыл бұрын

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

@BIM-Infrastructure 5 жыл бұрын

You can download it from this video description.

@karthikeyankrishnan7689 4 жыл бұрын

Thank you brother.for this video.

@BIM-Infrastructure 4 жыл бұрын

My pleasure

@reshad4890 3 жыл бұрын

Thanks bro very useful

@SuperGurumoorthy 4 жыл бұрын

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 4 жыл бұрын

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

@dubaicouplevlogs8295 4 жыл бұрын

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

@BIM-Infrastructure 4 жыл бұрын

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

@josecarlosdemoraespires8032 3 жыл бұрын

Man, THANK TOU VERY MUCH!!!!!

@BIM-Infrastructure 3 жыл бұрын

Glad it helped!

@Praveenkumar-jb3wd 5 жыл бұрын

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 5 жыл бұрын

Praveen kumar yes you can export by using data extraction

@Praveenkumar-jb3wd 5 жыл бұрын

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

@nhusssin3713 3 жыл бұрын

Very helpful

@isazmy 5 жыл бұрын

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

@isazmy 5 жыл бұрын

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

@cubanito650403 4 жыл бұрын

thank you very much!!!!!!

@BIM-Infrastructure 4 жыл бұрын

You're welcome!

@ashutoshsharma3189 4 жыл бұрын

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

@BIM-Infrastructure 2 жыл бұрын

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

@Thobyias1 5 жыл бұрын

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

@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.

@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 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 5 жыл бұрын

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

@daglimilap4516 4 жыл бұрын

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

@BIM-Infrastructure 4 жыл бұрын

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

@daglimilap4516 4 жыл бұрын

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

@civillearnertamil4597 3 жыл бұрын

How to extract whole building wall coordinates polyline

@BIM-Infrastructure 3 жыл бұрын

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

@RahulKumar-pr3ye 2 жыл бұрын

Any alternative for this in AutoCAD LT

@BIM-Infrastructure 2 жыл бұрын

Not at moment

@parthasaradhivadduri3639 Жыл бұрын

Very importent video

@BIM-Infrastructure Жыл бұрын

Thank you

@targutanmongol3953 4 жыл бұрын

hello i need SS file ? acad plzz

@BIM-Infrastructure 4 жыл бұрын

targutan mongol could you please explain more clearly?

@jhumanandi7993 6 жыл бұрын

louder sound plzzzz

@BIM-Infrastructure 6 жыл бұрын

Jhuma Nandi I’ll consider this my next videos.

@b.london33 3 жыл бұрын

Do you teach online?

@BIM-Infrastructure 3 жыл бұрын

Yes

@mohamedansarithajudeen9867 4 жыл бұрын

Do you have WhatsApp Group?

@BIM-Infrastructure 4 жыл бұрын

mohamed ansari chat.whatsapp.com/Dpcg3kToUggEIf2EpQKsUV

@user-vd1fz6vi1m 5 ай бұрын

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

@Driftedfuel 5 жыл бұрын

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

@BIM-Infrastructure 5 жыл бұрын

Adam Majer ok sure