You're right that Excel for the Web automatically refreshes with new responses from Microsoft Forms, but the desktop version doesn't have this feature. However, you can set up a workaround to keep your data updated without manually re-exporting each time.
You can use Power Automate to create a flow that automatically updates your Excel file with new responses from Microsoft Forms. Here's how:
Create a New Flow:
Go to Power Automate and sign in with your Microsoft account.
Click on "Create" and select "Automated cloud flow."
Set Up the Trigger:
Choose the trigger "When a new response is submitted" from the Microsoft Forms connector.
Select the form you want to monitor for new responses.
Add an Action to Get Response Details:
Add the action "Get response details" from the Microsoft Forms connector.
Select the form and the response ID.
Add an Action to Update Excel:
Add the action "Add a row into a table" from the Excel Online (Business) connector.
Select the Excel file and the table where you want to add the new responses.
Map the Form Responses to Excel Columns:
Map the fields from the form response to the corresponding columns in your Excel table.
Save and Test the Flow:
Save your flow and test it by submitting a new response to your form. The flow should automatically add the new response to your Excel file.
For more detailed instructions, you can refer to the following resources:
These steps should help you keep your Excel data updated with new form responses automatically. If you need further assistance, feel free to ask!
David_MA
310
Super User 2025 Season 1
Michael E. Gernaey
271
Super User 2025 Season 1
stampcoin
253