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

    Configurable list widget data will not export in separate columns

    Asked by kendralebo on March 03, 2016 at 12:26 PM

    I created a table to easily capture information, however, when it is exported, all information in all rows are exported to one column in an excel spreadsheet. (even exporting as CSV)

    table separate columns excel CSV rows configurable list
  • Profile Image
    JotForm Support

    Answered by Welvin on March 03, 2016 at 01:48 PM

    You are using the configurable list widget. I'm sorry, but there's no currently no way you can export the data on this widget into multiple columns in excel/CSV. 

    You need to either separate them manually or try using split function in excel:

    https://support.office.com/en-us/article/Split-names-by-using-the-Convert-Text-to-Columns-Wizard-39f7b055-6b39-4cb5-9512-13cc19b3a807

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