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

    Separating payment form items with Excel

    Asked by habitatjackson on November 01, 2013 at 02:33 PM

    Hi all,

    We have a 2 forms, one for ordering poinsettias and one for buying poinsettias with a credit card. The problem is that both export the data  for the amount and color of the plants as one cell. Here is the link to the forms http://tetonhabitat.org/support-2/poinsettia-sale/
    i would like it broken out .Ideally, this is the top row of my spreadsheet that we normally use.:

     

     

    First Name

    Business

    Mailing

    City

    St

    Zip

    Email

    Phone

    Red

    White

    Total

    Total Due

    Tax Ded

    CC

    Check

    Cash

    Delivery?

    Page URL:
    http://tetonhabitat.org/support-2/poinsettia-sale/

    order form excel purchase credit
  • Profile Image
    JotForm Support

    Answered by Mike_T on November 01, 2013 at 03:55 PM

    Thank you for contacting us.

    I am sorry to inform you, but our export Excel option does not have any different layouts for the payment field.

    However, this might be possible with an Excel 'Text to Columns' option. Please check the following thread to find out instructions provided by Elton:

    Separating purchased "products" in Excel export of submission data

    If you need any further assistance, please let us know.