How to add string of csv data into new records via collection ?

Hi,

I wonder if there is a way to turn a string containing csv values into a format suitable for adding as individual records into a report. This is my example data :

Date,Code,Station Name,VALUE 1,VALUE 2,VALUE 3
15-Jul-20,EGAA,StationA,1,10,20
15-Jul-20,EGBB,StationB,2,11,21
15-Jul-20,EGCC,StationC,3,12,22
15-Jul-20,EGCN,StationD,4,13,23

My thought is I need to create a collection and then add the string data to it, then iterate through the collection to add the record. I can see help files for creating blank collections, but not how to add existing data to those collections - especially when the headers are contained in the string rather than me having to create it manually.

a) Is creating a collection the right method to handle data like this ?

b) How do I convert the string of comma separated values into a collection ?

Many thanks