Copy AutoCAD Text to Excel! A piece of Cake!

Copy AutoCAD Text to Excel! A piece of Cake! AutoCAD Tips Microsoft Excel

The task?

Have you ever tried to copy AutoCAD text objects to Excel? Copy AutoCAD Text to Excel! A piece of Cake! AutoCAD Tips Microsoft Excel   Usually when you copy an object from AutoCAD and copy it to excel it looks like a picture. If we double click on that picture AutoCAD automatically launches and opens fragment of our drawing which we have copied as a new .dwg file. Yet many times we need to convert our text objects and paste them to excel. For example, if we have coordinate register in our drawing and we want to copy it into excel.

Solution!

I am sure that there are some lisps or even software addons for AutoCAD that could help us copy text to excel. However today we are going to look at one basic method which is extremely fast and doesn’t require third-party software. To complete our task we will go through some very simple steps:

  1. First, we need to convert our text objects to one Mtext object. For the job, we will use the Command TXT2MTXT. If you can’t remember it, you can find the icon in Express Tools tab.  When we activate the command AutoCAD will ask us to select text objects. Now we just have to select our coordinates and hit enter.
    Copy AutoCAD Text to Excel! A piece of Cake! AutoCAD Tips Microsoft Excel
    Note: For this to work as we want we first have to align our text objects the way we want them in our excel table.
  2. Now as we have one Mtext object with multiple text lines we can double click on it, select all the content and hit copy (Ctrl + C)
  3. We can go launch Microsoft Excel and paste our data there. All the text will be pasted in a single cell. Don’t worry it is normal!
  4. Now we select our cell and open the Data tab, there, we search for Text To Columns.
    Copy AutoCAD Text to Excel! A piece of Cake! AutoCAD Tips Microsoft Excel
  5. A window will pop up called Convert Text to Columns Wizard. Here we have 3 pages with settings. But don’t worry they require maximum 1 click!
    1. On the first page, we select Delimited
    2. On the second page, we have to set the delimiters. We select “Space” and deselect “Tab” (It will work if we leave tab selected).
    3. There is nothing worth doing in the third page so we just hit Finish!
      Copy AutoCAD Text to Excel! A piece of Cake! AutoCAD Tips Microsoft Excel   Copy AutoCAD Text to Excel! A piece of Cake! AutoCAD Tips Microsoft Excel
  6. We have our text copied and arranged in cells, but it is horizontal. Our task now is to transpose the table (convert it from horizontal to vertical). To do that we have to select our cells, copy them and then right-click on empty cell somewhere in the sheet to select Paste Special > Transpose.

Cool! Now we have our text copied in Excel. We will repeat the procedure for other text objects if we need!
Copy AutoCAD Text to Excel! A piece of Cake! AutoCAD Tips Microsoft Excel

Leave a Reply