Data Extraction - extract to Excel template

[Anonymous]

Hello, Our procurement department uses a specific Excel file for their own magical purposes when purchasing products. I'd like to extract my block attributes into a copy of that Excel file and simply hand it over to them with little to no editing from my end. Such as attributes like description, manufacturer name, model number, UOM, quantities (count) and so forth would align with the appropriate columns in their template. Any remaining/unused columns in the Excel file would remain empty, used for their own purposes. Any idea how I can accomplish this? Thank you in advance, Matthew

[S.Faris]

Refer these:

Data Extraction: Exploring the Features and Benefits of AutoCAD

About Data Extraction

AutoCAD | Tables and Data Extraction

AutoCAD Data Extraction: Take Your Drawing to the Next Level

AU 2016 Video: Learn All About AutoCAD Data Extraction

[Anonymous]

Thank you S. Faris for your response.  Either I am completely missing something obvious or everything I am reading/viewing assumes knowledge of something particular.    I follow the various steps outlined from various web links and I can never get the link to work.  Attached are examples of what I am attempting.  
Through the Data Extraction Steps I am Displaying Blocks Only, and Display Blocks with Attributes only.  The Only Property I am selecting is DESCRIPTION.  

Would anyone be so kind as to help me where I am going wrong? 

[ChicagoLooper]

Sorry, you cannot extract data, whether block attributes or not, and have AutoCAD insert the extractions into an existing table. AutoCAD will, however, create a new table, which is something you should probably do. Once you've compiled your data on a single spread sheet, you may edit it to suit your needs, e.g. flip-flop columns B and C, change column headings, delete unnecessary rows, add columns, fill in 'default' values such as N/A, null,---, none, etc. When you feel your edits are acceptable, you may cut the data and paste them in your template.

Alternatively, you may format the columns in the extracted spread sheet so it mimics your template's columns then paste the template's headings above your extracted cells. 

FWIW, I would extract all attributes from your blocks. Afterall, you have only four of them: category, description, notes and supplied by. Combine those four with Block Name and count (count=no. of instances the exact same block with the exact same attribute  values appear in your dwg) and you'll have a total of six columns, and that's not much. It's better to have more data than you need than not enough. 

If you can find ways to expand uses of data tables, then you are on your way to using data extraction to help you and others make more meaningful and informed decisions..