- AHSPTOAsked on February 09, 2016 at 12:07 PM
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.
- BorisAnswered 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:
Please let us know if there is anything else we can help you with, and we will be happy to do so.