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.
When exporting my data to excel or CSV the date format is long format and cannot be sorted. Is there a way to fix?Asked by layafl on July 22, 2011 at 01:21 AM
When form submissions are exported to Excel or CSV format the dates are in long (non-comma separated) format (example - March 23 2011). These cannot be converted into a sortable format in Excel. Excel required a separating comma between day and year. (example March 23, 2001). Once it has this separating comma it can convert to short format MM/DD/YY which can then be sorted by age. We have found that we need to go into the report and add a comma to each and every submission before we can sort data.
More information: We use these forms to collect community team sports registrations. This is done for several age groups/teams simotaneously. This data then needs to be sorted to determine which age group the player will be in. We have tried having submitter choosing an age group but have fount this to be inaccurate. So we request child's DOB and were hoping to sort with this field to determine which age group they were in. That is - until we ran into the issue I stated above.
excel CSV format Submissions
First of all, thank you for using JotForm.
Unfortunately, JotForm currently does not have this feature. However, I do get how this could be useful. I've already added this to our feature request list and hopefully, our developers can include this in the near future. The best thing that you can do for now is to sort the data in JotForm itself.
Go to your form's submissions, and click the Birth Date. This will automatically sort the data for you in JotForm.
If you have further issues, please feel free to contact us.
Albert | JotForm Support
Has this been added? Can we export csv in a more standard format. ie yyyymmdd. I don't need it for sorting but for converting to another program.
Kindly open a new thread for your inquiry,You can create your new thread using this link http://www.jotform.com/contact. so we can better track the issues, requests and solutions users are having. Also, to assist you better and avoid confusion.Thank you and looking forward to assist you.