Column not appearing in Excel Report

Hi I have created a form with a product listing but the quantity field is not appearing as a seperate column in the excel report but is merged in one column with the product, making the listing difficult to use. can you help?

Hi Chloe,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Regarding the quantity field not appearing as a separate column in your Excel report, currently, Jotform merges the product and quantity into one column in the report. Unfortunately, there is no built-in option to separate them automatically.

However, you can manually split the data into separate columns using Excel's Text to Columns feature. Here is a helpful guide on how to do that: Split Text into Different Columns in Excel.

Let me know if you need any further assistance.

Give it a try and let us know how it goes.

Hi Chloe,

Unfortunately, it's not possible to have different columns for the name, price, quantity, and product details of the product list. I've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.