How do I insert an Excel spreadsheet into AutoCad?

Sometimes it can be very useful to have some additional data inside an AutoCAD drawing, so how do I insert an Excel spreadsheet into AutoCAD? It is pretty straightforward to set up and if done correctly, data that is inserted will automatically update when the original spreadsheet is updated within Excel.

 

Firstly, open the desired spreadsheet then select the data you want and copy it to clipboard.

In AutoCAD go to Edit > Paste Special

Inserting an excel spreadsheet into AutoCAD

In the dialog box, select Paste Link, then as Microsoft Office Excel Worksheet. If the radio bottom is grayed out and un-selectable, as below, then the data currently on the clipboard is unsuitable.

Inserting an excel spreadsheet into AutoCAD

Then click OK. The formatting of the original data should remain, and the data inserted will update inline with any updates made to the external Excel spreadsheet. This means that you won’t need to worry about updating two sets of documents if changes need to be made.

 


If you found this useful, why not check out some of my other AutoCAD posts?

How do I add a .CTB file to AutoCAD?

Free software for students

How to keep your XREF layers frozen

 

Free Software for Students

Some of you may not be aware, that students in full (or part time) education can receive free FULL downloads of many Autodesk products including:

The licenses cover your full period of study. Simply head to the education section of the Autodesk website, and sign up using your academic email address.

Graphisoft also offer free software for students available from MyArchiCad.com, including:

For Mac users Rhino OS X is available for free however, the program is still very much WORK IN PROGRESS. So there are a few major features missing, bugs and fortnightly updates. Save and back up regularly!

This is a great opportunity to gain some experience using these programs, taking advantage of the many tutorials available online, and adding some extra skills to your CV.