Is it possible to customize the columns in the excel spreadsheet generated in reports?

  • Profile Image
    AHSPTO
    Asked on February 09, 2016 at 12:07 PM

    Good Morning,

    Is it possible to customize the data that is pushed to the excel spreadsheet from our Arcadia Auction RSVP Form?

    Specifically, I have many different choices of items that can be purchased and the spreadsheet puts everything in one column. Ideally, I'd like to have a separate column for each item.

     

    Thank you for your help.

     

    Kathy Sandler

  • Profile Image
    Boris
    Answered on February 09, 2016 at 01:54 PM

    We unfortunately cannot split the product options into multiple columns directly when exporting our Excel, since they are all answers on a single form field - and each form fields puts its data into a single column in the spreadsheet.

    However, I believe you can split the data yourself into multiple columns by using the Text To Columns function of your spreadsheet software:

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    Please let us know if there is anything else we can help you with, and we will be happy to do so.