I think you CAN get some of what you want in GMD. Not ALL of it. For the rest you have to go to an external spreadsheet. But that isn't horribly difficult
You probably have already discovered what I am talking about, but maybe it will help someone else.
One missing element is a definable quantity. I am not CERTAIN that is impossible, though. I just have not had to deal with it, so I have not searched. What I mean is your material quantity. Obviously it is not hard to get the number of brackets, that comes out of the model. Adding up the 7.575" of 4 x 4 x 1/4" steel angle IN each bracket, AND adding the saw kerf, THAT is what you will have to do in a real spreadsheet
You can directly export the BOM as a CSV file, which will import into Excel, or presumably into the program you use. At that point, you are able to do whatever you want with it, obviously. At least you can get it directly in, without typing, and have a shot at formatting it in GMD so that it drops into the slots you want in your spreadsheet.
With any luck, you can get everything lined up, with quantities, so that all you have to do is put in details like saw kerf, or whatever to get the added up amounts you want. I suspect you will have to define your summed areas and so forth.
As for the part data, it is not hard to "alias" the column to be some other heading, which may be part of your issue. Then you can enter the data type you want and the heading will come out right. However, because that ONLY occurs at the level of the BOM, you have to remember which columns you have aliased to what so that the various data goes in the correct column. (I keep a cheat sheet...)
This format is what the client wants, don't blame me for it. But it does show aliased columns,at least, and could be formatted to be more of what you may want.
It went into Excel, with one oddity where a number turned into a date,
It looks like you can, if not "automate" the process, at last make it much less painful to extract it out of GMD.
Beats heck out of the system at a former employer, where we had spreadsheets, etc, but to get it into the manufacturing system you STILL had to read it off the spreadsheet, and key each item into the MRP system individually, with all the details.