I am trying to automate my survey analysis pipeline and would like to link the data from a Microsoft Form to an Excel sheet. This is what the page looks like with results collected:

But you have to click the open in excel to get the table of results. I was wondering if it would be possible to automate this so that it updates to capture all responses like once a day into an Excel sheet...this is what the output looks like when you click the button.

Any tools or tips would be great! I have some experience with R and Python so could implement that too...