Quick Insert of Spreadsheet into CAD file (and link them)

I’m going to finish up my posts on data extraction with a tip & trick on how to get data into your AutoCAD file. I have posted about the new feature in AutoCAD 2008 called DATAEXTRACTION, I discussed using the older commands of ATTEXT and EATTEXT, and I also talked about the BCOUNT command.

Today I want to show you how easy it is to take existing data in a spreadsheet, put it into AutoCAD, and have the two linked.

This is a very useful tip when one employee creates a spreadsheet for a report that has data that also needs to go into a cad drawing. It is even more useful to have both documents (the report and the drawing) to have the same data, be it right or wrong.

Very simply, open the spreadsheet file. Select the cells that you want to have in the CAD file. Copy them (right click, then copy – or click on edit, copy.) Open the AutoCAD file (or Civil3D, Revit, etc.). Click on the EDIT, PASTE SPECIAL. Don’t use the paste command, your data is special, treat it that way.

A window will open. Select the appropriate file type (in my case a Microsoft Excel Worksheet.) If you want the data to be linked to the spreadsheet (which I do) then make sure to select the PASTE LINK button. This will link the data in your cad file to the spreadsheet. If the spreadsheet is changed, then your drawing will reflect that change. Pick you insert point and there you go.

You can’t change this info in the cad file, only in the spreadsheet. You can change the size, layer, plot quality, etc. Select eh object, right click and select OLE. This will give you sizing ability and allow you to automatically open the spreadsheet.

There is nothing fantastic about this method, but it is a quick and easy way to get data into your drawing that is linked to the source. This will keep your drawings and your reports in sync.

Happy CADDING!!

 Subscribe in a reader