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 download data into Excel where I can manipulate how it is downloaded?

    Asked by njrusso on January 09, 2017 at 04:27 PM

    I currently have 4  forms (out of 10) that have been submitted to be where I asked  for information on their country's delegation, Athletes name, jersey number, t-shirt size, food restrictions, etc and when I download it, it gives me the information in for each team in a ROW in about 100 columns....

     

    I need all the information to download into the columns by question, such as

     

    A column of ALL the Athletes, Jersey #, T-shirt size, food restrictions, etc. instead of one row with ALL the information....I need to be able to sort and tally how many t-shirts I have, how many vegetarians, etc, right now this is useless to me...and proving frustrating and time consuming. I know there must be an easy way, but I can't find it, nor find a filter button like what is show, if that is even how I do it.

     

    Please help. I set my form up at athlete #1, athlete #2, athlete #3, athlete #4, was that my first mistake? This is what I need my excel form to look like, not all of the information that is below in one row.

     

    Athletes      T-shirt Size         Jersey #        Food Restrictions

    Natalie            M                      17                     none

    John               S                       24                       Veg

    Mark S            L                       2                       non

    Gary M           L                       4                        Gluten Free

     

    and so on

    Screenshot
  • Profile Image
    JotForm Support

    Answered by jonathan on January 09, 2017 at 07:29 PM

    I think it is better if you use widget that allow multiple entries instead of using the same fields repeatedly similar to what you did on your form https://www.jotform.us/form/63107216651146

    You can use the Configurable List widget instead to be able to have a table with column data result on the submission data of the form.

    Check the widget here https://widgets.jotform.com/widget/configurable_list

    Here is the user guide on how to as well.

    https://www.jotform.com/help/282-How-to-Set-Up-the-Configurable-List-Widget

    Let us know how we can be of further assistance.