I have a spreadsheet in excel which is a large list of several rows and 5 columns. I need to insert the data of this worksheet into a website (html form), each cell in its respective field, save and select a specific button of the page (eg, simulate the mouse click on a button). Then register the next product data and repeat this action for all products in the list.
Each product has an ID, and in the page of the site (where the data will be inserted), there is a search field where the ID must be inserted, the search button must be pressed to enter the product registration page , where excel data should be entered.
This list of products is received almost weekly. Registering one by one manually is time consuming and laborious. The idea is to automate through a script, but as I'm still learning programming, I do not know in what language it can be developed or where to start.
I would like help with the indication of some language, lesson, handout, explanation or any material that would help me to develop this project.