How to add two headers per column in Spreadsheet Widget?

  • Profile Image
    Asked on July 30, 2021 at 06:49 PM

    The spreadsheet widget is only allowing me to have one header per column. I try to use the Default Value option but the text is too long for each cell.

    Is there a way to:

    • Add two headers per column, or...
    • Upload an existing Excel spreadsheet to a form through a different widget? (The other widgets I found only import data from an Excel file as submissions instead of importing template)

    Please advise. Thank you.

  • Profile Image
    Answered on July 31, 2021 at 05:22 AM

    We would like to apologize for any inconvenience. I'm afraid that the feature of having two column headers in the Spreadsheet widget is not possible. We can try to apply custom CSS codes to style the cells on the first row of the widget to make them appear like column headers but, the default data you will set on the first row cells will still be submitted as entries since it is what the cells on the first row is intended for.

    If you are also looking to embed a spreadsheet on your form, perhaps the workaround explained in this guide might be of help to you — How-to-embed-spreadsheet-in-your-form

    Feel free to let us know if you need any further assistance.