Is it possible to export products into different excel colums/cells?

  • Profile Image
    Asked on December 14, 2016 at 11:40 AM

    Hi, when I download my data into excel, all of the products are exported into one cell. Ie, each registrant can select one or mult of the following--- Registration, Workshop, Meal ticket, Membership---all which have different costs (and can be at Regular or Student rates.) Therefore, for me to track total costs, I have to manually enter all of this data into a separate excel file, creating a column for each option (Regular Registration, Student Registration, Regular Workshop, Student Workshop, etc etc.)

    A large part of the reason we attempted online registration is so I could avoid having to manually enter the data into an excel file. This current format actually creates MORE work for me than if I were to get a paper registration form and have to enter it manually.

    Does jotform have any options/ solutions for this issue?

    I attached a link to our 2016 registration form. I need to create a new form for our 2017 conference, and would like to figure out if this is possible ASAP, because I am hoping to have the registration form available to our members before Christmas.

    Thank you very much for your time.

    Virginia Tilden

    Treasurer, PA Chapter of The Wildlife Society

  • Profile Image
    Answered on December 14, 2016 at 01:12 PM

    Unfortunately, there is no configuration in the form builder to split the selected products item into separate columns in the excel or google spreadsheet files. A workaround would be the following:

    1. Using text to columns function in Excel:

    2. By installing this addon for excel:

    Please try it and get back to us if you need further assistance.