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 App: Dates not importing correctly

    Asked by stevedellar on March 19, 2017 at 02:37 PM

    I imported one record into https://eu.jotform.com/submissions/60492174138355 using your import.io ap

     

    I ended up with over 400 imported and the dates are not correct.

     

    Here is the link to the data to be uploaded 

    https://docs.google.com/spreadsheets/d/19LpFZXNDpcOdJdQiubK-Y0VIIFbfBeJot7zLSdrPljI/edit?usp=sharing

    Can you help

     

    Cheers

     

     

  • Profile Image
    JotForm Support

    Answered by Mike on March 19, 2017 at 03:37 PM

    Excel stores dates as sequential serial numbers, so this might be a reason of the issue. Our import tool cannot convert those serial numbers to the dates.

    Please try with dates formatted as a Text. It should help with the import.

    The empty form entries are most likely corresponding to the empty spreadsheet rows.

    If you need any further assistance, please let us know.

  • Profile Image

    Answered by stevedellar on March 19, 2017 at 04:18 PM

    With excel you cannot remove empty rows.  

     

    This is having an impact on my download limits

  • Profile Image

    Answered by stevedellar on March 19, 2017 at 04:26 PM

     

     

     

     

     

     

     

  • Profile Image
    JotForm Support

    Answered by Welvin on March 19, 2017 at 04:45 PM

    You should have the option to delete empty rows in the excel file. 

    http://www.techrepublic.com/blog/microsoft-office/a-quick-way-to-delete-blank-rows-in-excel/

    You seem to have provided us a screenshot. Unfortunately, it failed to appear on this forum. Please note that we cannot accept inline attachments. You have to access this thread, click the image tool to upload, as per our guide here: https://www.jotform.com/answers/277033