- sunilvAsked 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?
- JotForm SupportEduardoMendezAnswered on September 27, 2012 at 01:47 PM
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.
- JotForm SupportEduardoMendezAnswered on September 27, 2012 at 01:56 PM
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.
- sunilvAnswered 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.
- JotForm SupportRodjitAnswered on September 27, 2012 at 02:47 PM
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.
- moonzkieAnswered on September 28, 2012 at 09:39 AM
We are very sorry about this. The excel problem is now fixed.