In Microsoft Forms, go to Responses at the top-right. Click Open in Excel on the right side of the screen to download the current responses to your computer. You have to repeat this process each time you want to get a response update.
Can Microsoft Forms automatically update Excel?
info Microsoft Forms don't automatically create an Excel file to retrieve your Form responses when used with OneDrive, you will have to do it manually.
How do I pull data from Microsoft Forms to Excel?
In Microsoft Forms on the Responses tab, select Open in Excel. Your form responses will open in an Excel workbook. From Excel, you can export or save your form responses as a PDF file.