How does jotform data interface with excel?

  • Profile Image
    Asked on August 19, 2011 at 03:55 PM

    can the data be automatically sorted into columns in excel?

  • Profile Image
    Answered on August 20, 2011 at 12:45 AM

    Hi Heather,

    Yes, you can collate all submissions made through your form using the Export to Excel feature. Just go to your form's submissions page and look for this button:

    Each field will be sorted and given its own column.

    Furthermore, using Excel's built in sort and filter functions, you can group entries of the same kind together,  for example same state or same color preference. You can also arrange in alphabetically or numerically in ascenting or descending order.

    We hope you find this info useful. Please let us know if you need further assistance. Thank you for using Jotform!