Hi, I'm looking for a way to have the spreadsheet widget keep its formatting when integrating/exporting the results

  • Profile Image
    mdahlgren
    Asked on November 03, 2021 at 02:28 PM

    Currently, the spreadsheet gets turned into one huge row. I'd like to keep the format of the spreadsheet widget, and have it create a new sheet within my worksheet for each response. Is this possible? If not, is there an automatic way to have the results keep their formatting with excel/sheets? I would really like to keep the format of the spreadsheet widget from jotform.

    Also, the spreadsheet widget gets turned into a huge row when you export the response to excel from your inbox as well, despite it looking fine in the inbox. If there is a way to deal with this, or if a different widget addresses this, that would be greatly appreciated.

    Thanks!

    (I attached a picture of what the ideal outcome would look like)

    Screenshot
  • Profile Image
    Karl_B
    Answered on November 03, 2021 at 05:07 PM

    @mdahlgren

    in order to copy the format of your existing excel follow these steps.

    Right-click on your tab you want to duplicate/move or copy.
    1635973128_6182f808ed8cd_

    Click Duplicate and it will Duplicate your sheet.
    If on your end showing Move or Copy > Click Move or Copy
    Pop Up box will appear

    To Book:
    (New Book)
    1635973589_6182f9d5e35f1_
    Thick [/] Create a copy
    Then Click Ok




    Hope this helps! :D
    If you have further question/s don't hesitate to post it on our Support Forum.

    Ken™




  • Profile Image
    mdahlgren
    Answered on November 03, 2021 at 05:32 PM

    Hi,

    I'm not sure that quite answered my question. I was wondering if when you click download all on the left side above the submissions, you can keep the formatting shown in your inbox. As of right now, it returns the information like the bottom picture, which is not what I want. Instead, I want the spreadsheet from the form to be translated into google sheets/excel similar to the picture I first posted.

    If this could be done automatically through google sheets/excel integration that would be the cherry on top, but being able to download the submission is my main focus.

    (I'd like to try to keep the formatting similar to this picture)1635974528_6182fd8087bac_examplee.png

    (This is how the response is downloaded from jotform)1635974642_6182fdf2cb1d8_

    Thanks,

    Mikio

  • Profile Image
    Cecile_A
    Answered on November 03, 2021 at 10:24 PM

    Hello Mikio,

    I can see that you're referring to the input table. Unfortunately, once the submission is downloaded, the input table format is not retained.

    1635992135_61834247557ca_14.png

    The same case happens when you integrate your form with Google Sheets too.

    1635992227_618342a3a8d70_15.png

    Instead of using input table, you might consider using Spreadsheet widget.

    1635992396_6183434c0e488_16.png

    Below is the format of the submission once downloaded as Excel file.

    1635992505_618343b9b84ab_17.png

    1635992548_618343e412aaa_18.png

    If this won't work for you, please let us know so that we could escalate this as a feature request.

    Thank you.

  • Profile Image
    mdahlgren
    Answered on November 04, 2021 at 12:44 PM

    Thank you! That is closer to what I'd like, and I can definitely work with it. I would ideally like to retain the cells from the form, but I can see that it would be difficult to manage that while keeping the label.
    Either way, thank you for your help and I will definitely try out the spreadsheet widget.