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

    Excel headers with multiple values below?

    Asked by CaepeSchool on September 05, 2014 at 10:28 PM

    Hi!

    I need to customize my forms output. As it is now, each field creates a new header in the Excel output. I would like it to give me one header, with all entries matching that field name below it.

    For example, if I have a form that requires names, phone numbers, and email addresses of multiple people, I would like one heading that says "Name" and all the names that were submitted (within the same form instance) below it, then another column with the heading "Phone" with all those entries below, etc. Not from multiple forms, but all from the same form.

    So the form looks like this:

    Name: [text field]

    Phone: [text field]

    Email: [text field]

    -----------------------

    Name: [text field]

    Phone: [text field]

    Email: [text field]

    -----------------------

    Name: [text field]

    Phone: [text field]

    Email: [text field]

    -----------------------

    And the output in Excel looks like this:

    Name              Phone               Email

    Joe Smith        555-555-1212    joe@joe.com

    Suzie Jones     222-222-1234    suzie@gmail.com

    Etc.

    Hopefully that makes sense. It's kind of hard to explain in text.

    Any help you can provide would be much appreciated! 

    Thanks!

    John

    excel My Forms text field heading name
  • Profile Image
    JotForm Support

    Answered by EltonCris on September 06, 2014 at 05:04 AM

    Hi John,

    I think any of these widgets fits your requirements. What makes it more advantage is that the fields are dynamic, users can add as many entries and they want by clicking adding more fields button.

    http://widgets.jotform.com/widget/configurable_list

    http://widgets.jotform.com/widget/infinite_list

    If you need further assistance, let us know here.

    Regards!

  • Profile Image

    Answered by CaepeSchool on September 07, 2014 at 08:51 PM

    Thanks for your response! 

    I tried both widgets, and neither works to do what I need. When exported to CSV or XLS, all the information for each entry is put into one cell. 

    No widget I've tried so far ever produces more than one row on the output. It doesn't help us if all the data is on a single row.

    Any other ideas? I appreciate you looking at it!

    John

  • Profile Image
    JotForm Support

    Answered by EltonCris on September 07, 2014 at 11:30 PM

    Hi John,

    Sorry, I think I have misunderstood your question on the first place. I thought you were referring to a table format within your form not on Excel.

    Unfortunately, none of the table reports can be formatted according to what you desire even when you use Matrix table. I'm afraid there's no solution for this unless you manually customize the result using your Excel program.

    You can also use this workaround on how to move multiple cell values into different columns. http://www.jotform.com/answers/409905

    Thanks and my apologies for any inconveniences caused.