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.


  • Profile Image

    How can I reformat reports for data importing?

    Asked by Erin Spink  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

    Page URL:
    http://www.crohnsandcolitis.ca/site/c.dtJRL9NUJmL4H/b.9013431/k.A0F0/A<br/>pplication_Form.htm

    Reports importing My Forms multiple choice format
  • Profile Image
    JotForm Support

    Answered by Mike_G 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
    JotForm Support

    Answered by Mike_G 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