Missing data on ms forms export to excel

Question

I have created a survey on MS forms for my students that has 49 responses. When I try to export the data to an excel document, only 3 of them actually show up on the excel document and only some of the data is present for each. I have tested other surveys I have used in the past on MS forms and the data transfers to excel with no issues. How can I fix this problem?

Answer 1

Dear Ryan_339,

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

We are sorry to hear that you’re having trouble with missing data on MS Forms export to excel. I deeply understand the inconvenience caused and apologize for it.

We appreciate your understanding that sometimes the initial response may not resolve the problem immediately. However, we can work together to narrow down and resolve the situation. So, for further troubleshooting, could you please provide the information below:

1. Could you please let me know if you tried to click on the Open results in Excel option check if the full details have populated and try to export the data one more time again. You do this by following the below steps:
   1. Go to the Microsoft Forms website and log in with your Microsoft account.
   2. Find the form for which you want to view the responses and click on it.
   3. Click on the "Responses" tab at the top of the form.
   4. Click on the "Open results in Excel" button. After this try to export the data to an excel document.
   5. If you have clicked this option before, A different option will appear showing the file icon and path and you need to click on that as shown below:
   6. If the Excel file which is still missing data, then click on the drop-down arrow and click "Disconnect and sync to a new workbook"

Once again, I apologize for the inconvenience this has caused. We appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Ralph Chawatama | Microsoft Community Moderator