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 the form no shows 0 responses - all good but if I export the responses to Excel, it displays all of the test responses. Should I then make this form live, those test responses could skew the overall results.
Is this expected behaviour or is something not quite right on my tenant?
Thanks! Dave
- 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, ChrisThanks for that - have tried it but the Export to Excel option remains active and still shows all previous responses. The form itself shows 0 responses etc (attached screenshot).
Maybe just a timing thing? Will leave it until tomorrow and will try it again
Dave.
- Ok! Another option could be to just copy/clone the form. So if you go back to Forms on the top left of the screen and select ... on the form and then copy you can clone it. This may be a workaround it.
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, Chris
