How do I get MSFORMS responses in excel format?

Question

I created a MS Form and I want the responses in Excel format. How do I do that?

Answer 1

Dear respected Tina Sprague,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, there is three ways to get Microsoft Form response into Excel format:

1.Using Built-in Open in Excel feature:

You can Microsoft Forms responses in Excel format, you can follow these steps:

1.Go to the Microsoft Forms and access the form, click on the "Responses" tab at the top of the page.

2. Click on the "Open in Excel" button on the right side of the page.
3. The responses will be opened in Excel.

2.Using Excel insert Form feature:

You can also create a form direct from Excel.  Forms will save the responses direct to the Excel Sheet for you. In Excel Online create a new Excel file from OneDrive/SharePoint online (see Flow picture below).

3.Using Microsoft Power Automate Flow:

First you may create a new Excel spreadsheet in OneDrive location and create a table. The go to Microsoft Power Automate and create a Flow trigger (see Flow picture below).

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

![](https://learn-attachment.microsoft.com/api/attachments/129fb220-3073-4457-a863-93e96ab22512?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/0381313c-ad7d-48de-a2dd-7858bdebb1a3?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">![](https://learn-attachment.microsoft.com/api/attachments/0381313c-ad7d-48de-a2dd-7858bdebb1a3?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/b2a356b0-459c-4854-b4cf-d8633e980209?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

Answer 2

Hi respected Tina Sprague,

I'm writing a follow up this case, and I haven’t received any information from you, may I know have you checked above reply? Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad