Have you made improvements to the way the form information downloads into Excel?

  • Profile Image
    Asked on July 14, 2015 at 03:49 PM

    I am new to my position and working with Jotform, but I am aware that last year, the information that downloaded into Excel placed ALL events for which one person was registered into one cell. Therefore, it was impossible to sort for the registrations of each event. Each event then had to be cut-and-pasted into separate cells, creating hours of unnecessary work.

    Has this issue been resolved to that separate events for which a person registers are populated into separate cells?

  • Profile Image
    Answered on July 14, 2015 at 07:19 PM


    It depends on how you collect the data.  If you are collecting all the information for the events the person registered for in a single field, then yes, the data will be in a single cell in the spreadsheet.  If you are using a configurable list widget or a matrix of some sort that collects a large amount of data in a single field, this data will be reported as a single entry.

    If you are collecting the data using multiple fields, for example using a separate field to collect their name and another to collect their address, the data collected in those fields would be entered into separate cells in the spreadsheet. 

    It all comes down to if you are using a single field that allows multiple data entries or multiple fields that allow for a single entry each.

  • Profile Image
    Answered on July 22, 2015 at 01:52 PM

    We are still having challenges and questions regarding using multiple events for our Homecoming registration. A number of the events require payment. If each event is a separate (Payment Wizard?), how will it calculate a grand total.

    Do you have a tutorial that can show this?

  • Profile Image
    Answered on July 22, 2015 at 02:03 PM

    To have everything separated out, you would use regular fields and calculations values:


    You would then total up those calculations in a calculation widget:


    After you have your total calculation set up, you can pass the total to your payment field:


    This would allow you to break your selections up into separate fields, then send the grand total to your payment field.  If the forum slows down, I'll setup a test form with some of the selections setup.