How to Export Data from MS Forms

How to Export Data from MS Forms

After you collect the submissions and close the form from accepting more, you may want to export the data gathered to a more presentable or comprehensive layout. You may export the data to Microsoft Excel for further analysis, as well as delete or print a response summary.

• Step 1: Select and Open Desired Form

  

  As you signed in to your account in Microsoft Forms, select the specific form you have in mind. Open it and ensure that you have the number of responses you need or make sure it suffices for producing the data.

  

• Step 2: Locate Share Button

  

  If you are using a pre-made template, you will need to duplicate it before being able to edit it for yourself. Proceed to the three dots or ellipse at the top right corner, there you can spot various additional options. To export your form, click the ‘Share’ button, then copy the link from the ‘Share as template’ button.

• Step 3: Finalize Necessary Changes

  

  Using a template will require you to do the necessary changes and edit. Afterward, you can proceed to share it with your respondents so you can receive their answers and responses.

• Step 4: Check Responses Tab

  

  Right next to the questions tab is the responses tab, where all the answers you have received from your responses will appear. You have the option to review them as a collective or individually. You can also spot the ‘Open in Excel’ option. When you click it, a new Excel file is created and downloaded to your computer.