Filling out and extracting web form data from CSV File

I have an excel file that has 20 rows and 5 columns of data. I’d like to activate Safari, go to site: www.xyz.html, and have data entered into a form corresponding to each row. Data will be filled in from column 1 to column 5. After row 1’s data is entered, I need to extract a result from the form submission and place this information into column 6 of every row. This script needs to be looped for all 20 row items.

I can easily convert the data to a flat binary - csv file if it makes this task simpler to handle. I am hoping someone has a “barebones” script in place that will allow me to do this. Much appreciated.

Sorry, meant to say data will be entered from column 2 to column 5. Column 1 simply lists each row heading.