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

    CSV file download and changing column headers in the csv file

    Asked by BlastTrashCan on May 16, 2017 at 07:43 PM

    hi.  i want to know if i'm able to change the column headings in the csv file download or do i have to do this in the form and the form must match exactly?  I am hoping that I can change the column headings so that I can upload into Jobber from Jot Form

     

    here's a video that shows what I'm talking about:  https://screencast.com/t/gr9i5jPI4fr

  • Profile Image
    JotForm Support

    Answered by EltonCris on May 16, 2017 at 08:41 PM

    Hello there!

    Thanks for providing a very detailed video explanation.

    To answer your question, it is possible to edit the CSV file you downloaded from JotForm. However, editing the CSV must be done on your side using any apps that would allow you to edit CSVs. Example, a notepad app or this one perhaps? Since I can see that you're using Mac. If you also have a similar app like MS Excel, it would help.

    So basically, the first thing you have to do is to export your form submission to CSV. Here's how: https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    After that, open and edit the CSV file using the app you prefer. In the following screenshot, I was using MS Excel since it is a lot easier to edit the field column names but I'm sure you can do the same in your app. :)

    After that, save all the changes and upload it anywhere you want it to import.

    Let us know if you have further questions about this. Thank you!