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

    Values in widgets are inserted in one column in Excel report

    Asked by Kailash108 on May 20, 2015 at 03:04 PM

    And there is one more thing which is extremely irritating: Most answers collected from Widgets go into one column in the Excel export.

    It is extremely difficult to separate these into different column. And the headings of the question is also in the same column.

    This reduces the benefit of your service a lot!

    I spend like two weeks (not 2 minutes!) working with the forms and when it is done I check the export and see that everything is messed up there.

    To provide a useful Export of data you should make your priority #1

    There is a free Service which is called LimeSurvy, there are some bugs there, but the Export of data is excellent. You should check it out.

    There are several severe issues with the export.

  • Profile Image
    JotForm Support

    Answered by Charlie on May 20, 2015 at 03:23 PM

    Hi,

    Most of the widgets, especially those that have multiple entries on them are designed to be one item or one field, that's the reason why it is being inserted in the Excel report as one cell in one column.

    We could forward a feature request on the changes that you would like to apply in the Excel report, but we'll need more details of it so that we can pass it to our developers. Also, I'm unable to guarantee that the changes will apply soon or if it will be considered, it depends on the developers priority tasks and list of work that they have. But rest assure that they'll be aware of the changes that you are requesting.

    Could you give us the widgets and how the values on them should be displayed in the Excel report? This will help us focus better on where to start. We'll wait for your response.

    Thank you.