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.
Bug - Excel file gets auto-appended with XLSX.XLS when openedAsked by gibetom1979 on March 24, 2014 at 06:29 PM
when I do a excell report, the created files is a .xlxs.xls, wich is not readable on my open office
I do some report this mornig, and there was no problem, is there some change you do?
thank you for your answer
Perhaps the Excel version is not supported by your open office application.
You may want to try downloading the submissions in CSV version instead.
Most spreadsheet application will be able to import CSV file formatted data. In this case, your open office application should be able to do so also.
Hope this help. Inform us if issue persist.
indeed the excel version is not supported by open office, but before it was ok, for an other form I deed some export and its work so good :(, did you change the excell version?
in the CVS export de input are not in the right case/column, I've got th name and a part of the phone number, and in the next colomn the rest of the phone number and the debut of the street adress.
I continue trying other report to find the good one
I don't think that the version was change. Do you get any error message when opening an excel in open office? I will try to download a latest version and will let you know if I was able to open excel or not. About csv file can you send us a screenshot of how the fields are aligned?
Will send you feedback about excel once i'm done downloading the file and tested it on my end.
before the excell report was a .xls. now they are .xlsx.xls
here my screenshot of the CVS report on open office
2014-03-25 15:45 GMT+01:00 JotForm Support Forum :
Yes - the excel export was upgraded recently.
Try using Libreoffice - Its a relative of Open Office - uncannily similar if not the same projects.
You can also try integrating your form with Google Spreadsheet - if just to manage your form responses. Here's how to do it.
Let us know if this helps.
I have the same problem as gibetom1979.
We are using our Excel reports for many years now and working with OpenOffice. We're glad to use this.
Moving to another program is not possible cause too many people involved and from IT regulations not able to install other programs...
=> Please will it be possible for you guys to tweak the reports again so they will be able to open in excell but ALSO in OpenOffice as they were before.
Many many thanks !!!
Please tell us about it on a new support request - That way your issue is prioritized.
You can create one by clicking on this link.
Here is the problem: when one downloads their submission report in Excel format, the file name has the extension .XLSX ... except the file type is Microsoft Excel 97-2003 Worksheet, which means the file extension should be .XLS (no X at the end).
So when Excel tries to read the file, it's confused since it's a 97-2003 file but has the newer file extension at the end. Therefore, I get this warning message every time: "The file format and extension of 'filename.xlsx.xls' don't match. The file could be corrupt or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?" ... I can click Yes and it opens.
I imagine this is why people who are not using Excel are having problems.
I have only noticed this happening in the last 2-3 weeks. Do you know when this will be fixed?
Thank you for pointing that out. I tested this and even in the latest version of MS Office I could see this gets appended incorrectly. I think this is probably due to a minor problem with the XML Header inside it that is probably causing this. We will have our dev's look into this problem asap.
This problem should have been fixed. Unfortunately I don't have OpenOffice to test it. Could you please let me know if the issue is totally resolved?
Thank you for your help
the problem is solved
it's working with openoffice without problem
Fixed with Excel as well. Thanks
If your Excel file (. XLS and .XLSX) is not being open properly in your system than file may be corrupt or damaged by virus or other reasons. but you no need to care because you can use your file properly by using Kernel for Excel file repair tool. this tool supports all versions of MS Excel and Windows 95/98/2000/2003/XP/7/8. Visit us for free trial version.