How to Import Your Excel or CSV Data into JotForm

This was helpful, but can you please add something about the fact that the date format must be

YYY-MM-DD hh:mm:ss (that is what was written in my thread, but I think it should be YYYY correct?

I also learned that with CSV the columns headers and data should always be in double quotes however with the Excel sheet the data should be without double quotes. This should be added to this helpful guide as well.

Anyway, thank you and maybe you will help others if you add these 2 things to your guide.

Emily W

Hello Emily - You are absolutely correct. We will consider adding this inputs into the guide, but you have already helped others by leaving this comment. 

We also provide samples of data format when you select the form to upload submissions to, so you can check submissions before importing:

If we can be of further help, please let us know.

Thank you!