Exporting to Excel

Hi.  I love that I can export my submissions into an excel spreadsheet.  Is there a way to separate the products ordered into their own columns?  At the moment it is putting all the products and quantities in one column.  This makes it difficult to see and organize.  It there a way for each product to have its own column?

thanks!

Currently, any data that is captured in a single field is exported to a single cell in spreadsheets.  If you would like to have separate products and options exported in separate cells, it would require setting up your products and options outside of the payment field. 

This can be done using whatever type of fields best suits your options.  Number fields for quantity options, checkbox fields for multiple selections, single select fields for single choice fields etc. 

Once you have your options set up, you can assign calculation values to options:

https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

Then perform calculations on those values and other forms entries:

https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

Once you have your total, you can pass that total to the payment field:

https://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field

This way, you products and options won't all be contained in a single field.