- patwsAsked on December 14, 2016 at 11:40 AM
Hi, when I download my data into excel, all of the products are exported into one cell. Ie, each registrant can select one or mult of the following--- Registration, Workshop, Meal ticket, Membership---all which have different costs (and can be at Regular or Student rates.) Therefore, for me to track total costs, I have to manually enter all of this data into a separate excel file, creating a column for each option (Regular Registration, Student Registration, Regular Workshop, Student Workshop, etc etc.)
A large part of the reason we attempted online registration is so I could avoid having to manually enter the data into an excel file. This current format actually creates MORE work for me than if I were to get a paper registration form and have to enter it manually.
Does jotform have any options/ solutions for this issue?
I attached a link to our 2016 registration form. I need to create a new form for our 2017 conference, and would like to figure out if this is possible ASAP, because I am hoping to have the registration form available to our members before Christmas.
Thank you very much for your time.
Treasurer, PA Chapter of The Wildlife Society
- JotForm SupportWelvinAnswered on December 14, 2016 at 01:12 PM
Unfortunately, there is no configuration in the form builder to split the selected products item into separate columns in the excel or google spreadsheet files. A workaround would be the following:
1. Using text to columns function in Excel: https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US.
2. By installing this addon for excel: https://www.extendoffice.com/documents/excel/1786-excel-split-text-by-space.html#kutools-split-cells.
Please try it and get back to us if you need further assistance.