Hi - when I download data to excel or CSV file, instead of the questions across the top it randomly populates it with answers. What am I doing wrong??
Best answer by Liz
View originalHi - when I download data to excel or CSV file, instead of the questions across the top it randomly populates it with answers. What am I doing wrong??
Best answer by Liz
View originalHi
Hi Liz - here you go - you’ll see our 1st question in column B, as I would expect (this is a single answer Q); then instead of the question at the top there are answers spread across columns C-J.
Hi
Hi
Hi
Hi
Hi
here’s a simple form that is a one question quiz:
when you connect it to a google sheet you get the question across the top and all the multiple selections in one column under the question. if you want to parse the choices out into separate columns use the split() function in google sheets
when you look at the results in a downloaded excel file, you are correct that you don’t get the question just the ‘choice option’ as the column headers. When i have done this in the past, i simply edit the downloaded file and add a row above with the question in a merged cell over top of the options. not perfect but it gets me the question text in there
i honestly prefer the connect route to the spreadsheet for the data.
des
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.