Separate Payment submision info into different columns

 I am building a form for use with a website we are developing. I am using a few form companies to see which most closely matches our needs.

I noticed that submission data gets saved to a sheet but not all data seems to be saved. For instance I need to save the COUPON CODE in a separate field as well as the amount paid by SUBTOTAL, and TAX for my records.

I see this information is all provided in the download XLS option but it is not in a usable format. Is there a way to make them separate columns? Otherwise someone would have to go through by hand and copy and paste info. Why would Jotform provide information like this?

Is there a fix or a workaround?

Unfortunately, the resulting data in Payment submissions are contained on single-cell only because it was using the Payment tool's API and not just the interface in JotForm side alone. 

So there must be a limitation on what the developer can achieve if the API (of payment tool) has restrictions and limitations as well.

One workaround is to download a copy of the submissions into an Excel file and use the Text-to-Columns feature. It might be a little tedious though.

Another workaround is to create the products outside the payment field and use traditional dropdown and checkboxes then do the calculation in a Form Calculation widget.

As soon as the value is calculated, you may pass the value to the user-defined amount in the Payment field.

Please refer to this guide on How-to-Pass-a-Calculation-to-a-Payment-Field.