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.
Is it possible to export products into different excel colums/cells?Asked by patws 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
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.