Export text from DWG to CSV/Excel

[bonacasar]

Hi, I'm a newbie,

but on my new work, the company has ordered me to copy a lot of text from various dwg to Excel table.

 

So, I search a tool to do this, therefore to catch an area from AutoCAD in which there are some data and paste to clipboard or to Excel table directly.

 

I've found a wonderful Lisp script (in compiled format VLX) that does it this!!!

This is called "Txt_to_Xls_V2.VLX", and you can view on this demo video:

 

Unfortunately, the forum on which this script resides was abandoned from few years and the registration page doesn't work. So, I cannot login to download it.

 

I attach to this post a pair of dwg, that are those from which I must catch the data, such as shown in "table.jpg" attached screenshot.

 

I've a lot of these, with a short timing.

 

I would appreciate very much that someone help me, because I don't know LISP programming language, and I've no time to learn it, because at work I am on trial period, and if I spend too much time, I will lose my job.

 

Meantime, I continue to copy data manually but, doing it, I'm afraid of making mistakes in copying that will be more severe problem instead of to take too much time to do this job.

 

Many many many thanks in advance to all.

Riccardo

example.dwg

example-only-table.dwg

[ReMark]

Have you tried using AutoCAD's DATAEXTRACTION command?

 

There is another option for getting text (plain text not MText) from an AutoCAD drawing to an Excel spreadsheet. It is a lisp program called Click2XLS.vlx and it is available from CADStudio as freeware. Download the file. Open a new Excel spreadsheet then go to your drawing, APPLOAD the .vlx file, then invoke the command TEXT2XLS. When prompted start selecting your text objects. When done press the Enter key. Pressing the F2 key in AutoCAD will bring up the Text window and there you'll see a list of what text was exported as well as a sentence that reads "Strings of X texts exported". Now open your spreadsheet and view its contents.

 

Find Click2XLS.vlx here...http://www.cadstudio.cz/freeware

 

Note: I did a simple test this morning using the program and it worked. The default start position in Excel for placement of text is Sheet 1, cell A1. It is possible to change the position of inserted text by opening the spreadsheet and clicking on a different sheet and even a different cell. This might save you some time having to reformat the text once it is exported to Excel. Good luck.

 

Addendum

 

I found a lisp routine called TXTOUT.lsp by John A. Bogie that incorporates original code by Tony Tanzillo which will export Text and MText to a text file that can be opened in Excel. The code can be found in this link to an AUGI thread dating from 2006. Once again I did a simple test that verified that the two commands worked as described by generating a text files for both Text and MText objects.

 

http://forums.augi.com/archive/index.php/t-35671.html

Edited May 27, 2015 by ReMark

[Lt Dan's legs]

http://www.cadtutor.net/forum/showthread.php?94050-GetExcel-and-PutExcel-command&p=643773&viewfull=1#post643773

 

 

you can modify it with the codes below

(vlax-invoke _ofile 'Saveas _file  6)

codes:

".csv": FileFormatNum = 6

".txt": FileFormatNum = -4158

Edited October 5, 2015 by Lt Dan's legs