AutoCAD How To Link Excel Tables to AutoCAD - Super Easy & Dynamic

AutoCAD How To Link Excel Tables to AutoCAD - Super Easy & Dynamic | 2 Minute Tuesday

Рет қаралды 59,593

Күн бұрын

** AutoCAD Productivity Training Webinar Available Now: gumroad.com/l/oPLLa/may4
INTO THE AM :
cadintentions.com/ITA (Get 10% for using my link or code CADINTENTIONS at checkout!)
Join this channel to get access to perks:
/ @cadintentions
#autocad #datalink #cadintentions
Sign up for Updates and Free Downloads: cadintentions.com/signup
Download AutoCAD Templates: cadintentions.com/tbdl
Learn Civil 3D (C3D Crash Course): cadintentions.com/c3dcc
Learn AutoCAD (ACAD Courses): cadintentions.com/courses
Brandon here back with another new 2 minute tuesday!
In todays video take a look at how link an excel table directly into AutoCAD while keeping a dynamic link to the original excel file.
This tip can help you insert and setup excel tables in autocad quickly and easily, saving you a ton of time! By using data link we can instantly import our table data directly from Excel to AutoCAD
If you want to keep up to date with new videos, be sure to subscribe to the channel and check out my blog, cadintentions.com.
Oh and let me know what autocad tip, trick or tutorial you'd like to see in the next one down below!
Cheers and thanks for watching
My Gear/Recommendations
AutoCAD 2018: bit.ly/2ouIOXX
PC: cadintentions.com/xi
Cool Monitor x2: amzn.to/2n4YS2l
Mouse: amzn.to/2n55JZE
KeyBoard: amzn.to/2n514XL
Pencils: amzn.to/2nPT61L
Sketch/Notebook: amzn.to/2nBTqjH
Headphones: amzn.to/2n5nmsn
For business inquiries:
Email: brandon(at)cadintentions.com
Twitter: cadintentions
Want to send mail/products for future posts?
CAD Intentions
PO BOX 99900 AT 031 911
RPO VALLEYVIEW
KAMLOOPS BC
V2C 0G1
Canada
MY CAD & Engineering PC Built by @Xi Computer: cadintentions.com/xi
Specs:
PROCESSOR: Intel® Core™ i7-6700K @ 4.4GHz-Hi-Perf.
MEMORY: 16GB DDR4 @ 3000MHz
GRAPHICS: NVIDIA® GeForce® GTX 1080 OC 8GB
HDD: 512GB Solid State Drive NVMe Samsung® 950 PRO
POWER: 850W Rosewill® Glacier 850M

Пікірлер: 49

@Cadintentions 3 жыл бұрын

If you liked this tip and want to speed up your AutoCAD learning and productivity, check out my AutoCAD Productivity Course, available now for 20% off: cadintentions.com/starwars

@talentlogic1512 3 жыл бұрын

I always copy the table in excel, then I use the "pastespec" command to bring my table into AutoCAD. It links the table dynamically.

@JFASACM 2 жыл бұрын

That was really helpful. Thanks a lot!

@jennifermott5651 Ай бұрын

Wow...I've been doing tables wrong for a long time... Thanks!

@andremartins4770 2 жыл бұрын

Thank so much guy, It's worth to watch your video. Congratulations for your intention!

@rziguiaymen7519 3 жыл бұрын

Thanks a lot, this has been so helping

@user-kk5sl1gl2o Жыл бұрын

Thank you! You are very good! 😊

@khayeoo8842 4 ай бұрын

Really helpful. Thanks for your productivity videos.

@AndrewLoganBeckwith 11 ай бұрын

Great video, thank you.

@architectehasni352 3 жыл бұрын

Hi from Tunisia ! Thank you for this useful video

@Cadintentions 3 жыл бұрын

Hi From Canada! Thank you for watching, glad it was helpful!

@peterv1367 2 жыл бұрын

Thanks for the info pulled me out of a jam. and I can understand you unlike the other vid. had no idea what the heck was being said.

@GuyFrommexico Жыл бұрын

Worked perfectly, thanks!

@Cadintentions Жыл бұрын

Awesome, that's great!

@kytan13 3 жыл бұрын

Needed this, thx.

@Cadintentions 3 жыл бұрын

Awesome! Glad it helps, thanks for watching!

@BruceWayne-us3kw 5 ай бұрын

This was really helpful. I was about to break something out of frustration before watching this because AutoCAD kept crashing.

@nemanjapoluga1970 3 жыл бұрын

THANK YOU!

@FF-fy2xe 3 жыл бұрын

Amazing clean and super easy to understand. Can you please explain if this procedure works on AutoCAD LT?

@khaledxerox Жыл бұрын

thank you so much for this well-done elaborate, but how do generate a table with drawings titles updated automatedly.

@vivibadani3535 Жыл бұрын

Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu, I always copy pasted from excel but I dont know why on a specific file I had when I printed on PDF the letters were so small, and I didnt know how to change it.... so your method saved me.

@Smarteagle2008 2 ай бұрын

very helpful. thank you!

@Cadintentions 2 ай бұрын

Glad it was helpful! Cheers

@revodzz 5 ай бұрын

how to make that table bigger in autocad looks like to small in the autocad and how to make bigger also the font size of the text in tables. thank you

@eros821 2 жыл бұрын

How can we do this but instead have the information that was input into excel directly be inputted into its respective field in the title block in the paper space ?

@HusfadlyahoocaEgyptrevolution Жыл бұрын

Great .... Is this options avaliable for AutoCAD for MacBook???

@moltoadisuanega1481 2 жыл бұрын

it is good what have presented before. do have about how to insert legend in auto cad?

@aruchun 2 жыл бұрын

How to adjust the size of the table , and how to use the same table properties to other autocad data.

@amandagorringe2969 Жыл бұрын

I am trying to link an excel structure data table. Does the link automaticly update when you open the drawing? Mine does not for some reason. I want to be able to batch plot from the Sheet Set knowing that I have the up to date table without having to go into the sheet to re sync the sheet before I plot it. What am I doing wrong?

@bobthornton5533 2 жыл бұрын

When I link excel into autocadd the font goes to bold. Can the font be modified in autocadd?

@marcostarnari Жыл бұрын

Dear, when I add a new row, in excel and do de modifications (same font), in Autocad the dimension of the new cell and the formatting text are differents...how can I solv this problem? thank you

@XRPVenture 3 жыл бұрын

Hey Brandon, (Or anybody else) can you help me edit the distance between double line? All the youtube videos are 3 and 4 years old and don't seem to apply and I'm running AutoCad 2021. THANKS!

@Cadintentions 3 жыл бұрын

Hey, Thanks for the question. I'm not completely sure which double line you looking to change the distance between. Did you mean a double line, linetype? If so you'd want to look for a video on modifying linetypes or creating a new one. I have one or two on my channel but I don't think I've done one on double line linetypes unfortunately.

@XRPVenture 3 жыл бұрын

@@Cadintentions Thanks Brandon, I just want to set up double lines for 2x4 & 2x6 walls.

@fahatulhajiwahap2068 2 жыл бұрын

this is super useful! now i dont have to create table and copy paste my data XD

@francescopallavicini2207 3 жыл бұрын

Hi👋... It's possible link only text and no have the line of table? Thank you💪

@Cadintentions 3 жыл бұрын

You should be able to modify the table style to rove lines, if you just need a block/paragraph of text linked you can try Rtext, I have a video on the channel showing its use too here: kzfaq.info/get/bejne/m79kpJVz2raVZ4E.html Thanks for watching And the question! Cheers

@prachse 2 жыл бұрын

please dive deeper on this kind of content. building information is complicated somtimes. to be organized is really important.

@markgilmour9587 4 ай бұрын

If the Excel file's name changes, how do you restore the links?

@bobthornton5533 2 жыл бұрын

When I insert excel into autocadd the font goes to bold. How to I modify linked font when it’s in auto add.

@jasonfurniss1140 3 жыл бұрын

can you do this with a word file. for bringing in notes????

@Cadintentions 3 жыл бұрын

Hi Jason, Thank you for the comment and watching. Unfortunately Data links won't work with a word file, they can only link to excel and .csv files since they're tied to tables in AutoCAd primarily. But you could add notes to a table depending on your need. I think you would probably want to use something like Rtext or an xref for your notes. I did a video on a way to link AutoCAD text to a notepad file (.txt) which should be exactly what you're looking for. Check it out here: kzfaq.info/get/bejne/m79kpJVz2raVZ4E.html Hope that helps and thanks again for watching! Cheers

@reviewfood1692 Жыл бұрын

why it doesnt include the pictures on my tables?

@Lee-oj3ro Жыл бұрын

When I bring over my table from Excel the text is extremly small. How do i change the font size once it comes over.

@bolababu1905 7 ай бұрын

Why excel file is not appearing in print??How to resolve this issue

@antoniiocaluso1071 2 жыл бұрын

just curious...WHY do so many CAD-folks on YT wearing baseball caps? :-) Seriously! Long-time CAD-guy in FL here (since '82 on MicroStation then!) who has NEVER worked in any offices that needed them worn. Guess we knew how to design our lighting, huh? haaaaa To me, it does NOT look "cool", nor is it it Functional in FL, where a SOMBRERO is more-appropriate in Summer! Guess Canadian CAD-folks need hats to...stay warm waaay-up-there?? ))) Spill the beans, please, Brandon. Stay COOL, y'all !!

@IbocC64 Жыл бұрын

Linked tables have to be the buggiest AutoCAD tool in history. Its impossible to get the format right on import and if you format after import, then change the data, the format completely reverts. I find it best to create attributed blocks that mimic tables. That way they only have one format available, the right format.