Exporting attribute data into an excel spreadsheet??

[Anonymous]

It is possible to export attribute data from DWG drawings to a pre-organized and pre-formulated excel spreadsheet using AutoCAD LT and how is it done? I want the data to populate its corresponding columns and rows in the excel spreadsheet.

[cadffm]

No,

not in LT and with AutoCAD also only by a program extension.

But you can write (or buy) a external program what import the data from your csv to your sheet.

The simplest solution is an Excel VBA program to do that.

OR

Pre set up your excel template and use reference formulars to "import" your data from another file*.

Then import your csv into this other file or you save the csv every time to the same place&name, so it is *the other file.

My fav: A small Excel VBA solution.

[Anonymous]

Hello CADffm,

Thank you for your response. I am not familiar with VBA. Is there a huge learning curve to setting something like your first option up? I have been attempting to use the template solution and have had no luck exporting any data even with the most basic template of just one line to test it out. I have only been able to find very limited resources on how to set up an extraction template.

[cadffm · Accepted solution]

Hi,

>>" Is there a huge learning curve to setting something like your first option up? "

Real API programming is hard, but you don't need that.

Simple Macros, created by Macro recorder and sample codes (some of the millions you can find in www)

can be enough. But if your knowledge about VBA is near to zero..hmm.

Checkout my really basic (recorded) macro - attached as zip, extract this in your c:\temp\

folder and open DWG and  *xlsm file - Use the IMPORT button

>>" I have only been able to find very limited resources on how to set up an extraction template."

Because there is nothing more to say and nothing more to learn.

ATTEXT

https://help.autodesk.com/view/ACDLT/2021/ENU/?guid=GUID-07C3A8A9-3D8C-4CAF-AF4E-624E5776FC0C

Template Mask

https://help.autodesk.com/view/ACDLT/2021/ENU/?guid=GUID-A1103600-54CB-4FF8-8A62-EF237C890A09

Open the last link and open my ATTEXT_MASK.txt file

check out what it means

Open my ATTEXT_OUT.txt file to see how the result looks like, side by side with my DWG.

(Note, my attext_out file is a bit older, so the value can be differently ti the current attribut values)