Configurable list - split values into separate columns in Excel

  • Profile Image
    zremmach
    Asked on March 11, 2020 at 10:43 PM

    Hi there!

    Could you help with the reporting. I would need to get a report (Excel ) from my form, here is the link:


    https://form.jotform.com/200514851951250


    Page URL:
    zakrem@cfib.ca

  • Profile Image
    Jed_C
    Answered on March 11, 2020 at 11:44 PM

    Here's a guide on how you can create an excel report https://www.jotform.com/help/101-How-to-Create-an-Excel-Report

    You can also export the submission in excel, please check this guide https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    Let us know if you have any questions or if you need further assistance. 

  • Profile Image
    zremmach
    Answered on March 12, 2020 at 09:29 AM

    Hi!
    I know already how to do excel ...etc, the issue is about the data are put
    all in a row which is not easy to separate into columns, any thoughts
    would be helpful. Or if you can suggest another widget that can help me get
    the same data but exported in a separate columns, I am looking to buy a
    membership from not firm but I need that the tool do what I am looking for.
    If you have a phone number I can call you. 
    Thanks
    ...

  • Profile Image
    JohnRex
    Answered on March 12, 2020 at 10:19 AM

    I assume that you are trying to separate the data of the Configurable List widgets that are added to your form. Am I correct?

    15840225432205850.png

    Currently, there is no option to separate the values entered in a configurable list widget when being viewed in the Submissions Page or exported to an Excel file. But, you can try these two workarounds below:

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

    15653034271920956.png

    2. You can split the data manually with the help of Text-to-column feature of Microsoft Excel.

    This guide will help you: 

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    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. It shall separate the field's data into separate columns.

    Please try that and let us know how it goes.

  • Profile Image
    JohnRex
    Answered on March 12, 2020 at 10:21 AM

    Also, we do not offer live phone support at the moment but feel free to write down your concerns on this forum and we'll be more than happy to assist you.

  • Profile Image
    zremmach
    Answered on March 12, 2020 at 11:29 AM
    Thank you!
    The data grid do not allow the participants (people who will fill out the
    form) to add more lines, I have tried it first.
    I know about the text to columns process. it's not perfect as I will
    receive and process data in a short time.
    Any VBA Code to help me? or any CSS code?
    Also I wanted to know for the free version, is there alimit of the
    number of forms submitted by month?
    All the best
    ...
  • Profile Image
    zremmach
    Answered on March 12, 2020 at 11:29 AM
    Forgot to ask!
    How may I know who submitted the form? because I receive an email with the
    data in my inbox, and do the people who submitted the form receive a
    confirmation email?

    Thanks
    ...
  • Profile Image
    FelipeSantana
    Answered on March 12, 2020 at 12:22 PM

    Hi @zremmach!

    I would like to apologize for the inconvenience you are experiencing.

    Unfortunately, we will not be able to add any CSS code to alter the style of the excel report. The CSS codes can be added to your form for style changes but not any of the reports.

    As for the VBA code, I would suggest taking a look at the following StackOverflow thread about using VBA in excel to make rows into columns: https://stackoverflow.com/questions/37545372/excel-vba-code-to-transpose-data-from-rows-to-columns

    Now, for your next questions, I will be separating them into another thread to avoid any confusion among your inquiries. You can find the answers to your new questions via this thread: https://www.jotform.com/answers/2206829

    Please let us know if you require any further assistance regarding this issue, we will be happy to help!