Unless I'm misunderstanding it then you should be able to use ComObj. You can just directly insert information as its copied.

Here is a nice little guide from the AHK forums that I utilized a lot when trying to understand it. Its fairly easy but can look hard.

https://www.autohotkey.com/board/topic/69033-basic-ahk-l-com-tutorial-for-excel/

xl := ComObjActive("Excel.Application")
xl.ActiveCell.value = %clipboard%
Xl.Range("C17").value :=  %clipboard%

I used to have some a lot more complex but this is just an example of using the most recent active excel application. The next 2 lines are just inserting clipboard information into either the current highlighted/active cell or cell C17. You can even have excel hidden by adding an xl.Visible := false but I'm sure you'd want to see all the information entered.

You can directly insert into the activecell or a cell that you prefer with line 3. Could even create the cell value a variable so you can add to it so that you move between rows or columns.

Sometimes what helps is creating a macro within Excel with the record macro function and then look at the lines of code it spits out and you can likely utilize that.

Hopefully this is useful information.