JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Is there a way to change column field names exported to Excel during export process?Asked by sjpd on May 15, 2015 at 04:22 PM
I'm migrating from Adobe FormsCentral. In FormsCentral I was able to re-label column-names (field-names) in the view where submissions are reviewed online. This gave me a way to shorten the resulting column-names in exported Excel spreadsheets. (as opposed to column names that are the entire text of a check box label).
Is there some way to shorten the column names that get exported to Excel? Or substitute the field-name for the label text?
So basically you want to change the column names of your Excel report. Is that correct?
Unfortunately it is not possible to change the column name of Excel report during exporting from JotForm. There is no possibility to define new name of columns inside of JotForm.
I could only suggest that you change it manually after exporting.
Hope this will help. Let us know if you need further assistance.
Changing the column name in Excel would be a good suggestion, except that we will be downloading and importing from Excel into an Access database application, repeatedly. So we must map the Excel column names to the Access database.
FormsCentral provided a very nice feature where the column name could be independently edited in the View Submissions display and stored permanently. These alias names were mapped to the original field names transparently, behind the scenes at Adobe.
I suggest that Jotform field names that must be the entire text of a label for a checkbox, is an onerous and inelegant column name in Excel or CSV exported file.
I would see it as an improvement of Jotform could add a feature to allow column name alternatives or aliases in the exported data files. For the alias column names to be useful, they would need to be stored and persistent between successive exports to Excel.
I will submit a feature request ticket to our higher team support base on the details you mentioned.
The feature will be about the capability to rename/re-label the field name during the process of exporting the data to Excel.
I cannot provide you any time frame on the ETA but we will notify you here for any news/updates on the progress of the request.
Thanks. I've developed a rather cumbersome but effective work-around for shortening column names for radio buttons and check box labels.
I inserted a "text" field above the check box to act as a pseudo label, and set a shortened width in the CSS to leave room for the check box/radio buttons..
Then I renamed the label text of the checkboxes and radio buttons to a useful, short column name for use in the spreadsheet.
And I set the CSS for that abbreviated label to hide it from the form:
This hides the label, and allows the new adjacent text field to substitute as a pseudo label.
Both the label field and the checkbox field need to be set to "shrink" so that the label will appear on the same row as the checkbox or radio buttons.
It's a kludge, and it takes a lot of effort, but it works.
Glad to hear that you found a workaround to change the column names in question and achieve your purpose!
As my colleague jonathan has said, a ticket has already been raised to create a functionality that will save you a lot of effort. However, we cannot assure you of any timeframe. We will update you as soon as this is worked out.
I have moved your vote on a separate thread so we can also escalate a feature request ticket for you and also to add up to the number of user who request the same feature. You can check the thread here: http://www.jotform.com/answers/719204.
Do let us know if you need further assistance.
+1 to this feature. I just sent a ticket about that.
I could use column alias to have many forms and have more flexibility over the label caption. As of right now, I must have the label name the exact same for every form that I have and it's really time consumming.
I don't completly understand what sjpd said about having a hidden textbox above the other control and having it hidden. What will it do on the excel report? Create an empty column with desired alias?
you then look for alias name and offset +1?
Please include me on the list of distribution for this feature and if someone could assist me on having an alternate solution, I would really appreciate.
We will attend to your own thread about this here https://www.jotform.com/answers/819971