Specialists and engineers are working with DWG files know, that you could not simply extract tables from DWG files and copy their content to Microsoft Excel using Clipboard. For this task please use special Excel file with Macro to import tables from DWG files to Excel sheets.
There are two options to extract: use free version of NanoCAD or AutoCAD commercial software.
Use NanoCAD Free:
1. Download NanoCAD Free
http://nanocad.com/page/DownloadNanoCAD
2. Read official NanoCAD installation guide
http://nanocad.com/page/InstallationGuide
In PDF format
http://nanocad.com/images/InstallGuide/InstallGuide.pdf
Use video guide
http://nanocad.com/page/InstallationVideo
3. Don’t forget to register and activate NanoCAD Free.
4. Download “Extract_Tables_From_DWG_to_Excel_NanoCAD.xlsm” Excel file with Macro or “Extract_Tables_From_DWG_to_Excel_97-2003_NanoCAD.xls” for Excel 97-2003.
5. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:
“nanoCAD Type Library (NCAuto.dll)”
“OdaX Type Library (OdaX_csd.dll)”,
then press OK.
6. Close Microsoft Visual Basic for Application editor.
7. Enable Macros in Excel
https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12
8. Copy all DWG files to the same folder with Excel file. From these DWG file all tables will be extracted to Excel sheets.
9. Press “ALT+F8” to run “Extract_Tables_from_DWG_To_Excel_NanoCAD” macro.
10. Macro will open NanoCAD application and extract all tables in DWG files. Each table from DWG file will be placed on a new Excel sheet.
Use AutoCAD commercial version:
1. Download “Extract_Tables_from_DWG_to_Excel_AutoCAD.xlsm” Excel file with Macro or “Extract_Tables_from_DWG_to_Excel_97-2003_AutoCAD.xls” for Excel 97-2003.
2. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:
“AutoCAD YYYY Type Library” file” (acaxXXenu.tlb),
where YYYY – YEAR of your AutoCAD Version, XX – 21, 20, 19,…(version number);
“AutoCAD Focus Control for VBA Type Library” (AcFocusCtrlXX.dll);
“AXDBLib” (axdbXXenu.tlb),
then press OK.
4. Enable Macros in Excel
https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12
5. Copy all DWG files to the same folder with Excel file. From these DWG file all tables will be extracted to Excel sheets.
6. Press “ALT+F8” to run “Extract_Tables_from_DWG_To_Excel_AutoCAD” macro.
7. Macro will open AutoCAD application and extract all tables in DWG files. Each table from DWG file will be placed on a new Excel sheet.
Known features and limitations:
a. Maximum DWG files – 1000.
b. There are no limitations for table’s quantity for each DWG file.
c. All text from DWG files will be copied as “Text” with “Format Cells”
d. Merged cells will be copied as Unmerged to Excel Cell – to the first left cell.
e. All Fonts formatting – Bold, Italic, etc. will be unformatted according to these specifications:
https://knowledge.autodesk.com/support/autocad/getting-started/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-Core/files/GUID-7D8BB40F-5C4E-4AE5-BD75-9ED7112E5967-htm.html