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

    Purchase Order field all products are in single cell when exported to Excel

    Asked by TututheMoon on August 17, 2014 at 04:32 AM
    I'm using purchase order tool and its still doing one cell for all the item :(
  • Profile Image
    JotForm Support

    Answered by jonathan on August 17, 2014 at 04:32 PM


    I checked your form http://www.jotform.us/form/42206418557152

    If I understand correctly, you must be referring to the sub-products as those that are still in the single cell when the form submission is exported to Excel or spreadsheet.


    Unfortunately, with the way your Purchase Order tool is setup, we could not make a workaround that can separate the sub-products form the main items.

    If there is no sub-product in the main items, the main items will be in separate cell each when you export them to Excel.

    You will probably need to manually do the alteration on the Excel sheet after downloading the submissions.

    Hope this clarify the matter. Inform us if there is more we can assist you with.



  • Profile Image

    Answered by TututheMoon on August 18, 2014 at 08:31 AM

    I followed all the instruction I the wizard to set up but when I export it to excel the whole purchase order items area is In one cell instead of it separating as you showed above.

  • Profile Image

    Answered by jedcadorna on August 18, 2014 at 10:59 AM

    Sorry but those sub-products can't be separated since they are in one product. You'll have to manually edit your excel file to separate the sub-products like what my colleague suggest you to do.

    This is how the payment products is designed even if you use other payment option you'll get same result.