Why Are Certain Fields Not Exporting Into Separate Columns

All of the forms on my site are built with the elementor form widget. When I export the data, the following columns are exported id, submittedOn, formID, postID, email, message, submittedBy, formData, status, and cdate. This information is very much appreciated, but the data essential to my client is the data found in the “formData” column.

My client wants a spreadsheet the shows the columns email, first name, last name, phone number, and cdate. The email and cdate are no problem; they are extracted and presented in columns without extra editing. The data in the first name, last name, and phone number fields are all combined in the formData column.

When I export the form entries using your plugin’s export as CSV, the entries in each cell of the formData column looks similar to this:
a:6:{i:0;a:2:{s:5:”label”;s:10:”First Name”;s:5:”value”;s:7:”Website”;}i:1;a:2:{s:5:”label”;s:9:”Last Name”;s:5:”value”;s:7:”Visitor”;}i:2;a:2:{s:5:”label”;s:5:”Email”;s:5:”value”;s:24:”[email protected]”;}i:3;a:2:{s:5:”label”;s:12:”Phone Number”;s:5:”value”;s:10:”9095551212″;}i:4;a:2:{s:5:”label”;s:21:”Comments or Questions”;s:5:”value”;s:0:””;}i:5;a:2:{s:5:”label”;s:17:”Google Mandatory “;s:5:”value”;s:0:””;}}

I prefer the data to be in columns based on the label with each entry’s value in a separate cell. So that, at the very least, I could see the name and phone entries in three columns. The email is already being extracted and exports into a separate column, but I would not have a problem with it being displayed twice. I hope you can export the form data into columns so that it appears like the following:

First Name | Last Name | Email | Phone | Comments | Google
Website | Visitor | [email protected] | 9095551212 | |

At this point, I must take the additional steps and edit the CSV file created by your plugin.

The page I need help with: [log in to see the link]