How to make items into separate columns?

  • Profile Image
    Asked on October 26, 2020 at 05:59 PM

    Hi there! My order form is working great except that when it imports the info to Google Sheets, the items are all in one cell rather than being put into a separate cell for each one. Can Jotform do this or do I need to manually do this from invoices?

  • Profile Image
    Answered on October 26, 2020 at 10:07 PM

    Your options are:

    1). Create a custom payment field which you will need to separate the products into different fields.


    2). You can try this workaround using the Excel's TEXT-to COLUMN function: 

    Let us know if you have any questions or if you need further assistance.