What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Excel Submissions Data: Separate Checkbox Answers when Exported to ExcelAsked by sweise on February 18, 2013 at 11:43 AM
Dear JotForm team,
I am trying to import data from my survey to SPSS and my attempts are hampered by the way jotform reports data in excel. In particular I have difficulties with mutliple choice questions (i.e. questions with check-boxes which allow several answers). The exported excel sheet holds all selected answers by the respondent in the same cell which is problematic in so far as that I've got no easy way to differentiate the multiple choices in SPSS or excel.
One option would be to recode the variable which holds the multiple choice answers into different variables for the same question. This approach would be complicated by the fact that I wouldn't be able to easily add new responses to the excel or SPSS file.
Would there by any way to export data in a more SPSS-friendly manner?
Looking forward to your response. Many thanks for your support!
That is how the check boxes generated by excel works currently. Columns are generated according to its fields not by its options. I'll submit this to our development team so they can consider this in the future updates though I couldn't promise any dates to when since they have a long list of features/bugs that are on the priority list. However, we will inform you on this thread once we have updates about this.
Have you tried exporting your reports in CSV format instead of Excel to see if that gives you the results you are looking for? It might be a cleaner way to import data into your SPSS software. There could also be a difference in if you're performing this import on a PC or a Mac. Hope this information helps.
Yes, I did try the CSV export - being on a Mac at least it did not solve my problem unfortunately. For the time being the work around is to import all the data to an excel spreadsheet on the back of which I build a second excel table, which drawing on the initial raw data but with additional formulas applied. MCQ values currently applied to one cell are taken and distributed amongst individual cells per MCQ item. This way I can generate a multiple-response set variable in SPSS. Kind of complicated but it works.