What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by AHSPTO 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

    Screenshot
    Reports excel Excel spreadsheet
  • Profile Image
    JotForm Support

    Answered by Boris 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.