Excel Submissions Data: Separate Checkbox Answers when Exported to Excel

  • Profile Image
    sweise
    Asked 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!

    Sebastian

  • Profile Image
    EltonCris
    Answered on February 18, 2013 at 02:17 PM

    Hi Sebastian,

    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.

    Thank you!

  • Profile Image
    osyrys14
    Answered on February 18, 2013 at 02:18 PM

    Sebastian,

    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.

    Osyrys

  • Profile Image
    sweise
    Answered on February 18, 2013 at 06:49 PM

    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. 

  • Profile Image
    mgtinabrownmedia
    Answered on June 06, 2014 at 02:43 PM

    I am having the same issue - has this been addressed yet?  Would love to be able to utliize.  If nothing has been done yet, can you offer any alternative solutions?