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

    The labels of matrix field are truncated when exported to excel report

    Asked by sturdysurvey on March 19, 2015 at 03:17 PM

    When exporting submissions to Excel or CSV, the text of the Row labels within a Matrix response get truncated, with the trailing text replaced by an ellipsis (...).

    Is there any way to get the full text of each Row label to be included in the output?



    This is a re-post of a comment on How to View Form Submissions

    excel CSV
  • Profile Image
    JotForm Support

    Answered by Kiran on March 19, 2015 at 07:14 PM

    I see what you mean by the truncating the labels. I think this should have been done by purpose to limit characters in the heading like display width limitation, reducing load during export, etc. It may be possible to increase the character count. 

    However, let me check with our next level support team to see if this can be increased further. I cannot promise you that it'll be implemented or any time frame.

    If there is any update in this regard, you'll posted through this thread.

    Thank you!

  • Profile Image

    Answered by sturdysurvey  on March 19, 2015 at 07:22 PM

    I can see merits to limiting the length within the headings during export, but this behavior doesn't seem to be consistent with how other questions are exported.

    The ideal resolution may be to allow the form creator to choose whether (all?) questions should be truncated or not.  Since that could require a bit more programming, it would probably at least be helpful if all questions were treated consistently.

    (This was brought to my attention by a user who was concerned about not being able to see the whole question when analyzing the results.)

    Thank you for checking into this!

  • Profile Image
    JotForm Support

    Answered by EltonCris on March 19, 2015 at 11:49 PM

    @sturdysurvey 

    Thanks. This has been submitted as a feature request by my colleague. Once this is implemented, we'll update you here right way.

    Thank you for using Jotform!