I want such a report where label of field should not appear in excel

i want such a report where label of field should not appear in excel file.only actual data should appear in excel file.when i use some widget the label appear with data.so i want to avoid that.how to do that while generating reports.

Hello nilwarnds,

Can you kindly tell us which widget do you use so we could check it closer?

Field labels are shown on 1 row at excel reports, so I can suggest removing that row.

We will gladly assist if you need more help.

 when i use address field its sublabels such as street ,city,pincode appear in excel sheet.so i dont want those to appear.i am also using matrix dynamique.in this also sublabels appear in excel sheet.so iwant only data to appear.any help in this regards.

When the Excel report is created by default each of the Address field sub-labels will have its own column. The only way to remove them from Excel file is to do it manually, once you download the file. It is the same for Matrix dynamique widget.

As a possible workaround, you can add an additional field to your form, for example Long Text Entry field, and pass the data from Address field to that field. The new field can be hidden on the form but it will be shown inside of the report. Then you can omit the Address field from the report.

How to Pass Field Value to Another Field?

Here is an example for Address field and Matrix dynamique widget.

Here is my demo form: https://form.jotform.com/80921336040952 

You can clone it and then test your cloned form. 

Hope this will help.