I had a little play with this. I opened Excel and selected a cell. Then I opened another window and from my Gcode files, opened one using Notebook. I did a <Control + A> and selected all; copied and pasted into the selected cell. Obviously this copied all the code which follows the set up data. I should have just copied and pasted the first part of the coding. To do what you wanted, I would have had to cut and paste each item of data into the column it needed to go into.

I suggest that the procedure should be:
1. Open your main spreadsheet and label the columns that you want to put items of data into.
2. Open Notebook in another window and cascade the Excel and Notebook windows.
3. Open your G-code file in the notebook window.
4. Copy the relevant item of data from the Notebook window and paste into its column in Excel.

It is a cruel state of affairs, but sometimes you just can't do everything automatically with computers - you have to resort to "hunt and peck"

Old Man Emu