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 Spreadsheet not opening

    Asked by PiccadillyMarket on January 30, 2015 at 11:42 PM

    Hi

    I am unable to open a spreadsheet in Excel which is very frustrating. This happened last year and you directed me to use Zoho but that is time consuming and annoying.

    Could you let me know what may be causing the issue.

     

    Janina

     

     

    Page URL:
    https://secure.jotformpro.com/form/43472645857971

    Screenshot
    excel zoho open Excel spreadsheet
  • Profile Image

    Answered by Ben on January 31, 2015 at 05:32 AM

    I am sorry to hear that you are having these issues Janina, but could you please tell us the filesize of the excel file when you download it?

    I have just downloaded all submissions for that jotform and I am able to open the Excel and CSV files without any issues.

    Could you please try downloading the Excel and CSV files and check their file size.

    Also, if you can not open them with Excel, could you please try opening them with Google Spreadsheet instead?

    Knowing more about it, by following the steps above will help us find and resolve the issue for you.

  • Profile Image

    Answered by PiccadillyMarket on February 01, 2015 at 05:00 AM

    Hi

    File size is 69.6.

    I opened in google then uploaded to excel successfully from there. Why would that be?

    Very odd that I cant do directly.

    Janina

     

     

  • Profile Image

    Answered by Sean on February 01, 2015 at 01:43 PM

    Hello PiccadillyMarket,

    I downloaded the file and I was able to open it just fine as well. The size of the file was 69.7KB also. If I am not mistaken you said that the excel file opened just fine in Google Spreadsheet? It is possible that there might be a glitch that is causing the excel file to generate that error when opened in Open Office. Which version of Open Office are you using? Please verify that the excel file opened just fine in Google Spreadsheet. Looking forward to your response. 


    Cheers!
    Sean

  • Profile Image

    Answered by PiccadillyMarket on February 01, 2015 at 06:40 PM

    Totally fine in  google spreadsheet

    I have tried 2 different computers and it wont open in Excel. Its office 2008.

    I have tried another jotform spreadsheet and it opens so it is a bug in that particular form I think.

     

  • Profile Image
    JotForm Support

    Answered by ashwin_d on February 02, 2015 at 01:59 AM

    Hello Janina,

    I'm sorry for the trouble caused to you.

    I did try to download your form's submission in excel and I am able to replicate the issue you are having. Please check the screenshot below:

     

    There seems to be some unreadable content (like special character) in your submission data which is causing this issue. I did try to find our the problematic submission record but couldn't do that.

    I am reporting it to our back end team. We will get back to you as soon as we have any update form them. For now, I would suggest you to open the submission excel in google spreadsheet or integrate your form with google spreadsheet.

  • Profile Image
    JotForm Founder

    Answered by aytekin on February 02, 2015 at 10:57 AM

    We created a bug report about this and we will look into it as soon as possible. Please use the CSV option for now. CSV export also opens in MS Excel just like Excel export.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 10, 2015 at 04:13 AM

    Hello Janina,

    I have just been able to identify and fix the issue as it was pretty much obscure. We have tested it and there shouldn't be any problem downloading submissions now.

    Kind regards

  • Profile Image

    Answered by PiccadillyMarket on March 10, 2015 at 05:28 AM

    Thank You sooooo much.

    I just tested and it is opening fine. I had just given up so that was a nice surprise.

    Janina

     

  • Profile Image
    JotForm Support

    Answered by ashwin_d on March 10, 2015 at 08:09 AM

    Hello Janina,

    On behalf of my colleague, you are welcome.

    I am glad to know that your issue is resolved.

    Do get back to us if you have any questions.

    Thank you!