How to export data in different columns of Google sheet when exporting from Configurable List widget

  • Hugo Ramos
    Asked on February 3, 2024 at 2:04 AM

    How to export all the information to Google Sheets in separate columns and not all in the same column/row?

  • Rahul JotForm Support
    Replied on February 3, 2024 at 4:16 AM

    Hi Hugo Ramos,

    Thanks for reaching out to Jotform Support. Unfortunately, when a Configurable list widget is used, the data will be exported to Google Sheet as a single field. So, it is not possible to display the data in different cells of Google Sheet. As a workaround for that, you can use normal form fields instead of the configurable list widget. While the feature you’re looking for isn’t currently available, rest assured we’re always working to add new services and features to Jotform. I've gone ahead and escalated your request to our Developers. When or if it's implemented depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know.

  • hugoramos83
    Replied on February 5, 2024 at 5:54 AM

    thank you for the feedback. It´s a must have solution in my opinion.

  • RMAdventures
    Replied on February 6, 2024 at 5:52 PM

    I also need the ability to export to google sheets and have the data in separate columns.
  • Mightor JotForm Support
    Replied on February 6, 2024 at 7:13 PM

    Hi jakeschoenholz, 

    Thanks for reaching out to Jotform Support. I answered your question on a new thread. You can go ahead and check that out here

    Let us know if you have any other questions.

  • David
    Replied on February 7, 2024 at 12:37 PM

    The links for the recommended thread is not working.
  • Rayzel JotForm Support
    Replied on February 7, 2024 at 1:05 PM

    Hi David,

    Thanks for reaching out to Jotform Support. I moved your concern to a new thread and helped you with that here.

    Thanks for your understanding, we appreciate it.

  • clarkstownpd
    Replied on February 8, 2024 at 1:17 PM

    I too would be interested in this feature.
  • Harshad_P JotForm Support
    Replied on February 8, 2024 at 1:22 PM

    Hi clarkstownpd,

    Thanks for reaching out to Jotform Support. I've moved your feedback to a new thread to avoid confusion. You can check out my reply here.

    Reach out to us if you need any more help.

  • Mudhar
    Replied on February 23, 2024 at 5:13 PM

    is there any update to -> How to export all the information to Google Sheets in separate columns and not all in the same column/row?

  • Angeli JotForm Support
    Replied on February 23, 2024 at 5:17 PM

    Hi Mudhar,

    Thanks for using Jotform. I see that you also asked this question on another thread. You can check out our answer to that here.

    Let us know if you have any other questions.