Separate payment product items into different columns when exported to Excel

  • Profile Image
    Asked on January 24, 2018 at 02:40 PM

    How do I set up a form that when needed will export the items purchased into separate Excel columns.  I have done several forms in the past and they have all dumped the items ordered into one column.  This then takes an exorbitant amount of time to get Excel to divide them into columns.  Sometimes, it doesn't even work.  When you have about 20 items ordered, it gets to be a long process.  

    I am looking for a way to set up the initial form that it will just do this automatically without having to waste time in Excel.

    The link I am adding is a past form we used.  I am wanting to start over this year with a new one that will do what I need it to do without more time invested.


  • Profile Image
    Answered on January 24, 2018 at 03:00 PM

    The product data are still displayed as the following into the Spreadsheet file. They are placed in a single cell.

    Unfortunately, there was no update made in this. 

    Let me escalate this to our developers instead so it would contribute to the existing requests related to this and hopefully our developers would take this into consideration. We will let you know via this thread once this is added in the future updates.

  • Profile Image
    Answered on January 24, 2018 at 03:16 PM

    Thanks.  We would need the corresponding quantity to be in a separate column, as well.  This will aid in the ordering process on our end.  In our camp situation, it will give us quick, real-time enrollment numbers.

  • Profile Image
    Answered on January 24, 2018 at 03:59 PM

    Thank you for providing more details about the requested feature. We have added them in the feature list already. 

    We will notify you here for any news/updates on the status.