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

  • Profile Image
    Asked 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***



    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).



    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

  • Profile Image
    Answered 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.


  • Profile Image
    Answered 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
    Answered 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 "".

    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:


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


  • Profile Image
    Answered 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
    Answered on July 26, 2016 at 10:10 AM


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

    Thank you.