MS Forms issue with results

FM 0 Reputation points
2026-11-19T15:02:18.55+00:00

I am using surveys on MS Forms for a research project. One of the questions is a frequency questionnaire using the Likert scale. When I exported the results to excel, the first 4 answers are missing from ID 270. However, on the MS Form summary, it appears that ID 270 answered these questions. When investigating further, I found that ID 262's answers were missing from the MS Form summary, but had appeared in the excel sheet. I assume that either the MS Form or excel sheet is wrong, and is putting one participant's answers as another's.

How do I know which results are accurate? It is important that the answers match up with the correct ID. Is MS Forms or Excel more likely to be accurate to the true answers?

Microsoft 365 and Office | Microsoft Forms | For education
0 comments No comments

1 answer

Sort by: Oldest
  1. Lin V 2,145 Reputation points Independent Advisor
    2026-11-19T16:01:40.11+00:00

    Hi FM,

    I tried to reproduce this behavior by submitting two separate responses with different answers and then comparing them in Forms and Excel. In my test, the answers remained correctly associated with each response in both places, so I could not reproduce the mismatch you described.

    Since these responses have already been submitted, I would be cautious about assuming that either the Forms summary or the current Excel workbook is the accurate one. Given the importance of keeping each response associated with the correct participant, I would suggest cross-checking the results in as many available places as possible before making any changes to the data.

    First, try opening your form in Microsoft Forms in an Incognito/InPrivate window. Then select Responses > More options (...) > Disconnect and sync to a new workbook and compare IDs 262 and 270 again to see whether the discrepancy remains in the new workbook.

    User's image

    If they still do not match, and your research protocol allows it, you could ask the affected participants to confirm their answers as another point of comparison. If that is not possible or the results are still unclear, I would suggest asking your IT admin to contact Microsoft Support for further investigation.

    I hope everything will be sorted out soon.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.