How can I reformat reports for data importing?

  • Profile Image
    Erin Spink 
    Asked on April 29, 2015 at 09:58 AM

    Currently the report that I pull for my forms includes columns where multiple choice answers are all merged together. I'd like those items listed separately in columns of their own to expediate data importing into our database.

    Is there a different question format I can use that will address this or a way I can format the reports differently to achieve this?

     

    Thanks!

    Erin

  • Profile Image
    Mike_G
    Answered on April 29, 2015 at 12:43 PM

    Hi, Erin, 

    I believe, that is not possible right now, but I'll try to see if there are any other workarounds we can use to accomplish your request. 

    We'll get back on you as soon as we found one.

     

    Thank you!

     

    Kind regards, 

     

    Mike_G

     

     

  • Profile Image
    Mike_G
    Answered on April 29, 2015 at 01:21 PM

    Hi, Erin, 

    I believe, this is what you would like to happen: (Please see image below)

    After exporting the forms submissions with the use of this guide.

    I was able to separate the answers using Excel's Text to Column tool and I've done it manually.

    By the way, I have followed the instruction on this documentation: how-to-split-data-into-multiple-columns-in-excel on the internet.

     

    I hope this helps. Let us know if this is or this is not the answer you are looking for.

     

    Thank you for using JotForm.

     

    Kind regards, 

     

    Mike_G