- bkbarnesAsked on July 19, 2016 at 10:52 AM
In our form we have a section entitled "family info" in which they add several bits of information...
First Name, Last Name, Gender, Age, Volunteer Area
When I run an Excel or CSV report all that information appears in one column on the report. I need to be able to separate them into different columns. Is there a way to do this, or rework the form to allow this. You will notice that I also need to ability to dynamically add for "family members" as needed.
- JotForm SupportJanAnswered on July 19, 2016 at 02:54 PM
I believe you are referring to the Configurable List widget. As I understand, you want to have a separate columns for each form field in the Excel Report.
Unfortunately, this is not possible in Excel or Google Sheets. The generated Excel file will create a column or a single cell for each form field. If you want to split it up into multiple columns/cell, please try using the Text-to-Columns function in MS Excel. Here's a related link: https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7
If you have any questions, let us know. Thank you.
- RMFAregistrationAnswered on December 04, 2016 at 01:48 PM
This an issue I'm dealing with right now, and I thought this 'Text-to-Columns' function in MS Excel would sort things. However, the additional rows (in the configurable list) end up just being additional columns rather than rows. It looks to me like there isn't really a good way to download the information entered into the configurable list for use in MS Excel (and eventually into MS Access which is what I want to be able to do). Or am I missing something?
- JotForm SupportWelvinAnswered on December 04, 2016 at 02:52 PM
@RMFAregistration: I will address your issue here: https://www.jotform.com/answers/1003465.