How can I export my Configurable List widget data in the following format to upload to Campaign Monitor

Hello, I was hoping you might be able to assist me. I am attempting to create a contact submission form that allows users to submit multiple lines of data so it may be uploaded as an invite list in Campaign Monitor.

I have attempted this in your forms and then exported in CSV, however the below appears:

How can I export the data in a CSV so it appears in a ready to upload contact sheet like this?

Thank you.

Hi Sophie,

Thanks for reaching out to Jotform Support. Let me help you with exporting your Configurable List widget data in a CSV format suitable for uploading to Campaign Monitor.

The Configurable List widget allows users to enter multiple rows of data, but when exported directly to CSV, it may not appear in the flat, columnar format required by Campaign Monitor.

To achieve the format you want (with separate columns for First Name, Last Name, Email, and Type of Attendee), you will need to process the exported data outside of Jotform, such as in a spreadsheet application like Excel or Google Sheets. This involves splitting the widget's multiline data into separate rows and columns.

Here’s how you can approach this:

1. Export your form submissions as CSV from Jotform Tables or Inbox.
2. Open the CSV file in a spreadsheet program like Excel or Google Sheets.
3. Use text-to-columns or similar functions to split the Configurable List widget data into separate columns based on delimiters (such as commas or line breaks).
4. Rearrange the data so each attendee's details appear in a single row with the appropriate columns (First Name, Last Name, Email, Type of Attendee).
5. Save the file in CSV format to upload to Campaign Monitor.

Unfortunately, Jotform does not currently provide a direct export option that formats Configurable List widget data exactly like your example. Processing the data in a spreadsheet is the best way to prepare it for Campaign Monitor.

Give it a try and let us know how it goes.

The data will not allow Excel to use the text-to-column function as it changes it to the following:

How can I do this in a way that doesn't include the 'First name:' text and just the data itself?

Hi Sophie,

Thank you for your message. One of our Support Team members has now taken over this thread and will assist you further with your issue.

We will no longer be responding in this conversation, but rest assured, you will receive the help you need.

Hi Sophie,

The Configurable List widget saves all data in a single cell, so when you export to CSV, it won’t automatically split into neat columns like Campaign Monitor requires. That’s why you’re seeing concatenated text instead of a flat table format.

Currently, Jotform doesn’t have a built-in option to export Configurable List widget data directly in a multi-column format. To prepare your data for Campaign Monitor, you’ll need to process the exported CSV file in Excel or Google Sheets to split the data using the Excel Text to Columns feature.

While that feature isn’t available in Jotform right now, I’ve sent your request to our Developers for review. When or if it gets developed will depend on their current workload, how possible it is, and how much demand there is from other users. If/when we have any updates, we’ll follow up here and keep you posted.

Give it a try and let us know if you have any other questions.