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 there a way to parse out paypal products so they don't all end up in one cell in excel?Asked by RFFOD on February 24, 2014 at 04:56 PM
We are using paypal in our form and users are able to select mutiple products plus quantities and sizes. When I download the data to excel, all of this information ends up in one cell for that transaction. This makes it nearly impossible to total what people have purchased other than manually. Is there a way to change this so the various items are downloaded into multiple excel cells?
Unfortunately, it is not possible as of the moment. A workaround is to separate them with excel formula. Please refer to this guide for a similar output. http://www.jotform.com/answers/214003. If you have difficulties, let us know the form in question so we can provide you example.