How to customize form to produce desired Excel report format?

  • Profile Image
    alphaemc
    Asked on January 11, 2018 at 03:41 PM

    I used a widget to create the form at the URL below. However, when exporting to an Excel report, it dumps all of the widget data into a single cell. How can I modify or create the report so that each field of widget data is placed into separate cells under their own column headings (see attached "Requested Excel Report Format.PNG")?

  • Profile Image
    Marvih
    Answered on January 11, 2018 at 04:34 PM

    Unfortunately, all data coming from a widget is grouped up in a single cell. This is how it is built same with the other widgets.

    However, there is a workaround for this which is discussed on this thread.
    https://www.jotform.com/answers/290516-How-to-separate-payment-product-data-into-separate-excel-columns

    This should also work on your "Matrix Dynamique" widget.

    Let us know if you need further help.

  • Profile Image
    alphaemc
    Answered on January 11, 2018 at 05:43 PM
    Thank you but this will not work for me. Can you suggest an alternative to using the widget that will give me what I want?
    Regards,
    Steve Roche
    Director of Operations
    Alpha E.M.C.
    1511 East State Road 434, Suite 3017
    Winter Springs, FL 32708
    Office: 407-542-0300 x117
    [cid:image001.jpg@01D23362.0B4C5850]
    ...
  • Profile Image
    Marvih
    Answered on January 11, 2018 at 06:22 PM

    I don't think it is possible since we cannot change the settings (Single cell per widget)on how the submission data is recorded to excel.

    You might want try using a Grid Listing Report.

    1515712858403.png

    And copy the data inside the table manually to your Excel file, data will be on each cell after pasting to Excel.