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.
How to get better reporting (Excel/CSV) on products orders?Asked by mendysas on September 01, 2014 at 02:26 PM
In the submissions report it combines all products in one field.
As it is now, it is not possible to see how many of the same product were ordered. All you see is that each order has multiple items in the same field.
How can I get a report showing each product separately?
separate products product per cell excel report
Thank you for contacting us.
You can either doubleclick on the product cell to wrap the text, or select the product cells and use the Excel Wrap Text option. In this way, you will get the products listed on their separate lines:
In case you would like to see a single product per cell, please consider a workaround from the following thread:
I will also attach a feature request ticket to see if we can add some improvements in order to avoid these extra manipulations with the Excel reports.
We will let you know if we have any updates on this.
You may also like to try JotForm's visual reports to see which products or answers were chosen. Creating is possible via forms->reports->visual reports.