How can I create a form with more comprehensive excel output

  • JaLewis
    Asked on August 31, 2016 at 3:59 PM

    I just changed the format of my forms from donation to product sales.... and now when I try to export to excel for processing and record keeping, all of my products are in one cell. I would do a simple "text to column" fix, however the data is not even aligned in a way that makes that possible (at least for my limited knowledge of excel)

    SO... should I make separate "product fields" on my form? and if so... how?

  • liyam
    Replied on August 31, 2016 at 7:15 PM

    Hello JaLewis,

    Unfortunately there is no feature to format your excel to separate the products to different columns. But you might want to look into this solution provided by my colleague to have it separated manually:

    https://www.jotform.com/answers/290516-How-to-seperate-payment-product-data-into-seperate-excel-columns

    Thanks.