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

    2.3 When exporting data to Excel, I wanted to transpose the sheet, however an error message said, that some fields were longer than 256 characters.

    Asked by 1417268 on February 02, 2017 at 08:03 AM
    2.3 When exporting data to Excel, I wanted to transpose the sheet, however an error message said, that some fields were longer than 256 characters.
  • Profile Image
    JotForm Support

    Answered by seth on February 02, 2017 at 08:19 AM

    Hello,

    I couldn't understand your query since we don't have an transpose option on exporting to Excel. Also the error is related to the capabilities of Excel. There are workarounds in excel to handle this error but these workarounds need manual manipulation of the file while using formulas. Here are some threads about the issue;

    http://stackoverflow.com/questions/13202473/way-to-overcome-excel-vlookup-function-limit-of-256-characters

    http://stackoverflow.com/questions/12386414/excel-use-formula-longer-that-255-characters

     

    I hope this answer helps. Please don't hesitate to contact us for your further queries.

    All the best!