Combining AutoCAD Data Extraction Tables with Excel Tables

[@paulobrito2009]

Thank you so much for the hints. I already created my own standards based upon your video and it´s still working very well.

[@jthrilla84]

Thanks man! this is exactly what ive been looking for! I really didnt catch it all in a class I was taking last semester but this video explained it clearly!

[@danpaano]

Thanks for this video. Can you share how to properly add a formula column to multiply the cost column from the external excel datalink with the count column. I keep getting an 'invalid data' error when I try it. Thanks in advance!

[@sreedharvp5925]

very nice I have worked this many times but this video explained very clearly thanks

[@jonnasdrade]

Nice Video. Question: how can I do If in the same example I need another extra column with a total price of all units?

[@saiavinashrevanur8359]

After adding another multi-leader no.2, does the excel sheet also get updated?

[@SmartcadSoftwareSolutions]

wow
this is what I was searching
thank you so much..

[@mitsha01]

I loved you video, explains data extraction very well... my question is can I add blocks to the data extraction table?... it will help me to show the block, the description of the block, the count, and extracted attributes of the block

[@alirashad8260]

hey man ,, thanks for helping
keep uploading ur amazing videos

[@shrinathingale]

Hey I need to plot excel file to cad as a drawing can we do it if yes then show me how.

[@lindawang314]

thank you so much!

[@elvanovich]

Great! But what happens with the excel sheet? Can you have a "count" column that reloads as well so it is linked both ways?

[@moincad]

How to link cad attribute tag with excel same tag no with having multiple sub items. For MTO.
Supposed cad have 1 no id.
But in excel 1 tag having multiple sub items i need to take out all mto with it

[@wojtek_sanitarnik]

What about double or triple multileader? Is it will be count as one?

[@hernandocimadevilla5839]

Is there a way to use this but with also layers? I need to create the table easily but with layers because I need to show somethings sometimes and I just turn on/off the layers to see them or not in Autocad, but how can I link the autocad layers with Excel? Do you know how can do it? or Another way to create an Autocad Table with specific views depending of layers or options to only see in the table the items that I just need to see?

[@argenism6]

Very cool, thank you.

[@hernandocimadevilla5839]

How can I avoid the count number if I have layers for some of the blocks? Thanks.

[@brandoneulberg1324]

Can you do this with parts and blocks as well?

[@arosionut]

Hello, did u know how connect xcel with autocad ??
I mean, when u click in autocad a text, to make link between autocad and excel data base ?

[@sgs3131]

thank you very good demo

[@moincad]

IF I HAVE MULTPLE BLOCKS OF DIFFRENT NAMES ? i tried but not working

[@inesmarques1892]

hey!I'm having problems with this...I create a new excel data link as you explain, but then in the next step when I browse for it I can't find it. Can you help?thanks a lot

[@shrinathingale]

Take a little complex design as example if yes

[@rdsamsterdam6430]

This looks awsome , I tried it myself and all went well.....until I "link External Data"....
I select the ID columns drawing & External ; after "Check Match" I get a error-message...
"The data column in the external data does not contain unique values"
Tried eveything but somehow I can't solve this. I bet it is something very simple. Any suggestions perhaps ? Thanks !

[@reidjosh]

Is there a way to not add the id if the count is 0?

[@mukeshsahani6452]

can you do this vice-versa? ... I mean if i update in excel will it be update in drawing ???

[@danstevens9245]

Yes, use the data link command to import your excel table.

[@2002usama]

thanks

[@Mostafa20268]

Thanks

[@58ahmed]

ty vm :)

[@bizzoalbert]

ta dando ruim!!!!!!

[@1carlento]

long and complicated :(