Forum Discussion
Issue with exporting responses to Excel
Hi all, Just starting out with Forms and have already come across an issue. We have set up a simple training survey form which works great. I've deleted all of the initial test responses so ...
Hi Dave Pyett,
Let's see if we can help
1.) Go to https://forms.office.com/ and login
2.) Select the form
3.) Select Reponses
4.) Select ... and delete all responses
5.) The open in excel should now be greyed out
6.) When you submit responses from this point a new excel should be populated
Hope that answers your question.
Best, Chris
Let's see if we can help
1.) Go to https://forms.office.com/ and login
2.) Select the form
3.) Select Reponses
4.) Select ... and delete all responses
5.) The open in excel should now be greyed out
6.) When you submit responses from this point a new excel should be populated
Hope that answers your question.
Best, Chris
Hello Dear,
Could you help me please with my issue?
I am using Microsoft 365. I have set up a simple training survey form that works great. And After I viewed the 12 responses, I exported them to excel. But the result was unsatisfying, as some of the question's responses were vanished from the excel file!
There are like 4 questions out of 20 that were exported to the excel file but without their responses.
You can find attached the excel file.
Thank You in Advance.
- Are the responses visible online in the form responses under View Results? Can you send a screenshot?
Best, ChrisYes, dear, they are all visible online without any problems. Please see below the screenshot.
Thank You
- In my experience, whilst I don’t read Arabic (so cannot be certain) the empty columns can be a case of renaming the question in the form - did you ever do this? Have you cross verified the information here with the excel?
A few options here would be
- populating the empty parts of the excel with the data from the online. This would be a manual process and not ideal
- raise a ticket to Microsoft support comparing the online screenshots to the excel
- reset the form and then have respondents resubmit their answers
- do a new form without changing the questions and getting responders to resubmit
I don’t think there is any way I know of to be able to autocorrect disparities in the online and exported excel versions outside of the four above
Best, Chris