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 Export Problem: Unique ID is incorrect

    Asked by sdhxcs on April 22, 2014 at 12:40 AM

    Just from late this afternoon, I found an issue with Excel export. There's an Unqiue ID field in my form with a format of 2014_xxxx (such as 2014_2987), and in the Excel it only keeps first four numbers 2014, and the rest is gone. However, in csv the field seems to be correct. Would you help me resolve this issue? 

    Also, I realized before some fields with numbers were treated as text, now in Excel they all have been converted to number. (My Excel options settings do not allow auto conversion). 

    BTW, the Excel file size is also smaller than before even with more submissions.

    problem excel CSV format settings
  • Profile Image
    JotForm Founder

    Answered by aytekin on April 22, 2014 at 03:22 AM

    Opened the bug ticket. We will fix this problem and get back to you.

  • Profile Image

    Answered by sdhxcs on April 22, 2014 at 10:34 AM

    I just exported a new Excel spreadsheet this morning, and the problem seems to be gone now. All numbers exported as text and Unique ID is correct. Thanks!

  • Profile Image

    Answered by sdhxcs on April 22, 2014 at 11:21 AM
    Yes, it's fixed. Thank you so much!
    ...