It's actually pretty easy to do this, but all the work is on the Excel side. If you google "API into Excel", there are plenty of how to videos and instructions. I will work on a quick demo in the meantime.
Update: Importing into Excel is easy, but due to the nature of the results format, the manipulation of the data after that is proving to be too difficult given my knowledge of Excel. I would look at using Python to save it rather than using the Excel Query Editor, but maybe someone with more knowledge of Excel can chime in here.