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

    Import data into JotForm with .xls

    Asked by sudsport on December 21, 2014 at 01:18 PM

    Hi,

    The option to import .xls file is giving errors when the header line is exactly the same as for a CSV import, although it does import records, the status report doesn't show it:

    I do not know what are the missing headers.

    Could you help.

    Thanks,
    Georges

    Page URL:
    http://form.jotformpro.com/form/43544844930964

    JotForm import data uploads CSV jpg
  • Profile Image

    Answered by val on December 21, 2014 at 03:47 PM

    Hi,

    Sorry for the trouble caused to you. Could please try clear your browser cache and your form cache.

    Here is the guide on how clear your browsers cache:

    http://www.wikihow.com/Clear-Your-Browser%27s-Cache

    Here is the guide on how to clear form cache:

    http://www.jotform.com/help/229-How-to-Clear-your-Form-Cache

    Also, try this our other importing submissions:

    http://www.jotform.com/import-submissions/

    Hope this help.

    Thanks.

  • Profile Image

    Answered by sudsport on December 22, 2014 at 05:14 PM

    Hi Val,

    Thanks for the proosed solution on "clear cache", the import is now workin properly be it from CSV or XLS files.

    The only Issue I have with XLS is on characcter set where my letters with accentes "é" are translated into �, so I will use the CSV where i am requested to define the characters set UTF8 I am using.

    Thanks for your help,
    Georges

     

  • Profile Image

    Answered by Carina on December 22, 2014 at 05:56 PM

    On behalf of my colleague you are most welcome. You can consult this guide for more information on how to change character encoding. 

    Let us know if you need more assistance.