Formula to convert Csv in a Excel field in to table in other sheet

how to convert a CSV in an excel field into a table in other sheets of same excel.

I Have below data in one field of a excel sheet

[E01_LeaseFundings] DumpSql failed to verify. Mismatch : UsePayDate,InvoiceNumber Actual result: <IsApproved,UsePayDate,IsActive,IsNewlyAdded,Type,InvoiceNumber 1,1,1,0,Origination,PI01_FASB_LeScn15_842_38959 1,1,1,0,Origination,PI02_FASB_LeScn15_842_38959
> Expected result: <IsApproved,UsePayDate,IsActive,IsNewlyAdded,Type,InvoiceNumber 1,0,1,0,Origination,PI01_LeSCN15_Sprint2 1,0,1,0,Origination,PI02_LeSCN15_Sprint2
>

I want the CSV of actual in the above data as a table in other sheets

-- we can save the data as CSV and open in excel but that is consuming a lot of time so I just want to know if there is any other method available to automate this.