Is there a way to change column field names exported to Excel during export process?

  • cpgordon
    Asked on July 10, 2015 at 6:25 AM

    hello - i have created a lengthy questionnaire using jotforms.  For many of the questions, i ask "location" data.  IN the actual form, it is clear which location is being asked, but on the excel download i end up having 20 columns simply labeled "Location 1", "Location 2".......etc.   Is it possible to rename the question fields in jotform so that they have a more unique name?  Such as "Secondary School Location" or something like that?  I DO NOT want to change the title as it appears in the jotform, but rather i want to put my own tag on it so that then it downloads into excel i know which location is which.  Is this possible?

     

    thanks,

     

  • Boris
    Replied on July 10, 2015 at 11:02 AM

    I'm afraid that we do not seem to have such a feature available at this time. The Question / Label is what determines how the Excel column which is populated with data from that field is named.

    Is there a way to change column field names exported to Excel during export process? Image 1 Screenshot 30

    Is there a way to change column field names exported to Excel during export process? Image 2 Screenshot 41

    If you wish to have your Excel columns with different titles, you would need to use a different question/label for these questions on your form.

    I could raise this to our developers as a possible feature request, but I would first like to confirm if I understand your feature request. You would like to be able to rename/re-label the field name during the process of exporting the data to Excel/downloading the Excel submission data. Is this correct?

    Thank you.