Forum Discussion

Chris Donaldson's avatar
Chris Donaldson
Copper Contributor
Oct 24, 2018

Form Question Not Appearing in Excel Output

I have this issue all the time. I have a simple form (forms only allows for simplicity anyway) and the top row in my Likert table on question 4 does not send the selected option to my Excel output. So at the moment I have to go to the Responses section within the form, View Results and go through each one and manually enter them. It seems the link between form question (well the top row of the Likert question) is broken. Help please!

microsoft forms

3 Replies

  • Peter Mcdermott's avatar
    Peter Mcdermott
    Iron Contributor
    Mar 22, 2022
    3.5 years later, I'll echo that when I have multiple likert questions with the same response criteria, the Excel file does not show the question, only the likert response options and they're not in the same order that the questions are presented on the Form. It's impossible to tell from the Excel output, which responses belong to which question. Defeats the whole purpose of using Excel to manipulate the data. SMH
    • Peter Mcdermott's avatar
      Peter Mcdermott
      Iron Contributor
      Mar 22, 2022
      This may help others looking for a solution: https://docs.microsoft.com/en-us/office/troubleshoot/microsoft-forms/forms-response-columns-out-of-order

Resources