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

    When exporting collected information can we select a pipe delimited format?

    Asked by sunilv on October 12, 2011 at 10:16 AM

    Is there a way to export this information in a way that does not use the comma as the delimiter?

  • Profile Image

    Answered by fxr on October 12, 2011 at 01:22 PM

    Hello Sunliv.

    Unfortunately, JotForm in its current form doesnt allow user specified delimiters when exporting submissions to csv format.

    I could pass it on to the developers as a feature request. Its just not a request I have seen before, so its unlikely to be priotised. 

    Can I ask you why you want to use a specified delimiter?

  • Profile Image

    Answered by sunilv on October 13, 2011 at 01:35 PM

    Hi fxr,

    We are hoping to take the data exported from jotforms and imported into a tracker in our own database. The use of csv, especially in the case of addresses that utilize suite #'s or apartment #'s where people often use commas would throw off the entire excel table by one column based on whether or not the comma is used. In this case I selected the pipe because it would most likely never be used on any of Jotform questions.

    Thank you very much in advance for your time.


  • Profile Image
    JotForm Support

    Answered by NeilVicente on October 13, 2011 at 01:45 PM


    Having worked with data collection, I understand how useful it would be to be able to specify the delimiting character when exporting a CSV-formatted database file. With that in mind, I have forwarded your request to our developers.

    Take note, however, that requests do not get granted so easily, especially since the current workload of our developers is quite heavy. In any case, we will let you know if there is any movement on the status of your request.