If you use Microsoft Forms, you know that in order to see the responses you need to export them to Excel. However, having to export them *every single time* you want to see the responses can be a pain point. Did you know you can pre-create the Microsoft Forms response spreadsheet in OneDrive, and then you simply have to open it to see the most up-to-date responses to your Form? Here’s how that works…
To start, go into your OneDrive and select New > Forms for Excel to create the Forms response spreadsheet:
Give the Excel file a name. This will be the name of your Form. Click Create to open your Form:
Microsoft Forms will open up with your new Form, and you can add questions as needed by clicking on Add new:
When done, you can test the Form using the Preview link:
Answer the question(s) on the Form, and click Submit to save the responses:
Now go back to your OneDrive and find the Excel response file that you created:
When you open up the spreadsheet, you’ll see your responses have been stored in real time… no more manual exporting!
Please note: This only works if you are in your OneDrive. If you are in a document library of a SharePoint site, you will not see this option.