Configurable list - split values into separate columns in Excel

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

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. 

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
...

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

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.

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.

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.

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
...

Forgot to ask!

Thanks
...

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!