How to separate Configurable List data into separate columns in an Excel sheet?

  • vimlapwr
    Asked on August 28, 2018 at 7:38 AM

    The configures table widget in the form is showing as one entry in excel sheet. Can I get in different columns as per the configuration table. 

  • roneet
    Replied on August 28, 2018 at 11:07 AM

    Currently, there is no option to separate the information into the configurable list widget, when being sent to the Excel sheet.

    1. If you use our Grid Report, the information will be separated by columns.

    2. You can split the data manually with the help of Text-to-column feature in Microsoft Excel.

    This guide will help you: 

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    You can use commas as a separator to make columns within Excel

    Go to the Data tab and select text to columns under data tools then select delimiters and hit next. Then select comma as the delimiter and hit the finish

    3. Also, you can modify your form and use individual Date and Time and Textbox fields. You can align them into three columns using our field positioning feature:

    http://www.jotform.com/help/90-Form-Field-Positioning

    I hope this helps, please inform us if you need further assistance.

    Thanks.