Excel results are not formatted - error on open about file type

  • Profile Image
    sunilv
    Asked 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?

  • Profile Image
    EduardoMendez
    Answered 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
    EduardoMendez
    Answered 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
    sunilv
    Answered 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
    Rodjit
    Answered 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
    moonzkie
    Answered on September 28, 2012 at 09:39 AM

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