JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Issues in the generated Excel file of form submissionsAsked by ImagesAlberta on April 14, 2015 at 03:27 PM
I have a form called Annual Competition - General. I downloaded an excel report on Sunday to check it and it was fine. I did not change the form . I needed the report on Monday - by 3:00 PM. On Monday the report had data in the wrong report columns, perhaps due to empty fields on the form. I tried multiple reports, and tried removing quotation marks from my form. No luck. It took two people 4 hours to reconstruct the report from email notifications. As we use Excel VBA code to transfer data from your reports into our worksheets, you might imagine data in the wrong columns is not the best situation. It would "help me better" if this doesn't happen again. to be fair, it has not happened before, with my other forms which often report user leaving some fields blank.
I think that in one case, even the top header of the form had errors / garbage.BTW - the email address control sometimes drops characters. I don't believe user error.
Our apologies. We have an issue with Excel and CSV report yesterday and this problem could be related to it. Our developers made an update and fixed it already. I did try it in your form and everything is fine. Please try again and let us know if the generated excel file still gives you some issues.
If there are errors, please take a screenshot and post it here so we can submit it to our developers for further review.
For the email address issue, will take care of it here: http://www.jotform.com/answers/552590.