Excel.Tips.Net ExcelTips (Menu Interface)

Exporting from Excel to AutoCAD

Victor Ammons asked for help on importing information from Excel into AutoCAD. He reports that when he tries to import a worksheet, anything larger than what will fit on an 8.5x11 page is cut off by AutoCAD.

This problem is documented at the AutoCAD Web site, here:


The problem, it seems, is related to the fact that when you import a workbook, only a picture (a metafile) of the worksheet is included. This picture apparently only includes only the first page of the first worksheet in the workbook.

The AutoCAD Web page, referenced above, includes a couple of ways that you can get around this limitation. (They don't list what is perhaps the best solution--to upgrade to the latest version of AutoCAD.) The problem, in many ways, sounds very similar to a problem importing Excel worksheets into PowerPoint, as described in this Knowledge Base article:


In any case, the problem seems to be that AutoCAD is importing the worksheet as a picture. If you only want the worksheet's data--not a picture of the data--then you may consider getting the information into AutoCAD in a different way. For instance, you might export the Excel data in CSV format (which is plain text) and then import it into AutoCAD. Other intermediary formats may also fill the bill, but some experimentation may be necessary.

One ExcelTips reader suggested following these general steps to make sure that the data is pasted properly in AutoCAD:

  1. In Excel, select the data area you want to copy.
  2. Press Ctrl+C to copy the data to the Clipboard.
  3. In AutoCAD, choose Edit | Paste Special | AutoCAD Entities.
  4. Click OK.

To get the Excel data into the CAD model at the right size, it is necessary to zoom the model to the correct size before you paste the Excel data. The simplest way is to attempt the paste the first time and mark the width that you require by holding a piece of paper against the screen and marking the width of the floating paste area on the paper. Then, escape and zoom the model to the required size and then paste the data.

A final possible solution is to look into using a third-party program to handle the conversion of Excel data and its placement in an AutoCAD drawing. There are a number on the market, each with different features and strengths. You should be able to turn up a number of good candidates by doing a quick Internet search.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2992) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Related Tips:

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 4+5 (To prevent automated submissions and spam.)
          Commenting Terms

Comments for this tip:

mahreman    10 Mar 2015, 02:43
my english in bad
i want write text with coordinate in excel then paste it in autocad command bar
for example:
i write in excel
t(text command in autocad)
1,1(first point of textbox)
2,2(second point of textbox)
when i copy it in excel az paste in autocad textbox is opening
how could i write any text in excel and when i copy paste in autocad text be written?
Kazem Vahedi    13 Feb 2014, 01:58
Dear Sir
Thank you for this useful article. It helps me and saves me lots of time.
mars    10 May 2012, 00:23
thank for the tips.. its very helpful..

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2015 Sharon Parq Associates, Inc.