Exporting to an excel spreadsheet

  • Profile Image
    reba21079
    Asked on November 28, 2021 at 09:33 PM

    I sell cookies and was wondering when I export my order forms over into the excel spreadsheet if there is a way of having all of the products listed individually in their own column so that it's better to sort through all of my orders. Currently I have it where all of the products are listed in 1 column and one after another and it's hard to Sort them

  • Profile Image
    Jessica_H
    Answered on November 29, 2021 at 12:52 AM

    Hello,

    It is possible to export your submissions as Excel files. To export your submission as Excel file, please refer to the following guide: How to Export Form Data to Excel

    Let us know if you have other questions. 


  • Profile Image
    reba21079
    Answered on November 29, 2021 at 01:01 AM

    Yes I know this but if you have say 10 different products you're selling and someone orders 5. It shows them all in one column. Wondering if each product can be listed in its own individual column so you can more easily track what customer buy

  • Profile Image
    Rehan_F
    Answered on November 29, 2021 at 01:10 AM

    Greetings,

    The products in the product list are always listed in one column in the submissions. Unfortunately, they can not be separated as they are linked to the payment integration.

    I'm creating a feature request for your requirement. We the feature is accepted and implemented then we will give you an update on this ticket.

    Thanks

  • Profile Image
    reba21079
    Answered on November 29, 2021 at 11:33 AM

    That would be awesome because I used to use Google forms and this is how their excel spreadsheet would export, but I switched over to jotforms because you have alot of other options they don't have and I just really need that separation of the products to keep it more organized. Thanks!

  • Profile Image
    Hanne_L
    Answered on November 29, 2021 at 12:19 PM

    @reba21079

    Thank you for following up.

    We understand, and the escalation has already been submitted. In the meantime, perhaps this guide on separating one column into several with excel may be helpful to you.

    We appreciate your patience!