How can I download data into Excel where I can manipulate how it is downloaded?

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

  • Profile Image
    jonathan
    Answered 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.