How can I create a form with more comprehensive excel output

  • Profile Image
    JaLewis
    Asked on August 31, 2016 at 03: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?

  • Profile Image
    liyam
    Answered on August 31, 2016 at 07: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.