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

    Some Fields are Coming More and Empty Data When I Try to Import a Submission from a Excel File

    Asked by Kailash108 on January 28, 2016 at 07:45 AM

    In this app it is written:

    ".xls template format"

    I tried many times an it was not working. When I changed the file to .xlsx, it worked.

    ***So it is written wrong***

    Questions:

    1.)

    When I import 88 submissions, it will import 253. These extra rows are empty except the column for submission date (and ID and Submission ID when exported again).

    Why?

    2.)

    The Date is destroyed when imported from Excel.

    What to do?



    This is a re-post of a comment on Import App: Easily import your Excel or CSV data into JotForm

    Submissions excel template app
  • Profile Image
    JotForm Support

    Answered by mert on January 28, 2016 at 10:28 AM

    Hi there,

    For your first question, 

    In your Excel file, how many records do you have? If there are more than 88 records and they have empty value, the result could be like yours. Also, please check the format of the data, some syntax error also could cause this error.

     

    For your last one, If the data format of the "Date" field from the Excel file does not match with the template, it could let to that results.

    In this case, I suggest you to use CSV file format and please check the data format from the following image:

     

    For further assistance, please do let us know.

    Thanks.

  • Profile Image

    Answered by Kailash108 on January 28, 2016 at 07:51 PM

    This app is very far from user friendly!

    csv import impossible.

    Toke me hours to fix the "" and the | in the date

    but not at all possible to import it.

    I have to give up.

    Waste of time!

  • Profile Image
    JotForm Support

    Answered by mert on January 29, 2016 at 04:45 AM

    Unfortunately, there is no other way to import Excel or CSV data into your form and also, the format of the data is very important. Without correct format, the problems like you have already experienced can be occur. Also, default format of the CSV file should be similar with the example on "http://import.jotform.io/".

    In addition, if you have a Excel, HTML file and you want to convert it to CSV with correct formatting, you can use the tools like the link below:

    http://www.convertcsv.com/csv-viewer-editor.htm

     

    If you need to now more, we are always here to help you.

    Thanks.

  • Profile Image

    Answered by kn2011 on July 26, 2016 at 08:30 AM

    I have tried your convert tools (link)  All went successfully with 46 submission, but in my
    submission views - only the first column is not blank (Submission date) all 8 others columns is empty.

     

  • Profile Image
    JotForm Support

    Answered by Charlie on July 26, 2016 at 10:10 AM

    @kn2011

    I have opened a separate thread for your concern, this is for us to better assist you. Please refer to this link instead: https://www.jotform.com/answers/890636. We will address it shortly.

    Thank you.