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

    blank lines in csv submission file from text area information

    Asked by milbra on July 05, 2014 at 06:26 PM

    I'm using a text area object to collect complete address information from our user. I downloaded submissions as an Excel file, but it only prints the name when I copy-paste into my Word label.  Then I downloaded as csv file.  This time all the information pasted, but there was a blank line between input (see below).  Is there a way to remove these blank lines?


    line 1  (name)


    line 2  (address 1)


    line 3  (address 2)


    line 4  (city, state, zip)


    line 5  (country)


  • Profile Image
    JotForm Support

    Answered by EltonCris on July 05, 2014 at 08:44 PM


    You can manually remove it on your editing application like notepad or to Ms Excel. Sometimes when you copy text from another source, the 3rd party app will automatically add formatting. I'm not sure if there's anything we can do about it here but if you need further assistance with removing the lines on your CSV submissions, we'd be happy to assist.

    Thanks and Regards!