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 results are not formatted - error on open about file type

    Asked by sunilv on September 27, 2012 at 01:38 PM

    We have two forms that ask people to sign up for a mailing list. Both forms are pretty simple as forms go, but when I downloaded the results to Excel and tried to open them, I got an error message:

    "The file you are trying to open, '[name of file]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

    When I click Yes, the file opens with a bunch of odd markings and the formatting is a TOTAL mess.

    I've downloaded excel reports before and never had a problem, so after I downloaded and had the files on my local machine, I deleted all the submissions so as not to have duplicates in the database we are transferring them to. Now, it looks like I may have lost all of my data.

    Is it possible to fix the excel spreadsheet?

    If not, is there a way to retreive my deleted data?

    Page URL:
    http://www.kidney.org/patients/kidneyliving/signup.cfm

    Screenshot
  • Profile Image
    JotForm Support

    Answered by EduardoMendez on September 27, 2012 at 01:47 PM

    @sunilv

    Can you please take a look at this guide.  Is this the method that you used to download your Excell submissions?

    We have noticed a couple of similar concerns today and we are currently looking into it.

    Please follow the avobe guide and let us know the results.

    Thank you! 

  • Profile Image
    JotForm Support

    Answered by EduardoMendez on September 27, 2012 at 01:56 PM

    @sunliv

    After further investigation, I was able to see that our dev team is now looking into this. A ticket has been opened and we'll update your here once it's fixed. Thanks for your patience.

  • Profile Image

    Answered by sunilv on September 27, 2012 at 01:57 PM

    No, I selected the form, then clicked on 'Submissions' and scrolled down and chose the 'Download as: Excel' option.

    FYI, I was able to fix the formatting using Microsoft Excel's Open and Repair option, and choosing to Extract Data. Luckily that worked and the data is now in a usable format.

    Still, it might be something you'll want to look into. I'd be happy to help troubleshoot if you need.

  • Profile Image
    JotForm Support

    Answered by Rodjit on September 27, 2012 at 02:47 PM

    @sunliv,

    Great that you have fixed such issue on your end and thanks for your time giving us another alternative solution to get them fixed. This is a great help for the others experiencing the same.

    Thanks again.

  • Profile Image

    Answered by moonzkie on September 28, 2012 at 09:39 AM

    We are very sorry about this. The excel problem is now fixed.