What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.

  • Profile Image

    How to split the submission data of Configurable List widget to multiple columns in google spreadsheet or excel?

    Asked by wallace.stevens on January 13, 2015 at 11:38 AM
    here is only one more thing I need to make this form awesome for what I am trying do.  I have the data being captured into a Google sheet but to my horror the information captured from the configuration list widget is all mashed into on field in my Google sheet. I need the data in the configuration list to be in its own column in Google sheets or excel etc.  Is there a way to do this with using CSS or another means (besides manually)?
  • Profile Image

    Answered by Shadae on January 13, 2015 at 12:48 PM

    Hi wallace.stevens,

    I do apologize, there is currently no option to separate the information in the configurable list widget, when being sent to Google Spreadsheets or to Excel.

    If you use our Grid Report, the information will be separated by columns.

    You can use commas as a separator to make columns within Excel

    Go to the Data tab and select text to columns under data tools then select delimiters and hit next. Then select comma as the delimiter and hit finish

    I hope this helps, please inform us if you need further assistance.