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

    Changing Excel & CVS Spreadsheet time stamp options

    Asked by WCAA2012 on December 02, 2014 at 04:05 PM

    When I upload an xlsx or cvs file of survey responders, the timestamp in the cells looks like: 2014-12-02 14:20:23

    When I click in the cell to edit it, (in xlsx or cvs format, using google docs or office libre) it looks like: 12/2/2014 14:20:23

    After I save the file to xls, the type of file my database can read, the date stamp stays 2014-12-02.

    For the purposes of uploading the data to my database using scripts, I need the date format to be in forward slashes "/" instead of " - "

    ...any advice?


  • Profile Image
    JotForm Support

    Answered by Mike_T on December 02, 2014 at 05:39 PM

    Thank you for contacting us.

    You can easily change the date format on downloaded .xlsx file via Google Spreadsheets and Microsoft Excel. Unfortunately, the Google Spreadsheets service does not support saving with the .xls format anymore, but it is supported in Microsoft office.

    Can you check if this is possible to change the date format and save the file as .xls in LibreOffice?