Forum Discussion

Kaylynn Burns's avatar
Kaylynn Burns
Copper Contributor
Sep 04, 2017

Form Responses not Showing when Using Open with Excel

 I have a Microsoft Form with 99 responses. When choosing Open with Excel it is missing at least 30 of the responses. Is there a way to get it to show all the responses in Excel? The responses are th...
microsoft forms
drsarchet's avatar
drsarchet
Copper Contributor
Apr 25, 2022
I also am experiencing this problem. I built a form for Students to Sign-In to the Lab, and just today it started only sending only 1,502 responses out of 2,553. The last responses are showing for 2/23/22, and I had all up through last week. Why is it not sending all 2,553 responses to Excel?
  • drsarchet's avatar
    drsarchet
    Copper Contributor
    May 23, 2022
    I use MS Edge Chromium for my browser. I finally figured out that Forms was splitting my download into two files with 1,500 records in each file. Not sure why. There was an option to show all available downloaded files, or in my case only the 1st file. Once I turned this off I was able to see all of the files and get all my data.

Resources