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

    Bug - Excel file gets auto-appended with XLSX.XLS when opened

    Asked by gibetom1979 on March 24, 2014 at 06:29 PM

    hi

    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

    Page URL:
    http://brusselskinokab.com/inscriptions/

    problem office and
  • Profile Image
    JotForm Support

    Answered by jonathan on March 24, 2014 at 07:56 PM

    Hi,

    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.

    Thanks.

     

    -How-to-Partially-Download-Form-Submissions-as-Excel-CSV-PDF

     

     

  • Profile Image

    Answered by gibetom1979 on March 25, 2014 at 08:47 AM

    hi

    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

     

    thanks

  • Profile Image

    Answered by jedcadorna on March 25, 2014 at 10:45 AM

    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.

  • Profile Image

    Answered by gibetom1979 on March 25, 2014 at 01:20 PM
    hi
    before the excell report was a .xls. now they are .xlsx.xls
    here my screenshot of the CVS report on open office
    thanks
    2014-03-25 15:45 GMT+01:00 JotForm Support Forum :
    ...
  • Profile Image
    JotForm Support

    Answered by TitusN on March 25, 2014 at 03:11 PM

    Hello,

    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 download it free from here.

    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.

  • Profile Image

    Answered by besam on March 28, 2014 at 06:36 AM

    Hi

    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 !!!  

  • Profile Image
    JotForm Support

    Answered by TitusN on March 28, 2014 at 06:52 AM

    Hello @besam

    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.

    Thanks.

  • Profile Image

    Answered by LRG on March 28, 2014 at 09:46 AM

    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?

     

  • Profile Image
    JotForm Support

    Answered by KadeJM on March 28, 2014 at 11:24 AM

    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.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on March 30, 2014 at 03:45 PM

    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

    Kind regards

  • Profile Image

    Answered by gibetom1979 on March 30, 2014 at 03:51 PM

    the problem is solved

    it's working with openoffice without problem

    thanks you

  • Profile Image

    Answered by LRG on March 31, 2014 at 08:38 AM

    Fixed with Excel as well. Thanks

     

  • Profile Image

    Answered by shirleythomas533 on October 21, 2014 at 06:14 AM

    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.