How do I export my form responses? (2024)

FAQs

How do I export my form responses? ›

In Microsoft Forms

Open any existing form or quiz you are currently using to gather data. To automatically create an Excel worksheet and save it to OneDrive, select Responses > Open results in Excel.

On the Responses tab, select the View results button. > Print response.

Once you've created a survey, poll, or quiz, you can select an option to allow respondents to receive an email confirmation of their responses.

Using Power Automate and Muhimbi PDF Converter, you can merge form attachments into a single MS Word document, along with the responses, and then send that document as an email. You can also write the generated document to SharePoint, OneDrive, or anywhere you can send files using Microsoft Power Automate.

How to save Microsoft form Response as PDF? ›

Select Forms > Data > Import/Export Data > Export Data from Form. In the Export Form Data As dialog box, specify the name and file type. Click Save.

Open a form from Forms. Go to Settings > Permissions. Open Which authors can edit this form? or Which reporters can view responses for this form? Choose to allow All or None.

Open any active form or quiz, go to the "Responses" page and click "Open results in Excel". This will automatically create an Excel worksheet in your OneDrive and take you to Excel for the web, where you'll see all your data in just a few seconds.