Microsoft Forms response data is split in multiple files

%3CLINGO-SUB%20id%3D%22lingo-sub-276603%22%20slang%3D%22en-US%22%3EMicrosoft%20Forms%20response%20data%20is%20split%20in%20multiple%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276603%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20excel%20form%20online%20using%20forms.microsoftonline.com.%20We%20have%20more%20than%205000%20entries%20there.%20Now%20when%20I%20try%20to%20open%20the%20reponses%20in%20excel%2C%20the%20data%20is%20getting%20split%20in%20multiple%20files.%20First%20file%20has%20upto%20record%205000%20and%20the%20second%20one%20has%20the%20remaining.%3C%2FP%3E%3CP%3EPlease%20can%20anyone%20tell%20me%20the%20reason%20for%20this%3F%20Is%20there%20a%20setting%20that%20needs%20to%20be%20changed%3F%20Do%20I%20need%20to%20clear%20the%20form%20responses%20after%20a%20certain%20limit%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-276603%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276693%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20response%20data%20is%20split%20in%20multiple%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276693%22%20slang%3D%22en-US%22%3E%3CP%3EI%20had%20also%20read%20the%20limits%20before%20I%20created%20and%20form%20and%20it%20mentioned%2050000.%20Its%20strange%20it%20is%20splitting%20it%20out%20now.%20I%20understand%20the%20only%20option%20I%20may%20have%20is%20to%20clear%20the%20responses%20and%20save%20in%20offline%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276683%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20response%20data%20is%20split%20in%20multiple%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276683%22%20slang%3D%22en-US%22%3EThe%20limit%20used%20to%20be%205000%20and%20now%20it%20says%2050000%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FFrequently-asked-questions-about-Microsoft-Forms-495c4242-6102-40a0-add8-df05ed6af61c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FFrequently-asked-questions-about-Microsoft-Forms-495c4242-6102-40a0-add8-df05ed6af61c%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%20it%20might%20still%20split%20them%20out%20or%20because%20you%20created%20before%20the%20update%20maybe%20it%E2%80%99s%20set%20to%205000%20on%20that%20form%20on%20the%20back%20end.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I have created a excel form online using forms.microsoftonline.com. We have more than 5000 entries there. Now when I try to open the reponses in excel, the data is getting split in multiple files. First file has upto record 5000 and the second one has the remaining.

Please can anyone tell me the reason for this? Is there a setting that needs to be changed? Do I need to clear the form responses after a certain limit?

 

2 Replies
Highlighted
The limit used to be 5000 and now it says 50000 https://support.office.com/en-us/article/Frequently-asked-questions-about-Microsoft-Forms-495c4242-6...

However it might still split them out or because you created before the update maybe it’s set to 5000 on that form on the back end.
Highlighted

I had also read the limits before I created and form and it mentioned 50000. Its strange it is splitting it out now. I understand the only option I may have is to clear the responses and save in offline file.