Can I extract data from a table using the data extraction command?

[bachalv]

I know that it is possible to extract data to a table, but is it possible to extract from a table?

I need to extract data into a excel sheet from a table that is filled manually by the designer in AutoCAD. I attached the info that is shown when I use the data extraction command.

Thank you

[jreidKVSUZ]

Bachcalv,

Try TABLEEXPORT:

To extract tables from AutoCAD to Excel, use the TABLEEXPORT command, which allows you to save tables as CSV files that can be opened and edited in Excel. Simply type TABLEEXPORT, select the table, and save. Alternatively, right-click a selected table and choose "Export," or use DATAEXTRACTION for more complex data.

Method 1: Using the TABLEEXPORT Command (Quickest)
This method exports an existing AutoCAD table to a .csv file.
Type TABLEEXPORT in the command line and press Enter.
Select the table in your drawing you want to export.
In the dialog box, choose a save location, provide a file name, and ensure the file type is set to CSV (Comma delimited) (*.csv).
Click Save.
Open the saved file in Microsoft Excel.

Hope this helps!!

Thanks, JRR!

[bachalv]

Thank you JRR, this is really helpful.

But additionally, is there any way that I can extract info from blocks and from a table in the same csv file?

Thank you,

André Bacha

[jreidKVSUZ · Accepted solution]

I think you might have to do them both separately. do your Tableextract then Dataextrac and then manually combine them.

Because TE does not see anything other then the Table you pick. Also, DE only see all of the data but not the Table.

Explanation: 

Yes, you can export both AutoCAD tables and block attributes to Excel. The best methods include using DATAEXTRACTION for both (full version), ATTOUT (Express Tools) for attributes, or the TABLEEXPORT command for tables, typically resulting in CSV or TXT files that open in Excel.

Exporting Block Attributes to Excel: 

ATTOUT (Express Tools): Type ATTOUT in the command line to export block attributes to a tab-delimited text file, which can be opened in Excel.
DATAEXTRACTION: Type DATAEXTRACTION, follow the wizard to select blocks and attributes, and export directly to .xls or .csv.
Importing Back: Use ATTIN to import edited attribute data back into AutoCAD.

Hope this helps!!

Thanks, JRR!